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).
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)
[{"Product":{"code":"SSRTLW","label":"Rational Application Developer for WebSphere Software"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"EJB Development","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF016","label":"Linux"}],"Version":"6.0;6.0.0.1;6.0.1.0","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSEQTP","label":"WebSphere Application Server"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"DB Connections\/Connection Pooling","Platform":[{"code":"","label":"Multi-Platform"}],"Version":"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","Edition":"Advanced;Base;Enterprise","Line of Business":{"code":"LOB77","label":"Automation Platform"}},{"Product":{"code":"SSBRLP","label":"WebSphere Studio Application Developer"},"Business Unit":{"code":"BU050","label":"BU NOT IDENTIFIED"},"Component":"Server","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"5.1.2","Edition":"All Editions","Line of Business":{"code":"","label":""}}]
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.