Hibernate transaction problem

Question

When I execute some queries inside Hibernate transaction -> the data successfully updated in my mysql, but in my application there are still old values. When i restart - it`s Ok. If i set autocommit mode - works fine, but i have to use transaction ;-). Any ideas? Thanks in advance.

Answer 1

Manipulating the database directly with UPDATE doesn't affect the objects cached in the session. You should clear the session (Session.clear()). Something like:

session.flush()
session.clear()
query.executeUpdate()

Or even better, you can avoid the problem by not using update queries and manipulating the object state in memory:

myobj.setName(newValue)
session.saveOrUpdate(myobj)

Answer 2

May be i`m doing something wrong here is conqrete method:

public void updateOperation(OperationObject operationObject) throws Exception {
  Session dbSession = openSession();
  Transaction tx = dbSession.beginTransaction();
  try {
    //update turn over report
    turnOverManager.updateTurnOver(dbSession, operationObject);

    // if step 1 is OK update operation table
    dbSession.merge(operationObject);
    dbSession.flush();

    tx.commit();
  } catch (Exception e) {
    e.printStackTrace();
    tx.rollback();
    // send back error message to client
    throw new Exception(e.getMessage());
  } finally {
    dbSession.close();
  }
}