java- mysql5.0 连接问题！在线等！

chenshiwen1981 2005-05-13 08:38:04

import java.sql.*;

public class My {
public static void main(String args[]) {
try {
Class.forName("com.mysql.jdbc.Driver"); //加?MYSQL JDBC??程序
System.out.println("Success loading Mysql Driver!");
}
catch (Exception e) {
System.out.print("Error loading Mysql Driver!");
e.printStackTrace();
}

try {
Connection connect = DriverManager.getConnection(
"jdbc:mysql://3.243.217.12:3306/worklog", "root", "root");

System.out.println("Success connect Mysql server!");

Statement stmt = connect.createStatement();
ResultSet rs = stmt.executeQuery("select * from classification");
while (rs.next()) {
System.out.println(rs.getString("no"));

}
}
catch (Exception e) {
System.out.print("get data error!");
e.printStackTrace();
}
}
}

///////////////////////////////////
Success loading Mysql Driver!
get data error!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: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(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at My.main(My.java:15)

** 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(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at My.main(My.java:15)
这是什么原因我用4.0就不出现这个问题！！

...全文