wood burning stoves 2.0*
The moose likes Applets and the fly likes applet Mysql connection Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Java » Applets
Bookmark "applet Mysql connection" Watch "applet Mysql connection" New topic
Author

applet Mysql connection

Bahadir Mert Uzan
Greenhorn

Joined: Mar 27, 2009
Posts: 13
Yet another question from me

Here is my applet which runs well with netbeans but fails in a browser.


Basicly it connects to a database and send statement to another class to deal.

My problem when I run it doesn't relaize MySql-connector jar and makes an error

java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at sun.plugin2.applet.Applet2ClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at View.CardApplet.read(CardApplet.java:36)
at View.CardApplet.init(CardApplet.java:26)
at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

How can i force the jar to work? Thank you
Paul Clapham
Bartender

Joined: Oct 14, 2005
Posts: 18715
    
    8

Just like any other time when you get a ClassNotFoundException: make sure the class which wasn't found is in your classpath. I believe an applet's classpath is in the "archive" attribute of the HTML "applet" element.
Bahadir Mert Uzan
Greenhorn

Joined: Mar 27, 2009
Posts: 13
I am using a mysql connector and its an individual jar in libary folder.
Also I unrared the mysql connector char and put it into classes folder which I really dont want to do that
Is there a way out of this.

When i do the unraring part of connector I got a securty error.
If you can tell me away to solve these problems you basicly solved 80% of them.

these are the security errors.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2120)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:723)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:282)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at View.CardApplet.read(CardApplet.java:39)
at View.CardApplet.init(CardApplet.java:27)
at sun.plugin2.applet.Plugin2Manager$AppletExecutionRunnable.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

Last packet sent to the server was 0 ms ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:335)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2043)
... 15 more
Caused by: java.net.SocketException: java.security.AccessControlException: access denied (java.net.SocketPermission 127.0.0.1:3306 connect,resolve)
at com.mysql.jdbc.StandardSocketFactory.unwrapExceptionToProperClassAndThrowIt(StandardSocketFactory.java:404)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:265)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
... 16 more
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42374
    
  64
Don't un-jar the driver file; instead, use the applet tag's archive attribute like Paul mentioned.

Applets can only make network connections to the host where they were served from. So the DB connection to 127.0.0.1 will only work if the applet page is on a page with address http://127.0.0.1/...


Ping & DNS - my free Android networking tools app
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: applet Mysql connection