Saturday, February 28, 2009

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server vers

------------:sql error:-------

1.
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 ''something','something')' at line 1


2. the above error occurs when u have wrote some syntax error in ur programm
for example : -- pst.prepareStatement("insert into tablename(?,?");-----this is wrong
:--pst.prepareStatement("insert into tablename values(?,?");----- this is right

3. my advice is see insert command syntax for errors

4.have a nice day