Hi,
I'm running mySQL 2.0.4 and Tomcat 4.0 on Cobalt/Linux.
When trying to get a connection to the database, I got the following error
(the code is provided below - exact id and password replaced for
confidentiality).
Step 1 : Class.forName("org.gjt.mm.mysql.Driver"); OK
Step 2 :
getConnection("jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myID&p
assword=myPwd"); *** FAILURE ***
SQLException: Cannot connect to MySQL server on
sherweb7.sherweb.com:3306. Is there a MySQL server running on the
machine/port you are
trying to connect to? (java.security.AccessControlException)
SQLState: 08S01
VendorError: 0
Few comments:
1/ the mySQL server's site address is OK (not the localhost)
2/ the mySQL server's port is OK
3/ the table name is OK
4/ the userID is OK
5/ the password is OK
6/ the connection looks fine through phpMyAdmin
7/ I get the same java.security.AccessControlException when doing the same
request without the userID and password
6/ I got a java.net.ConnectException (which seems normal to me) when trying
to call the server as if it was local to my machine, i.e.:
jdbc:mysql:///myDatabase?user=myID&password=myPwd
Any suggestion?
The code:
try {
Class.forName("org.gjt.mm.mysql.Driver"); // this or <the
same>.newInstance() does the same
System.out.println("Step1: Class.forName(\"org.gjt.mm.mysql.Driver\"):
OK");
}
catch (Exception e) {
System.out.println("Class.forName(\"org.gjt.mm.mysql.Driver\"): ***
FAILURE ***");
}
Connection myConn = null;
try {
myConn =
DriverManager.getConnection("jdbc:mysql://sherweb7.sherweb.com:3306/myDataba
se?user=myID&password=myPwd");
System.out.println("Step 2:
getConnection(\"jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myID&
password=myPwd\"): OK");
}
catch (SQLException e) {
System.out.println("Step 2:
getConnection(\"jdbc:mysql://sherweb7.sherweb.com:3306/myDatabase?user=myID&
password=myPwd\"): *** FAILURE ***");
System.out.println(" SQLException: "+e.getMessage());
System.out.println(" SQLState: "+e.getSQLState());
System.out.println(" VendorError: "+e.getErrorCode());
}