Forum Stats

  • 3,770,488 Users
  • 2,253,125 Discussions
  • 7,875,484 Comments

Discussions

DB2 Toplink Errors

526685
526685 Member Posts: 28
edited Aug 22, 2006 7:50PM in SOA Suite Discusssions
Anyone have DB2 queries working correctly? I'm getting toplink errors on very basic queries:

<2006-08-22 16:23:21,278> <INFO> <default.collaxa.cube.ws> <AdapterFramework::Outbound> file:/D:/Oracle_SOA/OracleAS_1/bpel/domains/default/tmp/.bpel_BPELProcess1_1.0_c64929dfd2dacf95db3c9da081c1797d.tmp/DB2_Service1.wsdl [ DB2_Service1_ptt::DB2_Service1Select_Person_Name_SSN(DB2_Service1Select_Person_Name_SSN_inparameters,PerCollection) ] - Using JCA Connection Pool - max size = <unbounded>
<2006-08-22 16:23:21,338> <ERROR> <default.collaxa.cube.ws> <Database Adapter::Outbound> <oracle.tip.adapter.db.DBInteraction executeOutboundRead> unable to execute the NamedQuery: DB2Service1.Per.DB2_Service1Select

<2006-08-22 16:23:21,338> <ERROR> <default.collaxa.cube.ws> <AdapterFramework::Outbound> file:/D:/Oracle_SOA/OracleAS_1/bpel/domains/default/tmp/.bpel_BPELProcess1_1.0_c64929dfd2dacf95db3c9da081c1797d.tmp/DB2_Service1.wsdl [ DB2_Service1_ptt::DB2_Service1Select_Person_Name_SSN(DB2_Service1Select_Person_Name_SSN_inparameters,PerCollection) ] - Could not invoke operation 'DB2_Service1Select_Person_Name_SSN' against the 'Database Adapter' due to:
ORABPEL-11614
DBReadInteractionSpec Execute Failed Exception.
Query name: [DB2_Service1Select], Descriptor name: [DB2Service1.Per]. [Caused by: [oias][DB2 JDBC Driver][DB2]STRING TO BE PREPARED CONTAINS INVALID USE OF PARAMETER MARKERS]
See root exception for the specific exception. Caused by Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.1.0) (Build 060730)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: [oias][DB2 JDBC Driver][DB2]STRING TO BE PREPARED CONTAINS INVALID USE OF PARAMETER MARKERSError Code: -418
Call:SELECT t1.PER_NM, t1.PER_TK, t0.INV_PER_TK, t0.INV_BIR_DT, t0.INV_SSN_NU FROM INV t0, PER t1 WHERE (((UCASE(t1.PER_NM) LIKE UCASE(?)) OR (t0.INV_SSN_NU LIKE ?)) AND (t0.INV_PER_TK = t1.PER_TK))
bind => [Example, 987654321]
Query:ReadAllQuery(bpel___localhost_default_BPELProcess1_1_0__MD5_8f87e944ed0237f6f6bb9082fd3104c6_.DB2Service1.Per)


Similar error just fixed by Sun: http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=6434626

Is this programmer error?

thanks!
Mike

Comments

This discussion has been closed.