pesymistic.Lock.java

Session session = getSession();
Transaction tx = null;
tx = session.beginTransaction();
Book book = (Book)session.get(Book.class, new Long(1));
String name = (String) session.createQuery("select b.name from bkch b where b.isbn = :isbn").setParameter("isbn", book.getIsbn()).uniqueResult();
System.out.println("book Name- "+name);
tx.commit();
session.close();


//Read Committed to Repeatable Read comes with scalability issues

Session session = getSession();
Transaction tx = null;
tx = session.beginTransaction();
Book book = (Book)session.get(Book.class, new Long(1));
session.lock(book, LockMode.UPGRADE);
String name = (String) session.createQuery("select b.name from bkch b where b.isbn = :isbn").setParameter("isbn", book.getIsbn()).uniqueResult();
System.out.println("book Name- "+name);
tx.commit();
session.close();