Hi all, I have a question about triggers. I want to use trigger for data consistency check. In H2 database implementation it is like that a method fire(...) is called when trigger is executed, e.g. in my case before INSERT. I need to execute select in the fire method for check in the database if record is already there, so I have to call PreparedStatement, etc.
The question is if there is additional server roundtrip when fire method calls select on the database. I need to know that because I use batches and there are a lot of inserts, i.e. if there should be server roundtrip for each insert, it would not be ideal solution. Thanks! -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/8h-nCb0M3PgJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
