isolation level 0 and java persistence frameworks

[Former Member]

Hi,

i use www.castor.org as my persistence framework, castor have have its own lock engine and cache for entities, then i think to avoid some table lock in database to pass for JDBC connection the parameter isolation=0, as any update or write is made and controlled by castor in castor i dont have dirty data, anyone have experience with any other java persistence engine and used maxdb with lock engine managed by framework?

any insight about this are welcome.

best regards

Clóvis

[lbreddemann · Accepted solution]

> Hi,

>

> i use www.castor.org as my persistence framework, castor have have its own lock engine and cache for entities, then i think to avoid some table lock in database to pass for JDBC connection the parameter isolation=0, as any update or write is made and controlled by castor in castor i dont have dirty data, anyone have experience with any other java persistence engine and used maxdb with lock engine managed by framework?

>

Sure

The whole SAP NetWeaver stack runs with isolation level 0.

Works quite fine.

In fact there are certain features (like the count(*) optimization) that don't work consistently with isolation level 1 (read commited).

So you shouldn't get into trouble with that.

regards,

Lars