Access Berkeley DB with sqlitejdbc-v056.jar: Database Locked
893800Nov 16 2011 — edited Nov 24 2011I use the sqlite jdbc to access a new Berkeley DB (Version 5.2.36). Everytime I do this I get the following Message:
java.sql.SQLException: database is locked
at org.sqlite.DB.throwex(DB.java:288)
at org.sqlite.NativeDB.prepare(Native Method)
at org.sqlite.DB.prepare(DB.java:114)
at org.sqlite.Stmt.executeUpdate(Stmt.java:102)
at TestProgram.main(TestProgram.java:25)
There is no other thread accessing this database so the database can not be locked. I suppose that the Database is not compatible with SQLite. I found a guide to configure Berkeley DBto be compatible with SQLite, but only for UNIX Systems. What do I have to do on a Windows System?
If I let my little JAVA Program create the database instead of using an existing BDB an SQLite database is created and not a Berkeley DB. Maybe this information is relevant.
Any comment on this would be appreciated.