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.

Reply via email to