Hi, I recently added data backup functionality to my application, which uses H2 in embedded mode. However, I noticed that while the SCRIPT command is running, select statements seem to be blocked. The SQL grammar documentation for the SCRIPT command is not specific about what kind of locking is performed during command execution, but from my observations I assume that read access is not permitted. This is unfortunate, since backup script generation can take quite some time (around 35 seconds with one of my databases), and preventing read access to the database results in blocking the whole application. Therefore my request for enhancement: is it possible to improve the SCRIPT command locking strategy to permit read accesses to the database while it is running?
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.
