On Sat, Jul 20, 2013 at 3:11 PM, Thomas Mueller <[email protected]> wrote: > >> That would allow the Trigger instances to create and cache >> PreparedStatements in their init() method. > > Yes, if you look at the FullTextTrigger class (package org.h2.fulltext), you > can already cache the prepared statements, using this system session. >
Yeah, but that can lead to deadlocks, because the PreparedStatements execute on a different session from the current session. e.g. see this previous discussion: https://groups.google.com/d/topic/h2-database/B3xG488RBhI/discussion -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
