Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Server configuration denies access to data source

843854Sep 13 2003 — edited Sep 13 2003
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 11 2003
Added on Sep 13 2003
5 comments
551 views