On Thursday, November 3, 2011, timbo <[email protected]> wrote: > Thanks, that helps. > > Q1: When you say "only between individual rows" how does that work > with canceling a single long running query - can it be done?
It checks for cancellation every 100 rows or so > Q2: After canceling an UPDATE that is part of a larger transaction, > my thread should get an exception and I can then rollback the entire > transaction, correct? > Correct. > On Nov 3, 4:01 am, Noel Grandin <[email protected]> wrote: >> cancel() is supported, but it does not support cancelling an in-progress single-row insert. >> cancel() supports stopping a long-running SELECT, UPDATE or DELETE, but only between individual rows. >> >> >> >> timbo wrote: > ... > > -- > 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. > > -- 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.
