Timeout error trying to lock table in h2

by

Yes, you can change the lock timeout. The default is relatively low: 1 second (1000 ms).

In many cases the problem is that another connection has locked the table, and using multi-version concurrency also solves the problem (append ;MVCC=true to the database URL).

EDIT: MVCC=true param is no longer supported, because since h2 1.4.200 it’s always true for a MVStore engine, which is a default engine.

More Related Contents:

  1. Executing script file in h2 database
  2. Insert & fetch java.time.LocalDate objects to/from an SQL database such as H2
  3. H2 in-memory database. Table not found
  4. How to access in memory h2 database of one spring boot application from another spring boot application
  5. Spring Boot default H2 jdbc connection (and H2 console)
  6. Frontend tool to manage H2 database [closed]
  7. How to find rows in one table that have no corresponding row in another table
  8. SQL query that gives distinct results that match multiple columns
  9. Populate JFreechart TimeSeriesCollection from Mysql DB?
  10. Can I have H2 autocreate a schema in an in-memory database?
  11. Connect to H2 database using IntelliJ database client
  12. Embedding the Java h2 database programmatically
  13. How to map a JSON column with H2, JPA, and Hibernate
  14. View content of H2 or HSQLDB in-memory database
  15. How in H2DB get sql dump like in MySql?
  16. H2 database error: Database may be already in use: “Locked by another process”
  17. H2 Database vs SQLite on Android [closed]

Leave a Comment