Spring Pessimistic locking
i have spring project under java, using hibernate query, i like to use pessimistic locking.
How to do Pessimistic locking in Spring开发者_Go百科 + Hibernate?
Edit:
@Loggable(value = LogLevel.TRACE)
@Transactional
@Override
public void updateBalance(String id, BigDecimal amount) {
Session session = sessionFactory.getCurrentSession();
sessionFactory.openSession();
Transaction tx = session.beginTransaction();
session.flush();
Account acc = (Account) session.get(Account.class, id, LockMode.UPGRADE);
acc.setName("New Account");
acc.setBalance(acc.getBalance().subtract(amount));
save(acc);
try{
tx.commit();
}catch (TransactionException e){
tx.rollback();
}
session.close();
}
Problem:
i want to use pessimistic locking in a method, and i call this method from different to methods. pessimistic works fine when i call it from the first method, but it gives (Transaction couldn't be commit) when i call it from the second method
Exception:
Could not commit Hibernate transaction; nested exception is org.hibernate.
TransactionException: Transaction not successfully started
http://www.amicabile.com/hybernate/hybernate-chapter5.html
http://javacompleteexamples.blogspot.com/2009/07/how-db-locking-system-works-in.html
Edit:
try:
@Override
@Loggable(value = LogLevel.TRACE)
@Transactional
public void updateBalance(String id, BigDecimal amount) {
Account acc = (Account) sessionFactory.getCurrentSession().get(Account.class, id, LockMode.UPGRADE);
acc.setBalance(acc.getBalance().subtract(amount));
save(acc);
}
精彩评论