Sunday, February 12, 2012

SOA 11g DB Sequence Reset Issue

Ever wondered why the primary key sequence is reset while using a DB adapter to insert records from your SOA application?

The issue is that the DB adapter pre-allocates sequence values based on the value configured in the DB Adapter's outbound connection pool.

To overcome this issue, ensure that the "sequencePreallocationSize" property value matches the value that was specified for sequence increment in DB during sequence creation. For example 1.

No comments:

Post a Comment