Is there a recommended pattern for controlling transaction
boundaries with CMP?
We have an entity bean layer where all entity beans have
transattribute = Supports
And an session bean layer facade above that where all
session beans have:
transattribute = Required
We recently switched from MySQL to MS SQL Server and
have noticed an intermittent problem where a transaction
never commits and the system hangs because other threads
start piling up waiting for a row that is locked in
the transaction that isn't committing.
I'm not sure if this is a JBoss issue or if we should
be doing something different with our CMP transaction
semantics.
Maybe we've outgrown CMP and it's time to switch
to BMP??
Tx for your thoughts and insights!
JD
