I am using version count as optimistic locking apparoch with hibernate.
It is working well. Now with the new requirment, there is some external application which updates the Order(table) data.But these applications are not updating version count.
can anybody gives me tips to ensure optimistic lock to work here. I wrote trigger which updates the version count whenever there is an update, but this is resulting simple update itself is failing.I really didnt understand why this trigger approach is not working. am I missing something here?

Regards
Nagesh G


Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

To add more point on the same question,

I am getting the following exception:

org.hibernate.HibernateException: Duplicate identifier in table for: [com.tollbrothers.archonline.va
lueobjects.archdoc.OrdersDTO#1081]
at org.hibernate.persister.entity.BasicEntityPersister.check(BasicEntityPersister.java:1460)


Regards
Nagesh G

Issue is resolved. the Problem is with trigger only.