Hibernate optimistic locking vs Database Isolation levels
Hi,
Among Hibernate optimistic locking & Database Isolation levels, which one to use? Which gives the better consistency, concurreny and scalaility. I read in couple of links that Isolation level will suffer if there is a huge load on the application with multiple users access the appliation at the same time, moreover in islation levels normally we need to look for READ_COMITTED and NON_REPEATABLE_READ to get a better performance? Whether these are true? Whether we can use both Hibernate optimistic locking(version & timestamp) & Database Isolation levels in the same application? What are the implications using these? Which one will be prefereed over the other and when? Please clarify.
Thanks.