exception « sqlite « Java Database Q&A

1. SQLite java memory usage increases until an outofmemory exception    stackoverflow.com

I use SQLite in a java program. While the java program runs, several queries are sent to the database as well as temporary tables are created in memory and then deleted ...

2. SQLite DB is locked exception, how do I unlock it if I haven't ever toyed with it?    stackoverflow.com

java.sql.SQLException: database is locked
    at org.sqlite.DB.throwex(DB.java:288)
    at org.sqlite.NestedDB.prepare(NestedDB.java:115)
    at org.sqlite.DB.prepare(DB.java:114)
    at org.sqlite.Stmt.executeQuery(Stmt.java:89)
When I make a query I get this ...