Identity Minder JDBC Connection Error (Legacy_Onyx KB Id: 186049)

Document ID : KB000055026
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When hitting submit on a Create and Modify end user we get the following error screen. A copy of the screen is attached.

The error reported on the close screen is

SQL Server 2000 Driver for JDBC. Connection Reset by Peer. Socket write error.

The System OutLog has the following

[10/18/04 3:39:40:375 EDT] 4a4ae049 ConnectionPoo E CONM6009E: Unable to get connection to the database from datasource (Workflow Data Source).

[10/18/04 3:39:40:406 EDT] 4a4ae049 StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode 0 and SQLState 08001, to a StaleConnectionException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.&ltinit>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbcx.base.BaseDataSource.getBaseConnection(Unknown Source)
at com.microsoft.jdbcx.base.BaseDataSource.getPooledConnection(Unknown Source)
at com.ibm.ejs.cm.pool.JDBC1xConnectionFactory.createConnection(JDBC1xConnectionFactory.java:42)
at com.ibm.ejs.cm.pool.ConnectionPool.createConnection(ConnectionPool.java:1157)
at com.ibm.ejs.cm.pool.ConnectionPool.createOrWaitForConnection(ConnectionPool.java:1053)
at com.ibm.ejs.cm.pool.ConnectionPool.findFreeConnection(ConnectionPool.java(Compiled Code))
at com.ibm.ejs.cm.pool.ConnectionPool.findConnectionForTx(ConnectionPool.java(Compiled Code))
at com.ibm.ejs.cm.pool.ConnectionPool.allocateConnection(ConnectionPool.java(Compiled Code))
at com.ibm.ejs.cm.pool.ConnectionPool.getConnection(ConnectionPool.java(Inlined Compiled Code))
at com.ibm.ejs.cm.DataSourceImpl$1.run(DataSourceImpl.java(Compiled Code))
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java(Compiled Code))
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java(Compiled Code))
at com.workpoint.server.ConnectContext.getConnection(Unknown Source)(Compiled Code)
at com.workpoint.server.ConnectContext.connect(Unknown Source)(Inlined Compiled Code)
at com.workpoint.server.ConnectContext.&ltinit>(Unknown Source)(Compiled Code)
at com.workpoint.server.ConnectContext.&ltinit>(Unknown Source)(Inlined Compiled Code)
at com.workpoint.server.ejb.MonitorPvtBean.queryMailMonitors(Unknown Source)(Compiled Code)
at com.workpoint.server.ejb.EJSRemoteStatelessMonitorPvt_255a9f55.queryMailMonitors(Unknown Source)(Compiled Code)
at com.workpoint.server.ejb._MonitorPvt_Stub.queryMailMonitors(_MonitorPvt_Stub.java(Compiled Code))
at com.workpoint.client.Monitor.queryMailMonitors(Unknown Source)(Compiled Code)
at com.workpoint.monitor.support.MailQueryThread.performQuery(Unknown Source)(Compiled Code)
at com.workpoint.monitor.support.AbstractQueryThread.run(Unknown Source)(Compiled Code)
---- Begin backtrace for Nested Throwables
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Operation timed out: connect
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.&ltinit>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbcx.base.BaseDataSource.getBaseConnection(Unknown Source)
at com.microsoft.jdbcx.base.BaseDataSource.getPooledConnection(Unknown Source)
at com.ibm.ejs.cm.pool.JDBC1xConnectionFactory.createConnection(JDBC1xConnectionFactory.java:42)
at com.ibm.ejs.cm.pool.ConnectionPool.createConnection(ConnectionPool.java:1157)
at com.ibm.ejs.cm.pool.ConnectionPool.createOrWaitForConnection(ConnectionPool.java:1053)
at com.ibm.ejs.cm.pool.ConnectionPool.findFreeConnection(ConnectionPool.java(Compiled Code))
at com.ibm.ejs.cm.pool.ConnectionPool.findConnectionForTx(ConnectionPool.java(Compiled Code))
at com.ibm.ejs.cm.pool.ConnectionPool.allocateConnection(ConnectionPool.java(Compiled Code))
at com.ibm.ejs.cm.pool.ConnectionPool.getConnection(ConnectionPool.java(Inlined Compiled Code))
at com.ibm.ejs.cm.DataSourceImpl$1.run(DataSourceImpl.java(Compiled Code))
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java(Compiled Code))
at com.ibm.ejs.cm.DataSourceImpl.getConnection(DataSourceImpl.java(Compiled Code))
at com.workpoint.server.ConnectContext.getConnection(Unknown Source)(Compiled Code)
at com.workpoint.server.ConnectContext.connect(Unknown Source)(Inlined Compiled Code)
at com.workpoint.server.ConnectContext.&ltinit>(Unknown Source)(Compiled Code)
at com.workpoint.server.ConnectContext.&ltinit>(Unknown Source)(Inlined Compiled Code)
at com.workpoint.server.ejb.MonitorPvtBean.queryMailMonitors(Unknown Source)(Compiled Code)
at com.workpoint.server.ejb.EJSRemoteStatelessMonitorPvt_255a9f55.queryMailMonitors(Unknown Source)(Compiled Code)
at com.workpoint.server.ejb._MonitorPvt_Stub.queryMailMonitors(_MonitorPvt_Stub.java(Compiled Code))
at com.workpoint.client.Monitor.queryMailMonitors(Unknown Source)(Compiled Code)
at com.workpoint.monitor.support.MailQueryThread.performQuery(Unknown Source)(Compiled Code)
at com.workpoint.monitor.support.AbstractQueryThread.run(Unknown Source)(Compiled Code)

03:39:40,484 ERROR [com.workpoint.server.ejb.GenericBean] SQLException occurred: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
[Microsoft][SQLServer 2000 Driver for JDBC]Operation timed out: connect
03:39:40,484 ERROR [com.workpoint.monitor.support.MailQueryThread] Unable to query mail instances due to RemoteException.
com.workpoint.server.ejb.WorkPointEJBException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.[Microsoft][SQLServer 2000 Driver for JDBC]Operation timed out: connect

Stopping and starting WAS resolved the issue.

My question is why are we getting this error. Are we on the right release of the JDBC driver? I believe we are.

Copy of the screen shot and the WAS System Out Log are added.


Solution:

According to Engineering we do not do anything special with stale connections. However according to your logs the JDBC layer is catching and throwing the exception rather than passing it back to our application.Enhancement E940 / CQ 37968 has been submitted on your behalf. Please contact you Account Manager who is your interface to Netegrity Product Management to track this enhancement request. It will be considered for inclusion in a future release of IdentityMinder.