Eclipse Community Forums: EclipseLink » JDBC transaction isolation?

Help

Home

Home » Eclipse Projects » EclipseLink » JDBC transaction isolation?

Show: Today's Messages :: Show Polls :: Message Navigator

JDBC transaction isolation? [message #386606]

Mon, 06 April 2009 20:26

andiqo

Messages: 32
Registered: July 2009

Member

Hello again,

How could I set the JDBC transaction isolation to "repeatable-read" in
EclipseLink? I am using EclipseLink/JPA in a simple environment (not
managed).

Thanks again!

andiqo

Report message to a moderator

Re: JDBC transaction isolation? [message #387021 is a reply to message #386606]

Tue, 07 April 2009 13:14

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

You may be able to set this as a default in your database, or as a JDBC or
DataSource option.

In EclipseLink you can set it using the setTransactionIsolation() method
on DatabaseLogin. You can set this using a SessionCustomizer, although
ideally there would be a persistence.xml property for this, so please log
a bug for that.

i.e.
session.getLogin().setTransactionIsolation(DatabaseLogin.TRA NSACTION_REPEATABLE_READ);

You may also wish to investigate optimistic or pessimistic locking.

See also,
http://en.wikibooks.org/wiki/Java_Persistence/Locking

---
James
http://www.nabble.com/EclipseLink---Users-f26658.html

James : Wiki : Book : Blog : Twitter

Report message to a moderator

Previous Topic:	How to configure buildSelectQueryForIdentity()
Next Topic:	escaping table names

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 07:22:30 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter