Stumped SQL Exception for JDBC

by

Those are the relevant parts:

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 '????????????????' at line 1
    ...
    com.mysql.jdbc.ConnectionImpl.configureClientCharacterSet(ConnectionImpl.java:1890)
    ...
    java.sql.DriverManager.getConnection(libgcj.so.10)

Those question marks indicate a serious character encoding problem during the query to configure the client charset.

As first try, open the my.cnf file and ensure that the following two entries are present:

character_set_server=utf8
collation_server=utf8_general_ci

As second try, replace the GCJ by OpenJDK or Oracle (Sun) JDK which are way more robust. The GCJ is namely known to have its oddities.

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. Java: Insert multiple rows into MySQL with PreparedStatement
  6. ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long on connect to MySQL
  7. Cannot issue data manipulation statements with executeQuery()
  8. Handling MySQL datetimes and timestamps in Java
  9. Closing JDBC Connections in Pool
  10. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  11. Java JDBC Access denied for user [closed]
  12. Retrieve an Image stored as BLOB on a MYSQL DB
  13. Can I execute multiple queries separated by semicolon with MySQL Connector/J? [duplicate]
  14. Connection Java – MySQL : Public Key Retrieval is not allowed
  15. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  16. JDBC returning MySQLSyntaxError Exception with correct statement
  17. mysql prepared statement error: MySQLSyntaxErrorException
  18. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  19. Problems reading/writing UTF-8 data in MySQL from Java using JDBC connector 5.1
  20. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  21. MySQL connector error “The server time zone value Central European Time” [duplicate]
  22. com.mysql.jdbc.PacketTooBigException
  23. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server [duplicate]
  24. Should a database connection stay open all the time or only be opened when needed?
  25. How to correctly write UTF-8 strings into MySQL through JDBC interface
  26. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  27. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  28. A persistent connection with JDBC to MySQL
  29. JDBC MySQL connection using Unix Socket
  30. JDBC connection error : unrecognized timezone [duplicate]

Leave a Comment