Yeah, sorry, our architecture doesn't allow that at the moment.
At some point in the future we should be capable of opening connections inside triggers and performing commits using our new MVStore engine. However, I can't see that performing DDL inside a trigger is ever going to work.
The only thing I can think of at the moment is to spin off the logic into a separate worker thread that opens it's own connection.
On 2014-04-06 16:22, Christian wrote:
I have been experimenting with H2 and would like to use the Trigger mechanism to update the structure of a separate table.
-- 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 h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
