Server configuration denies access to data source
Hello All,
The server has Tomcat 3 and JDBC mysql-connector-java-2.0.14
I wrote a test jdbc code but that is not working.
However I can connect to the database using the mysql command.
But with jdbc, I get the following error:
java.sql.SQLException: Server configuration denies access to data source
at com.mysql.jdbc.MysqlIO.init(Unknown Source)
at com.mysql.jdbc.Connection.connectionInit(Unknown Source)
at com.mysql.jdbc.jdbc2.Connection.connectionInit(Unknown Source)
at com.mysql.jdbc.Driver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:523)
Here is my code
<%@ page import="java.sql.*"%>
<%
Connection connection = null;
out.println("test 1.1");
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
out.println("test 2");
connection=DriverManager.getConnection("jdbc:mysql://localhost/msbizne_jtest?user=msbizne_test&password=pass123");
out.println("test 3");
%>
Please advice on how to solve this.
Thanks a lot
DT
