MySQLSyntaxErrorException near “?” when trying to execute PreparedStatement

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 ‘? or MemberName = ?’ at line 1

MySQL doesn’t understand the meaning of ? in the SQL query. It’s indeed invalid SQL syntax. So somehow it’s not been replaced by PreparedStatement. And guess what?

PreparedStatement s = conn.prepareStatement(query);
s.setInt(1, intValue);
s.setString(2, strValue);        
rs = s.executeQuery(query); // Fail!

You’re overridding the prepared query with the original query! You need to call the argumentless PreparedStatement#executeQuery() method instead of Statement#executeQuery(String).

PreparedStatement s = conn.prepareStatement(query);
s.setInt(1, intValue);
s.setString(2, strValue);        
rs = s.executeQuery(); // OK!

Unrelated to the problem, your code is leaking resources. The DB will run out of them after several hours and your application will crash. To fix this, you need to follow the JDBC idiom of closing Connection, Statement and ResultSet in the finally block of the try block where they’re been acquired. Check the JDBC basic tutorial for more detail.

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. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  4. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  5. Multiple queries executed in java in single statement
  6. Java: Insert multiple rows into MySQL with PreparedStatement
  7. ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long on connect to MySQL
  8. Handling MySQL datetimes and timestamps in Java
  9. MySQL and JDBC with rewriteBatchedStatements=true
  10. Closing JDBC Connections in Pool
  11. No suitable driver found for ‘jdbc:mysql://localhost:3306/mysql [duplicate]
  12. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  13. Returning a ResultSet
  14. How to change MySQL timezone in a database connection using Java?
  15. How to configure Tomcat to connect with MySQL
  16. Retrieve an Image stored as BLOB on a MYSQL DB
  17. Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]
  18. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  19. mysql prepared statement error: MySQLSyntaxErrorException
  20. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  21. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  22. MySQL connector error “The server time zone value Central European Time” [duplicate]
  23. How to correctly write UTF-8 strings into MySQL through JDBC interface
  24. java.sql.SQLException: Before start of result set [duplicate]
  25. Stumped SQL Exception for JDBC
  26. MySQL & Java – Get id of the last inserted value (JDBC) [duplicate]
  27. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  28. java.sql.SQLException: No database selected – why?
  29. JDBC MySQL connection using Unix Socket
  30. JDBC connection error : unrecognized timezone [duplicate]

Leave a Comment