Hibernate Community • View topic - INSERT statements and flush() behavior

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

INSERT statements and flush() behavior

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

mahdouch

Post subject: INSERT statements and flush() behavior

Posted: Sun Mar 07, 2010 9:00 pm

Newbie

Joined: Thu Sep 10, 2009 3:03 pm
Posts: 5

I have the following two parallel transactions
TX1:
begin TX1
insert(person(unique_id=1))
flush
commit TX1

TX2:
begin TX2
insert(person(unique_id=1))
flush
commit TX2

I know that only one commit statement will succeed due to the unique constraint. My question is, is there any possibility that the flush() call will succeed and the commit() fails due to a constraint violation exception.

I'm in read committed isolation level using Oracle db.

Top

pb00067

Post subject: Re: INSERT statements and flush() behavior

Posted: Mon Mar 08, 2010 3:41 am

Expert

Joined: Tue Jun 16, 2009 3:36 am
Posts: 990

Quote:

is there any possibility that the flush() call will succeed and the commit() fails due to a constraint violation exception.

Not at Hiberante level.
But I know there are some databases which let choose the user if indexes should be validated immediately or at commit-time.
I don't know if Oracle has this feature. (Maybe its better to ask in a Oracle-user-forum)

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum