MySql Connect Problem

| No Comments | No TrackBacks
Tomcat6.0, Mysql Server version: 5.0.77-1 (Debian)

1. Error
    // Cannot connect to MySQL server on localhost:3307. Is there a MySQL server running on the machine/port you are trying to connect to? (java.security.AccessControlException)


2. Solution
edit this file and add bold line like below.
debian:/var/lib/tomcat6/conf/policy.d/04webapps.policy


    permission java.io.FilePermission "${java.io.tmpdir}/-", "read,write,delete";

    // Cannot connect to MySQL server on localhost:3307. Is there a MySQL server running on the machine/port you are trying to connect to? (java.security.Acc
    permission java.net.SocketPermission "127.0.0.1:3307", "connect,resolve";
};



1. Error
Communication failure during handshake. Is there a server running on 127.0.0.1:3307?


2.Solution
replace your JDBC driver .
in my case below.

WEB-INF/lib/mm.mysql-2.0.14-bin.jar -> mysql-connector-java-5.1.7-bin.jar


"mysql-connector-java-5.1.7-bin.jar" download link...
http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.7.tar.gz/from/http://mysql.byungsoo.net/




:)

No TrackBacks

TrackBack URL: http://www.thethinkings.com/mt/mt-tb.cgi/91

Leave a comment

 

Pages