JDBC Policy connection problem

[Trevor MacPhail]

I am having some issues with trying to use my JDBC driver to connect to a mySQL server. I get the following error in my catalina.out file:

java.sql.SQLException: Cannot connect to MySQL server on dbox.dnsalias.net:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.security.AccessControlException)

Yet, there most certainly is a server running at that location. In fact, I dont get this error when I start tomcat without the -security option. This obviously narrows the problem down to a policy setting. So I added the following grant (based on a sample that was commented out in catalina.policy:

grant codeBase "file:/usr/share/tomcat4/webapps/bookstore/WEB-INF/lib/mysql-connector-java-2.0.14-bin.jar!/-" {
permission java.net.SocketPermission "dbox.dnsalias.net:3306", "connect";
};

I've restarted the server with this added but it still gives me the error message shown earlier when I try to establish the connection. Any idea's what I should change this grant to? Or if there is another one I need to add?

--
Trevor MacPhail


--
To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org>
For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>