Hi,Iam Jaya.The problem you mentioned is not the reason why the code is failing.Type casting is possible.They are convertible types.There may be some other reason for the failure.Please give more details.
Joined: Dec 06, 2008
So this is the error:
but the syntax is ok I already verify it in sql. if I put (Date) instead of (String) I don't get any errors but the update is not working when I look in the database.
You need a space between 'where' and 'datav' - and replace the last 'where' with an 'and'.
Normally you will have saved the date as a DATE or TIMESTAMP field in the database, and in Java you will pass the argument to the Statement as a java.sql.Date [ December 31, 2008: Message edited by: Rene Larsen ]