In The scenario below, we are using EXTOL Business Integrator (EBI) 2.x to move database data to another database -- Source: iSeries DB2. Target: Oracle 11g
The error below is issued when we perform the SQL Insert to the Oracle 11g JDBC connection.
When we perform the JDBC SQL Insert, our Database Adapter is referencing a Data Source. The Data Source is not set-up correctly; the URL and Schema fields are incomplete
EXTOL error message:
Step #4: Execute Adapter: insert using F4780 Prod Schema
Invoking Interface Adapter.
Name : insert using F4780 Prod Schema
Version : 1.0
Interaction : Insert
No Column Metadata returned from Database. Check the Data Source used by this adapter.
JDBC Resource Adapter received a Standard Exception: No Column Metadata returned from Database
JDBC Resource Adapter received a Standard Exception while attempting to INSERT: JDBC Resource Adapter received a Standard Exception: No Column Metadata returned from Database
Execution of Adapter ended in error.
Ending Interface Adapter invocation.
After updating EXTOL Data Source URL and Schema, we were able to successfully perform a SQL Insert into the Oracle 11g tables.
By: Sean Hoppe on