Applet Database Access

[kozmoh27]

I have had problems writing any Java applet that successfully connects to and executes queries in a MySQL database. Now, I have read multiple descriptions of how it is meant to be done. Regardless, I continue to receive this message:

Unable to connect to any hosts due to exception: java.security.AccessControlException: access denied (java.net.SocketPermission 127.0.0.1:3306 connect, resolve)

The applet runs perfectly inside my Eclipse development environment. I have attempted to modify the policy files to resolve this problem, to no avail. I still have not been able to find a clear explanation of what is necessary to create an applet that utilizes a SQL database. Will the users be able to run the applet without downloading any libraries or having a particular policy file on their machine? What is wrong with what I am doing, and what is the correct approach to this problem?

I really appreciate any help resolving this general issue.

Regards,

Cosmo

[qball]

problematic at best, due to applet security...

try:

http://saloon.javaranch.com/cgi-bin/...Continue=False

[Creosote]

Here is another link that might give you some help:

http://www.onjava.com/pub/a/onjava/2...ts.html?page=1

On a side note, however, I would only be able to imagine how an applet would run as a front-end for a DB (depending on what you are doing with it). Maybe consider using MS with an Active X control or just a web scripting language.

[qball]

applets will work fine as front end, if config spot on.

seen a few:

clearstation, since bought out, did one.
topcoder, since bought out, did one.

the secret is:

feed applet from server side, not user/browser side.