Pinned topicAccess problem to an informix database with jdbc/datasource in websphere

‏2008-12-11T14:13:33Z
|Tags:

Answered question
This question has been answered.

Unanswered question
This question has not been answered yet.

Hello !

I try to access an Informix database in my application. I have created a JDBC Provider and a DataSource. I use opljdbc3.jar and the implementation class is openlink.javax.OPLConnectionPoolDataSource. The connection test in the WebSphere administration console is ok.

java.sql.SQLException: Driver not capableDSRA0010E: Etat SQL = S1C00, Code d'erreur = 43
at openlink.jdbc3.OPLMessage.makeException(Unknown Source)
at openlink.jdbc3.OPLUtility.setIntegerInfo(Unknown Source)
at openlink.jdbc3.OPLConnection.setTransactionIsolation(Unknown Source)
at openlink.javax.ConnectionWrapper.setTransactionIsolation(Unknown Source)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.setTransactionIsolation(WSRdbManagedConnectionImpl.java:4378)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.synchronizePropertiesWithCRI(WSRdbManagedConnectionImpl.java:2375)
at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.<init>(WSRdbManagedConnectionImpl.java:586)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1075)
at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:1751)
at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1518)
at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:2141)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:846)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:585)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:431)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:400)
...