When I do a series of delete operation in a H2 database as. ex remove a person recording in all related database tables, I think I can do the following:
1. SET AUTOCOMMIT FALSE 2. Beginning of delete person use PREPARE COMMIT deletePerson 3. If delete operation return normally without Exception, use COMMIT TRANSACTION deletePerson 4. If I experience an Exception, use ROLLBACK TRANSACTION deletePerson 5. In both cases the *close and reopen database ?* Will this work and is it really necessary to close and reopen database? Nils -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/dcc787d3-66ff-48e7-93ea-91031dcd2fbbn%40googlegroups.com.