"java.sql.SQLException: Internal driver error" with IBM Toolbox for Java JDBC Driver

Problem

The following message is received while testing a WebSphere data source connection that uses the IBM Toolbox for Java JDBC Driver in the WebSphere Application Server Integrated Solutions Console.

[9/16/10 17:11:08:281 EST] 0000002a SystemErr R java.sql.SQLException: Internal driver error. (class java.lang.ClassCastException)DSRA0010E: SQL State = HY000, Error Code = -99,999DSRA0010E: SQL State = HY000, Error Code = -99,999
at java.lang.Throwable.<init>(Throwable.java:195)
at java.lang.Exception.<init>(Exception.java:41)
at java.sql.SQLException.<init>(SQLException.java:40)
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:528)
at com.ibm.as400.access.AS400JDBCConnection.sendAndReceive(AS400JDBCConnection.java:2690)
at com.ibm.as400.access.AS400JDBCConnection.sendAndReceive(AS400JDBCConnection.java:2598)
at com.ibm.as400.access.AS400JDBCConnection.setServerAttributes(AS400JDBCConnection.java:3682)
at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:2987)
at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:2884)
at com.ibm.as400.access.AS400JDBCConnection.setProperties(AS400JDBCConnection.java:2877)
at com.ibm.as400.access.AS400JDBCDataSource.getConnection(AS400JDBCDataSource.java:619)
at com.ibm.as400.access.AS400JDBCDataSource.getConnection(AS400JDBCDataSource.java:592)
at com.ibm.as400.access.AS400JDBCConnectionPoolDataSource.getPooledConnection(AS400JDBCConnectionPoolDataSource.java:223)
at com.ibm.ws.rsadapter.DSConfigurationHelper$1.run(DSConfigurationHelper.java:1071)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:115)
at com.ibm.ws.rsadapter.DSConfigurationHelper.getPooledConnection(DSConfigurationHelper.java:1104)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:1320)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:982)
at com.ibm.ejs.j2c.poolmanager.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1697)
at com.ibm.ejs.j2c.poolmanager.FreePool.createOrWaitForConnection(FreePool.java:1453)
at com.ibm.ejs.j2c.poolmanager.PoolManager.reserve(PoolManager.java:2157)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:929)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:633)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:413)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:636)
at au.com.tupperware.dbutil.DBUtil.getConnection(DBUtil.java:98)
at au.com.tupperware.integration.core.DBTransactionClient.run(DBTransactionClient.java:79)

A synchronization issue with the driver was causing the internal error.

Resolution

Install the latest PTFs for the IBM Toolbox for Java to update the jt400.jar and jt400Native.jar files to the latest levels. If the latest PTFs are already applied, remove the PTFs then reapply them. You can find the latest PTFs by finding the latest version of toolbox available.

This version can be found on the following website:  //sourceforge.net/projects/jt400/

Then, go to the following URL to search on available APARs:  http://www-912.ibm.com/n_dir/nas4apar.nsf/nas4aparhome

Search on the keywords "jt400" or "jt400Native" and the version of JTOpen needed (for example, "jt400 7.1"). This search returns the latest APARs for IBM i 7.1, 6.1 and 5.4. It also returns the latest APARs for the jt400Native.jar. Then, find the appropriate release and identify the appropriate PTFs in the APAR text under the PTFs Available section.