- This topic has 3 replies, 2 voices, and was last updated 12 years, 2 months ago by support-joy.
-
AuthorPosts
-
ahaduMemberI’m using MyEclipse 9 and trying to connect to MySQL DB on my localhost.
I have installed the jdbc.jtds 1.2.6 Driver and when I test the connection I get a really strange error:
Error while performing database login with the JDBC driver
the stack trace in MyEclipse goes:
java.sql.SQLException: I/O Error: Unknown packet type 0x48
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2311)
at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:603)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:345)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at net.sourceforge.squirrel_sql.fw.sql.SQLDriverManager.getConnection(SQLDriverManager.java:99)
at com.genuitec.eclipse.sqlexplorer.actions.LoginProgress$Login.run(LoginProgress.java:48)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.io.IOException: Unknown packet type 0x48
at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:857)
at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:727)
at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)
at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2206)
… 7 moreCan anybody help?
Thanks
support-joyMemberahadu,
jdbc.jtds 1.2.6 Driver is not the driver which is used for MySQL connection. You have to download for example mysql-connector-java-5.1.7 jar file to get the MySQL connection working.Please download the jar file which is compatible with your mysql version.
Take a look at this for detailed information – http://www.myeclipseide.com/documentation/quickstarts/dbtools/
Let us know if you see any issues.
ahaduMemberYep, I got mysql-connector-java-5.1.22 and it works like a charm, Thanks support-joy!
support-joyMemberahadu,
Glad that you got it working.
Do let us know if you have any issues. -
AuthorPosts