hi, im trying to get transactions to work but either I missed something very important in the docs or I dont know whats going on..

anyways heres the code im trying to run, i was expecting an ObjectNotFoundException to be thrown when trying to load the object at the end but its not happening, please help!


Session session = HibernateSession.currentSession();

session.setFlushMode(FlushMode.COMMIT);

Long userId = null;

Transaction tx = null;
try {
tx = session.beginTransaction();

User u = new User();
u.setName("testtx");
u.setPassword("testpassword");
session.save(u);

userId = u.getId();
System.out.println("User u: " + u);

tx.rollback();
} catch (Exception e) {
e.printStackTrace();
}

User ru = (User) session.load(User.class, userId); // shouldnt a ObjectNotFoundException be thrown here?
System.out.println("User ru: " + ru);

HibernateSession.closeSession();

this is the output:
User u: test.model.User@e22f2b[id=524289]
User ru: test.model.User@e22f2b[id=524289]

Try flushing before you rollback.

ok i put session.flush() right before the call to tx.rollback() and got this exception:


[ERROR] JDBCTransaction - Rollback failed
java.sql.SQLException: General error: Warning: Some non-transactional changed tables couldn't be rolled back

whats going on here?

ok i was able to track that error, it was from mysql, i had to create the tables as type innodb so I did that, but still trying to figure this transactions stuff out..

ok after more testing, turns out i had to evict the object right after the rollback because it was still in the session cache, this was not the behaviour i expected, so now its working as i thought it should have with output like this:

User u: test.model.User@1071c84[id=983041]
net.sf.hibernate.ObjectNotFoundException: No row with the given identifier exists: 983041, of class: test.model.User
at net.sf.hibernate.impl.SessionImpl.throwObjectNotFound(SessionImpl.java:1690)
at net.sf.hibernate.impl.SessionImpl.load(SessionImpl.java:1701)
at test.MiscTest.main(MiscTest.java:47)