Saturday, March 14, 2009
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.
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
Subscribe to:
Posts (Atom)