Hi, > Can I have 2 different connections that participate in the same transaction?
No. > So if 2 connections belong always to 2 separate transactions then it follows > that > if I would use the connection stored in the trigger instance in the remove() > method > it would not participate in the drop trigger transaction and thus even if I > would > throw an exception the drop trigger would succeed. I don't know, you would need to try out. > So what about the connection provided to the fire method. > Is that connection the same connection that did some action to the table > and thus caused the trigger to fire. To me it seems that this connection > belongs to the same > transaction that caused the trigger to fire. Yes. > But what happens if I do commit. For example if I create a table or some > other object it has a side > effect of committing a transaction. Did you try it out? > That´s a good idea. But whose privileges does that connection have? I think the connection has admin rights, but I'm not sure. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to h2-datab...@googlegroups.com. To unsubscribe from this group, send email to h2-database+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
