Hello. You really should use an identity column instead of sequence with such trigger in both Oracle and H2 instead of all these complications with triggers.
But if you need to execute some more complicated actions in the trigger, you need to write an own class with implementation of org.h2.api.Trigger and define a trigger using an H2-specific CREATE TRIGGER command: https://h2database.com/html/commands.html#create_trigger -- 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/ee650c4a-1fee-44b5-b54a-a5eaf914f40do%40googlegroups.com.
