IBM Support

Troubleshooting enterprise applications on WebSphere Application Server which simultaneously use JDBC providers from JDBC 3.0 and 4.0 specification levels

Troubleshooting


Problem

Enterprise applications may reference multiple Java Database Connectivity (JDBC) providers through datasource instances. In doing so, care must be taken to avoid references to both a JDBC 3.0 and a JDBC 4.0 driver class from the same vendor in an application. Doing so may result in the inability of the application to access JDBC 4.0 API methods on the datasource interfaces.

Symptom

Application code may raise exceptions indicating that a method or feature is not implemented if an attempt is made to access JDBC 4.0 specific API methods. The exception may look similar to the following:
...
Caused by: java.sql.SQLFeatureNotSupportedException: DSRA1300E: Feature is not implemented: PreparedStatement.setBinaryStream
at com.ibm.ws.rsadapter.AdapterUtil.notSupportedX(AdapterUtil.java:1466)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setBinaryStream(WSJdbcPreparedStatement.java:1424)
at com.ibm.icm.da.portable.common.sql.PPreparedStatement.setBinaryStream(PPreparedStatement.java:423)
at com.ibm.icm.da.portable.data.WideTableData.bindValue(WideTableData.java:1582)
at com.ibm.icm.da.portable.data.WideTableData.changeItems(WideTableData.java:596)
at com.ibm.icm.da.portable.data.WideTableData.bindValue(WideTableData.java:1582)
at com.ibm.icm.da.portable.data.WideTableData.changeItems(WideTableData.java:596)
... 63 more
Caused by: java.lang.AbstractMethodError: java/sql/PreparedStatement.setBinaryStream(ILjava/io/InputStream;)V
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setBinaryStream(WSJdbcPreparedStatement.java:1408)
... 66 more

[{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"ARM Category":[{"code":"a8m50000000CdAzAAK","label":"WebSphere Application Server traditional-All Platforms-\u003EJ2C-ConnectionPooling-JDBCDrivers-\u003EConnection Pooling-J2C-DB Connections-\u003EJDBC Provider-Data Source configuration problem"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions","Type":"MASTER"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
03 March 2025

UID

swg21590188