AS/400 Database Adapter requiring AS/400 tables to be Journaled even though a non XA Data Source is used (Doc ID 2099040.1)

Last updated on JANUARY 22, 2016

Applies to:

Oracle SOA Suite - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Goal

On : 11.1.1.6.0 version, Technology Adapters

AS/400 Database Adapter is requiring AS/400 tables to be Journaled.

After setting up a Data Source for a Database Adapter that connects to IBM AS/400, writing to or updating tables on the AS/400 throws an error message stating that the tables need to be journaled. On the AS/400 journals are used to track changes to a database table and should ONLY be required when using an XA datasource. The Data Source was configured as non-XA and if a journal was added to the table the update is successful.

 

Solution

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