PK71217: JAVA.SQL.SQLEXCPETION IS THROWN WHEN TRYING TO REUSE A STATEMENTFROM THE PREPARED STATEMENT CASH.

APAR status

• Closed as program error.

Error description

• Java.SQL.SQLException is trhown when trying to reuse a statement
  from the prepared statement cache.
  
  The problem is observed in WebSphere Application Server v6.0.2.x
  
  The following exception stack trace relates to the problem:
  
  java.sql.SQLException: [IBM][SQLServer JDBC
  Driver][SQLServer]String or binary data would be truncated.
  at
  com.ibm.websphere.jdbc.base.BaseExceptions.createException(Unkno
  wn Source)
  at
  com.ibm.websphere.jdbc.base.BaseExceptions.getException(Unknown
  Source)
  at
  com.ibm.websphere.jdbc.sqlserver.tds.TDSRequest.processErrorToke
  n(Unknown Source)
  at
  com.ibm.websphere.jdbc.sqlserver.tds.TDSRequest.processReplyToke
  n(Unknown Source)
  at
  com.ibm.websphere.jdbc.sqlserver.tds.TDSRPCRequest.processReplyT
  oken(Unknown Source)
  at
  com.ibm.websphere.jdbc.sqlserver.tds.TDSRequest.processReply(Unk
  nown Source)
  at
  com.ibm.websphere.jdbc.sqlserver.SQLServerImplStatement.getNextR
  esultType(Unknown Source)
  at
  com.ibm.websphere.jdbc.base.BaseStatement.commonTransitionToStat
  e(Unknown Source)
  at
  com.ibm.websphere.jdbc.base.BaseStatement.postImplExecute(Unknow
  n Source)
  at
  com.ibm.websphere.jdbc.base.BasePreparedStatement.postImplExecut
  e(Unknown Source)
  at
  com.ibm.websphere.jdbc.base.BaseStatement.commonExecute(Unknown
  Source)
  at
  com.ibm.websphere.jdbc.base.BaseStatement.executeInternal(Unknow
  n Source)
  at
  com.ibm.websphere.jdbc.base.BasePreparedStatement.execute(Unknow
  n Source)
  at
  com.ibm.websphere.jdbcx.base.BasePreparedStatementWrapper.execut
  e(Unknown Source)
  at
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJ
  dbcPreparedStatement.java:655)
  at
  com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbc
  PreparedStatement.java:432)
  at dcf.persist.delivery.DeliveryQuery.insertEmail(Unknown
  Source)
  at dcf.persist.delivery.DeliveryQuery.insertDelivery(Unknown
  Source)
  at dcf.persist.delivery.DeliveryMapper.insertDelivery(Unknown
  Source)
  at
  dcf.server.delivery.engine.DeliveryServiceImpl.persistDelivery(U
  nknown Source)
  at
  dcf.server.delivery.engine.DeliveryServiceImpl.executeDelivery(U
  nknown Source)
  at
  dcf.server.delivery.engine.DeliveryEventProcessor$DeliveryEventD
  ispatcher.handle(Unknown Source)
  at
  com.xxx.xx.xxxx.queue.BlockingQueueProcessor.run(BlockingQue
  ueProcessor.java:110)
  at java.lang.Thread.run(Thread.java:838)
  

Local fix

• Set PreparedStatementCach = 0
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:  All users of IBM WebSphere Application      *
  *                  Server V6.0.2 who use the data direct driver*
  ****************************************************************
  * PROBLEM DESCRIPTION: java.sql.SQLException is thrown         *
  *                      when trying to reuse a statement        *
  *                      from the prepared statement cache.      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  There is a problem in the the DataDirect Driver  which is
  available in releases prior to 6.0.2.27
  
  If the catalog property on a connection is changed, prepared
  statements that have already been created become unusable,
  which causes a Java.SQL.SQLException to be trhown when trying
  to reuse a statement from the prepared statement cache.
  
  
  
  The following exception stack trace relates to the problem:
  
  java.sql.SQLException: [IBM][SQLServer JDBC
  Driver][SQLServer]String or binary data would be truncated.
  at
  com.ibm.websphere.jdbc.base.BaseExceptions.createException(Unkno
  wn Source)
  at
  com.ibm.websphere.jdbc.base.BaseExceptions.getException(Unknown
  Source)
  at
  com.ibm.websphere.jdbc.sqlserver.tds.TDSRequest.processErrorToke
  n(Unknown Source)
  at
  com.ibm.websphere.jdbc.sqlserver.tds.TDSRequest.process
  

Problem conclusion

• A new level fo the DataDirect Driver will be shipped.
  The fix for this APAR is currently targeted for inclusion in
  fixpack 6.0.2.27  Please refer to the Recommended Updates
  page for delivery information:
  http://www.ibm.com/support/docview.wss?rs=180&uid=swg27004980
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  WEBS APP SERV N

• Fixed component ID

  5724H8800

Applicable component levels

• R60A PSY

     UP

• R60H PSY

     UP

• R60I PSY

     UP

• R60P PSY

     UP

• R60S PSY

     UP

• R60W PSY

     UP

• R60Z PSY

     UP

• R61A PSY

     UP

• R61H PSY

     UP

• R61I PSY

     UP

• R61P PSY

     UP

• R61S PSY

     UP

• R61W PSY

     UP

• R61Z PSY

     UP