I'm new to sql server and mysql but this seems like it should be a pretty straight forward jdbc connection. But I have spent almost 2 days just trying to get a jdbc connection. Please help if you can.
I'm using Eclipse 3.2.2 and I have installed mysql-connector-java-5.0.6-bin.jar. I am trying to connect to SQL Enterprise Manager version 8.0 innstall on a Windows 2003 Server Enterprise Edition.
I have been able to successfully test connectivity using Windows ODBC Data Sources so I know the connection parameters are correct. The test app throws an exception on getConnection;
------------------
String url = "jdbc:mysql ://168.177.1.89:14 33/PSS?user=test&p assword=test1&u seReadAheadInpu t=false&useUnbu fferedInput=tru e");
String driverClass = "org.gjt.mm.mys ql.Driver";
Class.forName(d riverClass);
Connection connection = DriverManager.g etConnection(ur l);
-------------------
Here is the entire exception:
SQLException: 0:Communication s link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
com.mysql.jdbc. CommunicationsE xception
MESSAGE: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.Socket Exception
MESSAGE: Connection reset
STACKTRACE:
java.net.Socket Exception: Connection reset
at java.net.Socket InputStream.rea d(Unknown Source)
at com.mysql.jdbc. MysqlIO.readFul ly(MysqlIO.java :1953)
at com.mysql.jdbc. MysqlIO.readPac ket(MysqlIO.jav a:558)
at com.mysql.jdbc. MysqlIO.doHands hake(MysqlIO.ja va:1029)
at com.mysql.jdbc. Connection.crea teNewIO(Connect ion.java:2749)
at com.mysql.jdbc. Connection.<ini t>(Connection.j ava:1553)
at com.mysql.jdbc. NonRegisteringD river.connect(N onRegisteringDr iver.java:285)
at java.sql.Driver Manager.getConn ection(Unknown Source)
at java.sql.Driver Manager.getConn ection(Unknown Source)
at org.utah.traffi c.factory.Mysql ConnectionFacto ry.createConnec tion(MysqlConne ctionFactory.ja va:13)
at org.utah.traffi c.dlConv.test.D lTest.main(DlTe st.java:54)
** END NESTED EXCEPTION **
Last packet sent to the server was 16 ms ago.
STACKTRACE:
com.mysql.jdbc. CommunicationsE xception: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.Socket Exception
MESSAGE: Connection reset
STACKTRACE:
java.net.Socket Exception: Connection reset
at java.net.Socket InputStream.rea d(Unknown Source)
at com.mysql.jdbc. MysqlIO.readFul ly(MysqlIO.java :1953)
at com.mysql.jdbc. MysqlIO.readPac ket(MysqlIO.jav a:558)
at com.mysql.jdbc. MysqlIO.doHands hake(MysqlIO.ja va:1029)
at com.mysql.jdbc. Connection.crea teNewIO(Connect ion.java:2749)
at com.mysql.jdbc. Connection.<ini t>(Connection.j ava:1553)
at com.mysql.jdbc. NonRegisteringD river.connect(N onRegisteringDr iver.java:285)
at java.sql.Driver Manager.getConn ection(Unknown Source)
at java.sql.Driver Manager.getConn ection(Unknown Source)
at org.utah.traffi c.factory.Mysql ConnectionFacto ry.createConnec tion(MysqlConne ctionFactory.ja va:13)
at org.utah.traffi c.dlConv.test.D lTest.main(DlTe st.java:54)
** END NESTED EXCEPTION **
Last packet sent to the server was 16 ms ago.
at com.mysql.jdbc. MysqlIO.readPac ket(MysqlIO.jav a:626)
at com.mysql.jdbc. MysqlIO.doHands hake(MysqlIO.ja va:1029)
at com.mysql.jdbc. Connection.crea teNewIO(Connect ion.java:2749)
at com.mysql.jdbc. Connection.<ini t>(Connection.j ava:1553)
at com.mysql.jdbc. NonRegisteringD river.connect(N onRegisteringDr iver.java:285)
at java.sql.Driver Manager.getConn ection(Unknown Source)
at java.sql.Driver Manager.getConn ection(Unknown Source)
at org.utah.traffi c.factory.Mysql ConnectionFacto ry.createConnec tion(MysqlConne ctionFactory.ja va:13)
at org.utah.traffi c.dlConv.test.D lTest.main(DlTe st.java:54)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.:Communicat ions link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
com.mysql.jdbc. CommunicationsE xception
MESSAGE: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.Socket Exception
MESSAGE: Connection reset
STACKTRACE:
java.net.Socket Exception: Connection reset
at java.net.Socket InputStream.rea d(Unknown Source)
at com.mysql.jdbc. MysqlIO.readFul ly(MysqlIO.java :1953)
at com.mysql.jdbc. MysqlIO.readPac ket(MysqlIO.jav a:558)
at com.mysql.jdbc. MysqlIO.doHands hake(MysqlIO.ja va:1029)
at com.mysql.jdbc. Connection.crea teNewIO(Connect ion.java:2749)
at com.mysql.jdbc. Connection.<ini t>(Connection.j ava:1553)
at com.mysql.jdbc. NonRegisteringD river.connect(N onRegisteringDr iver.java:285)
at java.sql.Driver Manager.getConn ection(Unknown Source)
at java.sql.Driver Manager.getConn ection(Unknown Source)
at org.utah.traffi c.factory.Mysql ConnectionFacto ry.createConnec tion(MysqlConne ctionFactory.ja va:13)
at org.utah.traffi c.dlConv.test.D lTest.main(DlTe st.java:54)
** END NESTED EXCEPTION **
Last packet sent to the server was 16 ms ago.
STACKTRACE:
com.mysql.jdbc. CommunicationsE xception: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.Socket Exception
MESSAGE: Connection reset
STACKTRACE:
java.net.Socket Exception: Connection reset
at java.net.Socket InputStream.rea d(Unknown Source)
at com.mysql.jdbc. MysqlIO.readFul ly(MysqlIO.java :1953)
at com.mysql.jdbc. MysqlIO.readPac ket(MysqlIO.jav a:558)
at com.mysql.jdbc. MysqlIO.doHands hake(MysqlIO.ja va:1029)
at com.mysql.jdbc. Connection.crea teNewIO(Connect ion.java:2749)
at com.mysql.jdbc. Connection.<ini t>(Connection.j ava:1553)
at com.mysql.jdbc. NonRegisteringD river.connect(N onRegisteringDr iver.java:285)
at java.sql.Driver Manager.getConn ection(Unknown Source)
at java.sql.Driver Manager.getConn ection(Unknown Source)
at org.utah.traffi c.factory.Mysql ConnectionFacto ry.createConnec tion(MysqlConne ctionFactory.ja va:13)
at org.utah.traffi c.dlConv.test.D lTest.main(DlTe st.java:54)
** END NESTED EXCEPTION **
Last packet sent to the server was 16 ms ago.
at com.mysql.jdbc. MysqlIO.readPac ket(MysqlIO.jav a:626)
at com.mysql.jdbc. MysqlIO.doHands hake(MysqlIO.ja va:1029)
at com.mysql.jdbc. Connection.crea teNewIO(Connect ion.java:2749)
at com.mysql.jdbc. Connection.<ini t>(Connection.j ava:1553)
at com.mysql.jdbc. NonRegisteringD river.connect(N onRegisteringDr iver.java:285)
at java.sql.Driver Manager.getConn ection(Unknown Source)
at java.sql.Driver Manager.getConn ection(Unknown Source)
at org.utah.traffi c.factory.Mysql ConnectionFacto ry.createConnec tion(MysqlConne ctionFactory.ja va:13)
at org.utah.traffi c.dlConv.test.D lTest.main(DlTe st.java:54)
** END NESTED EXCEPTION **
Last packet sent to the server was 0 ms ago.:[Ljava.lang.Stac kTraceElement;@ 1cb25f1