|
谁能告诉我这段测试连接的代码有没有问题,还是我的设置不对?
-----------------------------------------------------------------------------------------
import java.sql.*;
public class sql {
public static void main (String[] args) {
Connection conn = null;
try {
String userName = "root";
String password = "root";
String url = "jdbc:mysql://localhost/sysops/";
Class.forName ("com.mysql.jdbc.Driver").newInstance ();
conn = DriverManager.getConnection (url, userName, password);
System.out.println ("Database connection established");
}
catch (Exception e) {
System.err.println ("Cannot connect to database server");
e.printStackTrace();
}
finally {
if (conn != null){
try{
conn.close ();
System.out.println ("Database connection terminated");
}
catch (Exception e) {
e.printStackTrace();
/* ignore close errors */ }
}
}
}
}
-----------------------------------------------------------------------------------
我用的是suse10.1 编译无误,但运行时得到如下错误提示
-------------------------------------------------------------------------------------------------
java.sql.SQLException: Incorrect database name 'sysops/'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:2975)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:79
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java: 3700)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:12 03)
at com.mysql.jdbc.Connection.createNewIO(Connection.j ava:256
at com.mysql.jdbc.Connection.<init>(Connection.java:1 485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonReg isteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager .java:525)
at java.sql.DriverManager.getConnection(DriverManager .java:171)
at sql.main(sql.java:15)
-----------------------------------------------------------------------------------------------------------
但我有sysops数据库,在 /var/lib/mysql/sysops 下
----------------------------------------------------------------------------------------------------------------
drwx------ 2 mysql mysql 72 2007-02-15 20:32 bedrock
-rw-rw---- 1 mysql mysql 10485760 2007-02-16 09:51 ibdata1
-rw-rw---- 1 mysql mysql 5242880 2007-02-16 10:25 ib_logfile0
-rw-rw---- 1 mysql mysql 5242880 2007-01-08 12:25 ib_logfile1
drwx------ 2 mysql mysql 1752 2007-02-15 20:37 mysql
-rw-rw---- 1 mysql mysql 3578 2007-02-16 10:25 mysqld.log
-rw-rw---- 1 mysql mysql 5 2007-02-16 10:25 mysqld.pid
srwxrwxrwx 1 mysql mysql 0 2007-02-16 10:25 mysql.sock
drwx------ 2 mysql mysql 168 2007-02-15 20:58 sysops
-----------------------------------------------------------------------------------------------------
我快抓狂了,希望得到帮助。 |
|