Troubleshooting
Problem
In EJB development, when using the IBM DB2 Universal JDBC Driver (db2jcc.jar), a call stack error occurs that does not happen when using the DB2 Legacy CLI-based Type 2 JDBC Driver (db2java.zip).
Symptom
Error:
[9/6/05 10:27:10:598 EDT] 00000038 DataAccessReq E PMGR0000E: Call stack:
com.ibm.ws.ejbpersistence.utilpm.PersistenceManagerException: PMGR6022E: Error using adapter to create or execute an Interaction. com.ibm.ws.rsadapter.cci.WSInteractionImpl@4de516cf
at com.ibm.ws.ejbpersistence.dataaccess.DataAccessRequestImpl.execute(Unknown Source)
.
.
Caused by: java.sql.SQLException: The value of input host variable or parameter number "1" cannot be used because of its data type.DSRA0010E: SQL State = 07006, Error Code = -301
at com.ibm.db2.jcc.b.id.d(id.java:1385)
at com.ibm.db2.jcc.c.fb.l(fb.java:366)
at com.ibm.db2.jcc.c.fb.a(fb.java:64)
at com.ibm.db2.jcc.c.s.a(s.java:48)
at com.ibm.db2.jcc.c.xb.c(xb.java:266)
at com.ibm.db2.jcc.b.jd.ab(jd.java:1684)
at com.ibm.db2.jcc.b.jd.a(jd.java:2253)
Cause
This error might result if an EJB attribute of type byte array([]) is mapped to a CHARACTER FOR BIT DATA or VARCHAR FOR BIT DATA field.
By default, the deferPrepares Custom Property of the DB2 data source is set to true which, in this case, causes the error.
Resolving The Problem
Use the explicit data type conversion for input parameters, as the generated code is using it. This can be accomplished by setting the Custom Property deferPrepares on the data source to false.
To change this property on the data source, use the administrative console for the version 6 WebSphere Test Environment or a stand-alone WebSphere Application Server.
For the version 5.x WebSphere Test Environment use the Server Configuration Editor provided by Rational Application Developer to set this value on the data source.
For more details regarding the differences between the DB2 Universal JDBC Driver and other DB2 JDBC drivers please see the URL in the Related Information section below.
Related Information
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21216635