PK46061: DYNAMIC QUERY FAILS WITH CLASSCASTEXCEPTION WHEN A DATABASE COLUMN USES "LONG VARCHAR" DATA TYPE

Java SDK 1.5 SR8 Cumulative Fix for WebSphere Application Server
Java SDK 1.5 SR8 Cumulative Fix for WebSphere Application Server
Java SDK 1.5 SR10 Cumulative Fix for WebSphere Application Server
6.1.0.31: Java SDK 1.5 SR11 FP1 Cumulative Fix for WebSphere Application Server
6.1.0.33: Java SDK 1.5 SR12 FP1 Cumulative Fix for WebSphere
6.1.0.29: Java SDK 1.5 SR11 Cumulative Fix for WebSphere Application Server
6.1.0.35: Java SDK 1.5 SR12 FP2 Cumulative Fix for WebSphere
6.1.0.37: Java SDK 1.5 SR12 FP3 Cumulative Fix for WebSphere
6.1.0.39: Java SDK 1.5 SR12 FP4 Cumulative Fix for WebSphere Application Server
6.1.0.41: Java SDK 1.5 SR12 FP5 Cumulative Fix for WebSphere Application Server
6.1.0.43: Java SDK 1.5 SR13 Cumulative Fix for WebSphere Application Server
6.1.0.45: Java SDK 1.5 SR14 Cumulative Fix for WebSphere Application Server
6.1.0.47: WebSphere Application Server V6.1 Fix Pack 47
6.1.0.47: Java SDK 1.5 SR16 Cumulative Fix for WebSphere Application Server

APAR status

• Closed as program error.

Error description

• Dynamic Query is a programming model extension available in WBI
  Server Foundation V5.1, WebSphere Application Server V6.0, and
  WebSphere Application Server V6.1.  In any of these releases,
  when a dynamic query is run against a database column that
  contains data of the type "LONG VARCHAR", the query fails.
  .
  The following exception is seen in the SystemOut.log:
  .
  com.ibm.websphere.ejbquery.QueryException: CSIException while
  creating remote object
   at
  com.ibm.websphere.eexquery.EEXConfig.makeObjectFromData(EEXConfi
  g.java:728)
  ...
  When tracing is enabled, it is seen that the root exception is a
  ClassCastException:
  .
  com.ibm.websphere.csi.CSIException: unable to get wrapper;
  nested exception is:
   java.lang.ClassCastException: java.io.StringReader
   at
  com.ibm.ejs.container.EJBDynamicQueryHelperImpl.getEJSWrapperCom
  mon(EJBDynamicQueryHelperImpl.java:725)
   at
  com.ibm.ejs.container.EJBDynamicQueryHelperImpl.getEJBLocalObjec
  t(EJBDynamicQueryHelperImpl.java:553)
  ...
  Caused by: java.lang.ClassCastException: java.io.StringReader
   at
  com.ibm.ws.ejbpersistence.dataaccess.RawBeanData.getString(Unkno
  wn Source)
   at
  com.ibm.bcrs.bo.entity.websphere_deploy.DB2UDBNT_V8_1.EventEntit
  yBeanExtractor_3a6a38ed.extractData(EventEntityBeanExtractor_3a6
  a38ed.java:42)
  ...
  

Local fix

• Change the data type of the database column to something other
  than LONG VARCHAR, or use static queries instead of dynamic
  queries.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: WebSphere Business Integration Server        *
  *                 Foundation Users.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: When using the Dynamic Query Service    *
  *                      with tables LONG VARCHAR columns, a     *
  *                      CLASS CAST EXCEPTION occurs during      *
  *                      query execution.                        *
  ****************************************************************
  * RECOMMENDATION: Change column definition or apply this fix.  *
  ****************************************************************
  CLASS CAST EXCEPTION during ejbquery execution
  when using tables with LONG VARCHAR columns.
  

Problem conclusion

• Apply this interim fix to resolve the issue or change column
  definition.
  

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

  WBISF 510

• Fixed component ID

  5724H7400

Applicable component levels

• R103 PSY

     UP

• R10A PSY

     UP

• R10H PSY

     UP

• R10I PSY

     UP

• R10P PSY

     UP

• R10S PSY

     UP

• R10W PSY

     UP