org.h2.jdbc.JdbcSQLException: The database is read only [90097-159]

osdir.com | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Opening existing DB in read-only mode may throw exception "The database is read only [90097-123]"

    Google Groups | 7 years ago | Rafferty
    org.h2.jdbc.JdbcSQLException: The database is read only [90097-159]
  2. 0

    Get connection failed - The database is read only [90097-159]

    Google Groups | 5 years ago | Steve Luo
    org.h2.jdbc.JdbcSQLException: The database is read only [90097-159]
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    H2 - The handle is invalid

    Stack Overflow | 2 years ago | user955732
    org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.IOException: The handle is invalid"; "C:/Users/myhome/mydb.h2.db"; SQL statement: select * from MESSAGES [90031-187]

    Root Cause Analysis

    1. org.h2.jdbc.JdbcSQLException

      The database is read only [90097-159]

      at org.h2.message.DbException.getJdbcSQLException()
    2. H2 Database Engine
      PageDataIndex.getPage
      1. org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
      2. org.h2.message.DbException.get(DbException.java:169)
      3. org.h2.message.DbException.get(DbException.java:146)
      4. org.h2.message.DbException.get(DbException.java:135)
      5. org.h2.engine.Database.checkWritingAllowed(Database.java:1626)
      6. org.h2.store.PageStore.logUndo(PageStore.java:996)
      7. org.h2.index.PageDataLeaf.create(PageDataLeaf.java:92)
      8. org.h2.index.PageDataIndex.getPage(PageDataIndex.java:227)
      8 frames