IBM Support

WebSphere Application Server and the JDBC 4.0 Wrapper Pattern

Troubleshooting


Problem

New in JDBC 4.0: The wrapper pattern now allows JDBC programmers to access vendor-specific JDBC APIs safely in an application server managed environment. Previous to JDBC 4.0, the WebSphere Application Server proprietary WSCallHelper interface had to be used to accomplish the same task.

Symptom

If the wrapper pattern is not followed and a vendor-specific JDBC API is invoked directly, the following type of error will be logged:

[12/12/11 12:34:39:911 EDT] 00000059 SystemErr R Caused by: java.sql.SQLFeatureNotSupportedException: DSRA1300E: Feature is not implemented: PreparedStatement.setClob
[12/12/11 12:34:39:912 EDT] 00000059 SystemErr R at com.ibm.ws.rsadapter.AdapterUtil.notSupportedX(AdapterUtil.java:1306)
[12/12/11 12:34:39:912 EDT] 00000059 SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setClob(WSJdbcPreparedStatement.java:1875)
[12/12/11 12:34:39:912 EDT] 00000059 SystemErr R at com.citigroup.solar.pnlview.dao.impl.ExportPnLViewDAO.putInUploadQueue(ExportPnLViewDAO.java:782)
[12/12/11 12:34:39:912 EDT] 00000059 SystemErr R ... 59 more
[12/12/11 12:34:39:913 EDT] 00000059 SystemErr R Caused by: java.lang.AbstractMethodError: java/sql/PreparedStatement.setClob(ILjava/io/Reader;)V
[12/12/11 12:34:39:913 EDT] 00000059 SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setClob(WSJdbcPreparedStatement.java:1859)
[12/12/11 12:34:39:913 EDT] 00000059 SystemErr R ... 60 more

[{"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"DB Connections\/Connection Pooling","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"9.0;8.5;8.0;7.0","Edition":"Base;Network Deployment","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]

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

swg21577331

Page Feedback