Eclipse Community Forums: EclipseLink » Pessimistice locking hint

Home » Eclipse Projects » EclipseLink » Pessimistice locking hint - hanging locks

Pessimistice locking hint - hanging locks [message #479759]

Wed, 12 August 2009 08:25

Eclipse User

It is possible to place locks during querying using the Eclipselink JPA enhancement "pessimistic lock hint".
http://blogs.sun.com/enterprisetechtips/entry/preventing_non _repeatable_reads_in

When you do this without having started the EM's transaction, Eclipselink starts a JDBC transaction to the database and does a select-for-update instead of a regular select.
The JDBC transaction is required, because that determines how long locks are held; upon commit or rollback and "for update" locks are released.

However, the EM's transaction is not started (getTransaction().isActive() returns false), so if you do not start the EM's transaction, the locks are never released.

Is there any way to release these for-update locks without starting the EM's transaction?

Re: Pessimistice locking hint - hanging locks [message #480834 is a reply to message #479759]

Tue, 18 August 2009 11:29

Eclipse User

You should never acquire a pessimistic lock outside of a transaction.
Always first call beginTransaction. You can log a bug that an exception
should be throw if pessimistic locking is attempted outside of a
transaction.

----
James

Previous Topic:	loader constraint violation
Next Topic:	Cache Refresh Problem

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 22 22:49:04 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter