Last updated on JANUARY 04, 2017
Applies to:Oracle SOA Suite - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
In the DB Adapter configuration the javax.resource.cci.ConnectionFactory connection group has a parameter for sequencePreallocationSize which is set to 50. This value was changed to 1 but has not altered the behavior at runtime.
These are the steps followed:
Login to Uat soa console:
Click on “Lock and edit”.
Click on “Deployments” --> “DbAdapter”
Click on “Configuration” --> “Outbound Connection pools”
Click on “+” and click on eis/DB/VLTD
In the outbound connection properties table , Double click on “SequencePreAllocatioonSize” “property value “ column where it is set to 50.
Set it to “1” and hit enter [The change doesn’t happen otherwise] and Save.
Go back to “Deployments” select “DbAdapter” and click “Update”
Click “Finish” in the next screen .
Activate the changes
No restart is required
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms