MySQL Bugs: #50504: Applet with mysql failed

Bug #50504	Applet with mysql failed
Submitted:	21 Jan 2010 12:42	Modified:	29 Apr 2015 11:09
Reporter:	kotti kotti	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	Connector / J	Severity:	S1 (Critical)
Version:	mysql-5.4.2-beta-osx10.4-powerpc	OS:	MacOS
Assigned to:	Alexander Soklakov	CPU Architecture:	Any
Tags:	applet, MySql Connector, power pc

Description:
Dear Friend,

I trying to connect the Mysql database from Applet on Mac OS X 10.4.11.  I have installed Mysql version "mysql-5.4.2-beta-osx10.4-powerpc" and using connector 5.1.10.  I repeatedly getting the following error.  I never succeeded on this.  

The error is:

com.mysql.jdbc.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2214)
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:781)
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:348)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:171)
        at AppletJDBCDrop.init(AppletJDBCDrop.java:29)
        at sun.applet.AppletPanel.run(AppletPanel.java:380)
        at java.lang.Thread.run(Thread.java:613)
Caused by: com.mysql.jdbc.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:343)
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2137)
        ... 8 more
Caused by: java.net.SocketException: java.security.AccessControlException: access denied (java.net.SocketPermission [0:0:0:0:0: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:292)
        ... 9 more
java.lang.NullPointerException
        at AppletJDBCDrop.loadTables(AppletJDBCDrop.java:56)
        at AppletJDBCDrop.init(AppletJDBCDrop.java:36)
        at sun.applet.AppletPanel.run(AppletPanel.java:380)
        at java.lang.Thread.run(Thread.java:613)

Could you please please help on this one?  I have been working for the past 10 days on this. but i never got the desired result.  Please note, I am able to connect the database from java application.

Please help me!!!

Thanks,
Kotti

How to repeat:
daily

Hi Kotti and thanks for your report.

I know nothing of Mac OS but the reason seem apparent:
Caused by: java.net.SocketException: java.security.AccessControlException: access denied
(java.net.SocketPermission [0:0:0:0:0:0:0:1]:3306 connect,resolve)

Something's screwed with your applet privileges. Ideas?

Further more, we think this has nothing to do with MySQL. To confirm this, please try connecting from your applet to some other port that's in use (like webserver on 80 or something) and see if it works.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

Closed as Can't repeat because we have no feedback for 5 years and there is nothing actually related to c/J.