1 Reply Latest reply: Mar 30, 2013 6:40 PM by jschellSomeoneStoleMyAlias RSS

    Exception while trying to open sqlite DB with having pagesize as 64KB


      I have a java program which interacts with SQLite DB having journal_mode as delete.

      This program works fine for all DB and I am able to do transactions as far as DB has pagesize of 32 KB.

      But there is one sqlite DB which is having pagesize as 64 KB. And when I try to execute stmt.executeQuery(); on that DB, it gives me exception
      java.sql.SQLException: [SQLITE_NOTADB] File opened that is not a database file (file is encrypted or is not a database)

      Can anybody please let me know what could be the solution for this? This DB is not encrypted and having journal_mode as delete only.

      I am able to open this DB with SQLITESpy tool though.