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.