And the question this time..
I have a stateless session bean which uses
Connection conn = dbAccess.getConnection();
// Execute SQL query...
conn.commit();
conn.close();
This is an example of bean managed persistence, is this correct?
I have container managed transactions with the Required attribute.. after I do the conn.commit(); lets imagine an exception occurs ( I force throw an EJBException()).. when I look in my db tables my executed and commited SQL code is there..
Should'nt the transaction have been rolled back? i.e the changes to the db are undone.. What am I missing here.. Does CMT and BMP not mix? (as im explicitly commiting my changes.. with conn.commit()).. What are my other options?
Thanks in advance,
Alan