public void testBeginAndCommitTransaction() throws Exception {
TransactionStuff txl = SqlObjectBuilder.attach(handle, TransactionStuff.class);
txl.insert(8, "Mike");
txl.begin();
txl.updateName(8, "Miker");
assertEquals("Miker", txl.byId(8).getName());
txl.rollback();
assertEquals("Mike", txl.byId(8).getName());
}
public void testTransactionIsolationActuallyHappens() throws Exception {
TransactionStuff txl = SqlObjectBuilder.attach(handle, TransactionStuff.class);
TransactionStuff tx2 = SqlObjectBuilder.open(dbi, TransactionStuff.class);
txl.insert(8, "Mike");
txl.begin();
txl.updateName(8, "Miker");
assertEquals("Miker", txl.byId(8).getName());
assertEquals("Mike", tx2.byId(8).getName());
txl.commit();
assertEquals("Miker", tx2.byId(8).getName());
tx2.close();
}