Update to DB2/400 Table Using DB Adapter Fails with SQL7008 (Doc ID 565034.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle(R) BPEL Process Manager - Version 10.1.3.1 and later
OracleAS Adapters - Version 10.1.3 and later
Oracle ESB - Version 10.1.3 and later
Information in this document applies to any platform.
Oracle(R) BPEL Process Manager - Version: 10.1.3.1
Oracle ESB - Version: 10.1.3
This problem can occur on any platform.

Symptoms

When initiating a process which uses a DB Adapter to perform an insert to a DB2/OS400 database with an unjournaled table, you see the following error:

ERROR
============
"java.sql.SQLException: [SQL7008]  XXXXX  in YYYYYY not valid for operation."


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