Hi, My application uses H2 in embedded mode and executes the SCRIPT command to create backups. With larger databases the backup script generation might run for quite some time (35 seconds for one of my databases) and it would be nice if the application user had an option to cancel it. However, the cancel() methods of java.sql.Statement does not seem to have any effect, the SCRIPT command continues to run until it finishes normally. The JDBC documentation clearly indicates that the cancellation of long running tasks is an optional feature, so maybe this is not implemented in H2. In that case, my request for enhancement is not to implement this feature in general, but to implement it only for the SCRIPT command (where, in contrast to the RUNSCRIPT command, aborting does not endanger data consistency). If, however, H2 already implements this feature, the behavior I observed indicates that there might be a bug in the SCRIPT command implementation.
PS: In a somewhat related posting to this group it was advised to make sure that the thread requesting the cancellation be not scheduled after the thread executing the SCRIPT command - from my debug output I can assure that this is the case. Best regards, Michael -- 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.
