Could you be a little more specific as to what you mean when you say "additional server roundtrip"? Where do you think trigger code is execute? On the client-side or on the server-side?

- rami

On 10.1.2013 14:08, [email protected] wrote:
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.

--
You received this message because you are subscribed to the Google Groups "H2 
Database" group.
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.

  • TRIGGERS bios . quixy
    • Re: TRIGGERS Rami Ojares

Reply via email to