Hibernate Community • View topic - jdbc batch size and pessimistic locking

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

jdbc batch size and pessimistic locking

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

iariap

Post subject: jdbc batch size and pessimistic locking

Posted: Wed Oct 11, 2006 3:18 pm

Newbie

Joined: Wed Oct 11, 2006 3:06 pm
Posts: 2
Location: Argentina

Hi,

I'm developing an application in witch I need to use both jdbcBatchSize (because of performance requirements) and pessimistic locking (setting the lockMode to UPDATE) using Oracle 10g.

When I enable batchSize I lose pessimistic locking (I need it to be "real time", not when hibernate decides to execute the batch of jdbc statements in the db) and when I disable batchSize I get the pessimistic locking back.

How could I have both things working at the same time?
Is there a way to specify the jdbc batch size per hibernate session? (this could help I think. I saw http://opensource.atlassian.com/project ... owse/HB-46 but it was rejected)

Thanks in advance!
Pablo.-

Top

iariap

Post subject: Re: jdbc batch size and pessimistic locking

Posted: Wed Oct 11, 2006 3:53 pm