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.
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