Thanks! Much better solution and seems like COMMIT and ROLLBACK works as expected. Nils
fredag 15. september 2023 kl. 09:54:43 UTC+2 skrev Evgenij Ryazanov: > 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/954b0be2-abad-43db-8e27-7bf2e4ce7921n%40googlegroups.com.
