WLS 10.0: Deployment Descriptor Configuration When Using Named Sequence Tables For Primary Key Generation. (Doc ID 1087752.1)

Last updated on NOVEMBER 07, 2023

Applies to:

Goal

You might have occasional concurrency problems for a specific Entity Bean in a multiple-server environment.  You will notice the error, [EJB:011103]Automatic Key Generation Error... apparently due to a Transaction Timeout (apparent DB lock contention).
After this error, you will notice a partial DB update and the data is corrupted.  The Entity Bean uses automatic key generation via a Named Sequence Table.
You will not explicitly be setting <transaction-isolation><isolation-level> as TransactionSerializable for this Entity Bean.  Does this option needs to be explicitly be set, or does WebLogic implicitly set it when the 'NAMED_SEQUENCE_TABLE' for automatic key generation type is used?
What is the optimal <automatic-key-generation><key-cache-size> when the table in question requires inserts from both a WebLogic-based EJB application, and a non-WebLogic standalone Java application? i.e. can both applications use the Sequence table to learn the next available key?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.