No Column Metadata returned from Database

No Column Metadata returned from Database

Scenario:

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.

Issue:

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

Starting Comm
Invoking Interface Adapter.
Name : insert using F4780 Prod Schema
Version : 1.0
Interaction : Insert
[email protected]
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.
Completed Task.

EXTOL Business Integrator (EBI) SQL Database Insert Error No Column Metadata Returned from Database

Resolution:

After updating EXTOL Data Source URL and Schema, we were able to successfully perform a SQL Insert into the Oracle 11g tables.



By: on
A free web counter provided by GoStats.