MySQL Forums
Forum List  »  Other Migration

MySQL Connector Problem after Migration
Posted by: Joe T.
Date: May 14, 2010 12:39PM

Hello,
i am running a Java-Tool, which is connecting via localhost to my MySQL Database.
The Tool always worked fine. Now i changed server, and i get a strange error message, when trying to connect. I guess this has someting todo with the database migration or something.

Quote

Creating sql connections
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
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1051)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3562)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3494)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1960)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2114)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2690)
at com.mysql.jdbc.ConnectionImpl.configureClientCharacterSet(ConnectionImpl.java:1862)
at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3596)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2202)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:787)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:353)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at java.sql.DriverManager.getConnection(libgcj.so.90)
at java.sql.DriverManager.getConnection(libgcj.so.90)
at de.empirephoenix.test.SqlCon.create(SqlCon.java:41)
at de.empirephoenix.test.SqlCon.main(SqlCon.java:17)

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Connector Problem after Migration
3649
May 14, 2010 12:39PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.