Hi, I'm afraid I don't have a good solution for this problem.
You can increase the lock timeout: http://www.h2database.com/html/grammar.html#setlocktimeout You can try if the MVCC mode works for you: http://www.h2database.com/html/advanced.html#mvcc Regards, Thomas On Fri, Mar 6, 2009 at 3:03 PM, kedwards <[email protected]> wrote: > > Also, it should be noted that the inserts are happening on one thread > on a server and the queries are "on demand" from a user's client > application. > > > On Mar 5, 4:48 pm, edwardsk <[email protected]> wrote: >> I get the following error while a long running query is in the process >> of executing... and an attempt to call an insert statement (batch of >> inserts via preparedStatement). >> >> Timeout trying to lock table PAST_SCOREBOARD_CHANNEL_DATA [50200-107] >> >> Please note we are using MULTI_THREADED=1 in our db connection url. > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
