mysql connection
Køre med følgende:OS: winXP
Program: Eclipse
mysql 4.1.10a
mysql-connector-java-3.0.6-stable-bin.jar
Kode:
public static boolean test()
{
String url = "jdbc:mysql://localhost/jabase";
try
{
/* Test loading driver */
String driver = "org.gjt.mm.mysql.Driver";
System.out.println("test 1");
Class.forName( driver );
/* Test the connection */
System.out.println("test 2");
Connection con = DriverManager.getConnection(url,"root","******");
String dummy = UI.input();
return true;
}
catch( Exception x )
{
x.printStackTrace();
return false;
}
}
Fejl:
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 stream
STACKTRACE:
java.io.IOException: Unexpected end of input stream
at com.mysql.jdbc.MysqlIO.readPacket(MysqlIO.java:1073)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:619)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1511)
at com.mysql.jdbc.Connection.<init>(Connection.java:485)
at com.mysql.jdbc.Driver.connect(Driver.java:341)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at SQL.test(SQL.java:248)
at test.main(test.java:21)
** END NESTED EXCEPTION **
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:692)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1511)
at com.mysql.jdbc.Connection.<init>(Connection.java:485)
at com.mysql.jdbc.Driver.connect(Driver.java:341)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at SQL.test(SQL.java:248)
at test.main(test.java:21)
