Commit Option B or C

rafcio Mar 30, 2005 7:28 AM

Hi,

our application is running with JBoss 3.2.5 on two linux servers. We do not use clustering, but Commit Option C with row-locking for much of our entity beans:

 <container-configuration extends="Instance Per Transaction CMP 2.x EntityBean">
 <container-name>Standard CMP 2.x EntityBean with Commit Option C</container-name>
 <commit-option>C</commit-option>
 </container-configuration>

The database could (sometimes) be changed by other application.

Without

Instance Per Transaction CMP 2.x EntityBean

we get Deadlock on big load. Why?

Now I'm thinking about change the container configuration to commit option B. Will it be better for my application?

Best Regards,
Rafal