My Oracle Support Banner

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

Last updated on SEPTEMBER 07, 2018

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
  Symptoms
  Cause
  Solution

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.