On 2014-07-09 07:42 AM, Su Yeon Kim wrote:
And How do I set up LOCK_TIMEOUT=10000 ?
You can increase the lock timeout by modifying the JDBC URL e.g. see here: http://h2database.com/html/grammar.html#set_lock_timeout But the best way is to improve the performance of your queries so that they don't lock the tables for as long. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To post to this group, send email to h2-database@googlegroups.com. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.