DB2 error (DSRA0010E: SQL State = 07006, Error Code = -301) when using DB2 Universal JDBC Driver (db2jcc.jar) with Entity Bean

Technote (troubleshooting)


Problem(Abstract)

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

JDBC differences between the DB2 Universal JDBC Driver

Cross reference information
Segment Product Component Platform Version Edition
Application Servers WebSphere Application Server DB Connections/Connection Pooling Multi-Platform 5.0, 5.0.1, 5.0.2, 5.0.2.1, 5.0.2.10, 5.0.2.11, 5.0.2.12, 5.0.2.13, 5.0.2.2, 5.0.2.3, 5.0.2.4, 5.0.2.5, 5.0.2.6, 5.0.2.7, 5.0.2.8, 5.0.2.9, 5.1, 5.1.0.1, 5.1.0.2, 5.1.0.3, 5.1.0.4, 5.1.0.5, 5.1.0.6, 5.1.1, 5.1.1.1, 5.1.1.2, 5.1.1.3, 5.1.1.4, 5.1.1.5, 5.1.1.6, 6.0, 6.0.0.2, 6.0.0.3, 6.0.1, 6.0.1.1, 6.0.1.2, 6.0.2, 6.0.2.1, 6.0.2.2 Advanced, Base, Enterprise
Software Development WebSphere Studio Application Developer Server Linux, Windows 5.1.2 All Editions

Rate this page:

(0 users)Average rating

Document information


More support for:

WebSphere Studio Application Developer
Server

Translate my page

Machine Translation

Content navigation