COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0102E Invalid conversion. SQLSTATE=07006
 Technote (FAQ)
 
Problem
An application running in WebSphere® Application Server 4.0.x that executes a PreparedStatement against a DB2 7.2 Fix Pack 6 (or lower) database receives the exception "COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0102E Invalid conversion. SQLSTATE=07006".
 
Solution
The problem is with DB2® (refer to DB2 APAR JR17023 for more information).

To solve the problem, either:

  • Upgrade DB2 to DB2 7.2 Fix Pack 7 (or higher)

    or

  • Add the following lines to the [COMMON] section in the db2cli.ini on the client side:

PATCH2=30

DEFERREDPREPARE=0

There is also a workaround in WebSphere Application Server. The workaround is to disable the WebSphere Prepared Statement Cache by setting the Statement Cache Size to 0 for the data source. There is a performance degradation with this workaround, so it is not recommended.

 
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > DB Connections/Connection Pooling
Operating system(s): HP-UX
Software version: 4.0
Software edition:
Reference #: 1078606
IBM Group: Software Group
Modified date: Aug 27, 2004