Hello! These commands aren't going to work.
You need to disable auto-commit, execute your commands and commit or rollback your transaction. In JDBC, you can use Connection.setAutoCommit(false), Connection.commit(), and Connection.rollback(). In SQL you can use SET AUTOCOMMIT OFF, COMMIT, and ROLLBACK. After commit or rollback a new transaction will be started automatically. Don't call PREPARE COMMIT name, COMMIT TRANSACTION name, ROLLBACK TRANSACTION name etc, these commands are used by more expensive two-phase commit protocol. Most likely you don't need it here. You can use it, of course, but in that case PREPARE COMMIT must be executed after data modification commands. -- 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/4821816e-3cb1-43a5-be08-7b8b6efb7d8bn%40googlegroups.com.