Hi:
I am using JSF,Hibernate amd Mysql in my project.
I have written update query as,
Code:
update payslipmaster set instrumentNo=3 where memberNo=3733
But at compile time it will be converted like,
Code:
update payslipmaster[b],[/b] set instrumentNo=3 where memberNo=3733
And error generated as follows,
com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'set instrumentNo=3 where memberNo=3733' at line 1
So can anybody help me to solve this issue?
Thank You,
Anup
Login
FAQ
Search