My Oracle Support Banner

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

Last updated on AUGUST 17, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.