Syntax Error Using Database Adapter ORABPEL-11614 (Doc ID 1307567.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle SOA Platform - Version: 10.1.3.1.0 to 10.1.3.5.0 - Release: AS10gR3 to
Information in this document applies to any platform.

Symptoms

Using a non-Oracle database with a database adapter, attempt to invoke the database adapter in a BPEL or ESB process fails with a SQL syntax error.

A similar error is seen in the container logfile in $ORACLE_HOME/opmn/logs/<container name>.log:

<2011-03-22 10:32:14,770> <ERROR> <default.collaxa.cube.ws>
<AdapterFramework::Outbound>
file:/u01/oracle/product/OracleAS1013/bpel/domains/default/tmp/.bpel_Service_1.0_f5da5f014b0f4740dd83b4de52acefa3.tmp/Details.wsdl
[
Details_ptt::DetailsSelect_id(Location_id_parameters,m042104Collection)
] - Rolling back JCA LocalTransaction
<2011-03-22 10:32:14,770> <ERROR> <default.collaxa.cube.ws>
<WSIFInvocationHandler::invoke> Fault happened:
file:/u01/oracle/product/OracleAS1013/bpel/domains/default/tmp/.bpel_Service_1.0_f5da5f014b0f4740dd83b4de52acefa3.tmp/Details.wsdl
[
Details_ptt::DetailsSelect_id(Location_d_parameters,m042104Collection)
] - WSIF JCA Execute of operation
'DetailsSelect_id' failed due to:
DBReadInteractionSpec Execute Failed Exception.
Query name: [DetailsSelect], Descriptor name:
[LocationDetails.m042104]. [Caused by: A syntax error has
occurred.]
; nested exception is:
ORABPEL-11614
DBReadInteractionSpec Execute Failed Exception.
Query name: [LocationDetails], Descriptor name:
[LocationDetails.m042104]. [Caused by: A syntax error has
occurred.]
See root exception for the specific exception. Caused by Exception
[TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.5.0) (Build
090715)): oracle.toplink.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: A syntax error has
occurred.Error Code: -201
Call:SELECT A t1.t, t1.t_a, FROM
m043104 t0, m042104 t1 WHERE ((t1.t = ?) AND (t0.t
(+) = t1.t))
bind => [null]
Query:ReadAllQuery(bpel___localhost_default_Service_1_0__MD5_b38e35d95c14a07509833f95bcb957a6_.LocationDetails.m042104).

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms