This week's book giveaway is in the Jobs Discussion forum.
We're giving away four copies of Customer Requirements for Developers and have Marcho Behler on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes AccessControlException: access denied Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Customer Requirements for Developers this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "AccessControlException: access denied " Watch "AccessControlException: access denied " New topic

AccessControlException: access denied

Janine Dalton

Joined: Jan 25, 2003
Posts: 4
my hosting setup:
tomcat 4.1, jdk 1.4.2, mysql 3.23, mysql-connector-java-3.0.9-stable-bin.jar, (plesk 6, Apache 2.0)
error message:
java.sql.SQLException: Unable to connect to any hosts due to exception: access denied ( localhost resolve)
basically, i have just joined up with a new host and am trying to get quite a simple web app up and running. i have to upload my app as a war file and i have tried to follow the required structure and web.xml format.
i have placed the jar file for connector j in web-inf/lib but have not referred to this in the web.xml file - is that where i'm goin wrong? if so, what should go in the web.xml file about connector j?
i'm really not sure what is causing this problem: my knowledge of servlets is limited and i am new to war files. i know my database username and password is correct since i have tested connecting via a php script. my host won't help me get set up at all (unless i pay 75 bucks an hour to their java expert) so i thought i would try the friendly folk here first
im only trying to run one simple college project but i just can't get up adn running adn it's doing my head in

*any* advice would be greatly appreciated!
here is my web.xml file in case it helps:
<!DOCTYPE web-app
PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
Joe Ess

Joined: Oct 29, 2001
Posts: 9126

Originally posted by Janine Dalton:

error message:
java.sql.SQLException: Unable to connect to any hosts due to exception: access denied ( localhost resolve)

Not a JDBC problem. It's a security policy problem. The java policy file is <JAVA_HOME>/jre/lib/security/java.policy. You probably need a line in the "grant" section like:

but I'm sure your host would want it restricted to the host you are on and the port your database uses. Check out
Permissions in the Java 2 SDK for more info.

[How To Ask Questions On JavaRanch]
It is sorta covered in the JavaRanch Style Guide.
subject: AccessControlException: access denied
jQuery in Action, 3rd edition