Issue In Polling Data From Turboimage Database (Hp3000) Using Soa 11g Database Adapter (Doc ID 1310149.1)

Last updated on JANUARY 04, 2017

Applies to:

Oracle SOA Platform - Version: 11.1.1.3.0 and later   [Release: 11gR1 and later ]
Information in this document applies to any platform.

Symptoms


When trying to create an integration between TurboImage Database and Oracle EBS Database using Fusion Middleware (BPEL), we poll a table in TurboImage database. For this purpose we are using Database Adapter.
For the JDBC connection, we are using a customer JDBC Driver JAR file. The JDBC driver is Type 1 Driver.
The Issue is the BPEL process is throwing an error while trying to Poll data (Basically BPEL process is trying to execute an SQL statement for Polling) from TurboImage Database (HP3000).
The Error Message is :


Polling the database for events failed on this iteration.
Caused by java.sql.SQLException: [ODBCLINK Host]Bitsetparams: buffer size mismatch .


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