wood burning stoves*
The moose likes Object Relational Mapping and the fly likes Optimistic concurrency in hibernate using version/timestamp. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Optimistic concurrency in hibernate using version/timestamp." Watch "Optimistic concurrency in hibernate using version/timestamp." New topic
Author

Optimistic concurrency in hibernate using version/timestamp.

sharath kumar reddy karnati
Greenhorn

Joined: Jul 23, 2007
Posts: 5
Hi All,

I didn't understand how optimistic concurrency will work in hibernate?

As per my knowledge, we need to have either VERSION or TIMESTAMP column in persistence table which is mappend to hibernate.

Say we are having TIMESTAMP column then whenever we execute INSERT,UPDATE statement hibernate will modify TIMESTAMP column with system timestamp. When we try to update a row and that row timestamp is differenent from the existing row timestamp then it determines as stale data and it will through the error message.

Please correct me if I'm wrong and also provide some example too.

Thanks in advance.

Sharath.
Prakhyat madgunaki
Greenhorn

Joined: Aug 07, 2007
Posts: 1
Below is a simple code, which will depict how optimistic locking/(concurrency control) will be done by hibernate.

// foo is an instance loaded by a previous Session
session = factory.openSession();
int oldVersion = foo.getVersion();
session.load( foo, foo.getKey() );

if ( oldVersion!=foo.getVersion )
throw new StaleObjectStateException();

foo.setProperty(“bar”);
session.flush();
session.connection().commit();
session.close();
 
Don't get me started about those stupid light bulbs.
 
subject: Optimistic concurrency in hibernate using version/timestamp.
 
Similar Threads
Original Data Verification before Update
equivalent of on_update current_timestamp in MSSQL.
Hibernate + locking
Caching of Database Access Objects's possible?
Hibernate Updating a Object