JDBC returning MySQLSyntaxError Exception with correct statement

by

com.mysql.jdbc.exceptions.jdbc4.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 ‘? , ? , DEFAULT , NULL )’ at line 1

Those placeholders ? should not appear in the MySQL side at all.

Look here,

sInserim.executeUpdate(sqlCommandInserim);

you’re passing the raw SQL string into executeUpdate() instead of executing the PreparedStatement with the set values.

Replace it by

sInserim.executeUpdate();

The executeUpdate(sqlString) should be used on Statement only.

Unrelated to the concrete problem, you should be closing the PreparedStatement in the finally block to prevent resource leaking in case of exceptions. The same applies to Connection, Statement and ResultSet by the way.

More Related Contents:

  1. SQL syntax error in "insert into 'keys'(a,b,c,d,e) values(?,?,?,?,?)" [closed]
  2. Hours and seconds are lost when storing a date in the database [closed]
  3. Multiple queries executed in java in single statement
  4. Java: Insert multiple rows into MySQL with PreparedStatement
  5. Android JDBC not working: ClassNotFoundException on driver
  6. ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long on connect to MySQL
  7. MySQL and JDBC with rewriteBatchedStatements=true
  8. Closing JDBC Connections in Pool
  9. No suitable driver found for ‘jdbc:mysql://localhost:3306/mysql [duplicate]
  10. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  11. “Loading class com.mysql.jdbc.Driver … is deprecated” message
  12. Returning a ResultSet
  13. How to change MySQL timezone in a database connection using Java?
  14. How to configure Tomcat to connect with MySQL
  15. Java JDBC MySQL exception: “Operation not allowed after ResultSet closed”
  16. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  17. Retrieve an Image stored as BLOB on a MYSQL DB
  18. Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]
  19. mysql prepared statement error: MySQLSyntaxErrorException
  20. how to get list of Databases “Schema” names of MySql using java JDBC
  21. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  22. Access denied for user ‘root’@’localhost’
  23. How to correctly write UTF-8 strings into MySQL through JDBC interface
  24. Glassfish Admin Console throws java.lang.IllegalStateException when creating JDBC Pool
  25. java.sql.SQLException: Before start of result set [duplicate]
  26. How to use prepared statement for select query in Java?
  27. Stumped SQL Exception for JDBC
  28. MySQL & Java – Get id of the last inserted value (JDBC) [duplicate]
  29. How to connect to a remote MySQL database with Java?
  30. java.sql.SQLException: No database selected – why?

Leave a Comment