Witam,
Prubuje się połączyć z bazą mysql za pomocą pkietu mysql connector i dostaje taki oto komunikat:
Exception in thread "main" java.sql.SQLException: Communication link failure: java.io.IOException, underlying cause: Unexpected end of input stream
- BEGIN NESTED EXCEPTION **
java.io.IOException
MESSAGE: Unexpected end of input streamSTACKTRACE:
java.io.IOException: Unexpected end of input stream
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1096)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:626)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562)
at com.mysql.jdbc.Connection.<init>(Connection.java:491)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at database.MySQLAccess.readDataBase(MySQLAccess.java:40)
at database.access_test.main(access_test.java:6)
- END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:699)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1562)
at com.mysql.jdbc.Connection.<init>(Connection.java:491)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:346)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at database.MySQLAccess.readDataBase(MySQLAccess.java:40)
at database.access_test.main(access_test.java:6)
kod w którym sięwykrzacza to:
String user = "xxxx";
String password = "xxx";
String url = "jdbc//SERVER:3306/employees_java";try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { System.out.println("can't load driver"); System.exit(1); }
connect = DriverManager.getConnection(url, user, password);
dane są dobre bo łącze się za ich pomocą przez phpmyadmina.
dodam że łącze się z kompa na którym jest Vista 64 bitowa a serwer mysql jest na windows serwer 2008 moze to jest problemem.
Prosze o jakieś sugestie.
Pozdrawiam