Frank Finner wrote:
In Java, assuming you have a Connection c, you simply say "c.commit();" after doing some action on the database. After every commit, the transaction will be executed and closed and a new one opened, which runs until the next commit.
Assuming, of course, you started with c.setAutoCommit(false); -- Guy Rouillier