Mark Berry wrote:
Hi I'm using OJB rc4 with a Progress Db.
Progress supports 4 different transaction isolation levels: Committed read, Uncommitted read, Repeatable read, and Serializable.
My question is, Is there any way to change the transaction level on a per transaction basis? Currently the isolation level is set in the repository to "read-uncommitted".
The 'isolation-level' attribute of descriptor-repository and class-descriptor elements is ODMG specific and does not touch the DB transaction isolation level.
see
file:///E:/intellij/OJB_Experimental/db-ojb/target/doc/repository.html#descriptor-repository
You can set the Connection tx-isolation level at runtime (Connection#setTransactionIsolation), thus on a per transaction basis. If you are in a managed environment I think it's not allowed to change the tx-level.
To lookup the connetion from the used PB instance call
PB.serviceConnectionManager#getConnection() before start with the PB-tx.
regards, Armin
Regards
Mark Berry
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
