Skip to Content
0
Former Member
Dec 01, 2006 at 02:18 PM

JDBC Receiver Adapter -- Synch Select. ERROR

64 Views

Hello,

We have implemented the scenario described by Bhavesh Kantilal in blog 3928:

JDBC Receiver Adapter -- Synchronous Select – Step by Step

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

but modified to our requirements.

An Idoc is coming in, mapped to a sync receiver jdbc as described to collect data from a jdbc table.

Result when connecting the oracle database with the jdbc receiver adapter:

Error processing request in sax parser: Error when executing statement for table/stored proc. 'T_ST_MAINDRIVER' (structure 'STATEMENT'): java.sql.SQLException: ORA-00942: table or view does not exist

Oh, like to complete the information by the payload from the jdbc rec. connect:

<?xml version="1.0" encoding="UTF-8" ?>

- http://www.xxx.org/excel">

- <STATEMENT>

- <TABLENAME ACTION="SELECT">

<TABLE>T_ST_MAINDRIVER</TABLE>

<ACCESS />

- <KEY>

<MAINDRIVER compareOperation="=">Optomechanical</MAINDRIVER>

</KEY>

</TABLENAME>

</STATEMENT>

</ns0:MT_JDBC_LOOPUP_ID>

The table exists on the database. So, what is our mistake? Do you have any ideas?

Best regards

Dirk

Message was edited by:

Dirk Meinhard

Message was edited by:

Dirk Meinhard