Bug #27904 Cannot connect to MySQL 5.1 on Sun Java system Application Server 9.1
Submitted: 17 Apr 2007 22:59 Modified: 30 Apr 2013 9:29
Reporter: vijay khanna Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Connector / J Severity:S1 (Critical)
Version:5.1 OS:Windows
Assigned to: Alexander Soklakov CPU Architecture:Any

[17 Apr 2007 22:59] vijay khanna
Description:
MySQL - 5.1
JDK - 1.6
Sun Java System App Server - 9.1
JDBC Driver - ConnectorJ 5.x/3.x (Both)

** BEGIN NESTED EXCEPTION ** 
java.net.SocketException
MESSAGE: java.net.ConnectException: Connection refused: no further information
STACKTRACE:
java.net.SocketException: java.net.ConnectException: Connection refused: no further information
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:143)
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:225)
        at com.mysql.jdbc.Connection.createNewIO(Connection.java:1805)
        at com.mysql.jdbc.Connection.<init>(Connection.java:452)
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
        at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:398)
        at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:131)
        at com.mysql.jdbc.jdbc2.optional.MysqlDataSource.getConnection(MysqlDataSource.java:102)
        at com.sun.gjc.spi.DSManagedConnectionFactory.createManagedConnection(DSManagedConnectionFactory.java:100)
        at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.getUnpooledConnection(ConnectorConnectionPoolAdminServiceImpl.java:1195)
        at com.sun.enterprise.connectors.ConnectorConnectionPoolAdminServiceImpl.testConnectionPool(ConnectorConnectionPoolAdminServiceImpl.java:538)
        at com.sun.enterprise.connectors.ConnectorRuntime.testConnectionPool(ConnectorRuntime.java:502)
        at com.sun.enterprise.admin.mbeans.ResourcesMBean.pingConnectionPool(ResourcesMBean.java:2218)

How to repeat:
This bug is generated when trying to setup MySQL connection pool in the app server.Test ping results this error.
[8 May 2007 7:21] Sveta Smirnova
Thank you for the report.

I tried described configuration and can ping successfully.

If I understood correctly, you create New Connection Pool IN the Sun Java System Application Server Admin Console.

If above is not correct, please, correct it.

If above is correct, to be sure we try same things, please, indicate:

1. Resource Type of the connection pool
2. Datasource Classname
3. Please confirm or refuse what you click "Ping" button on the "Edit Connection Pool" page and get described error.
[8 Jun 2007 23:00] Bugs System
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".
[30 Apr 2013 9:29] Alexander Soklakov
Hi Vijay,

There is no feedback since Apr 2007 so I close this report as "Can't repeat".
Please, feel free to reopen it if the problem still exists and you can
provide more info to analyze.