[sqlite] SQLite-jdbc Bug - database table is locked

2016-02-24 Thread Dan Kennedy
On 02/24/2016 09:49 AM, Pankaj Bisen wrote: > Hello Everyone, > > I have two unrelated tables table_A and table_B in my SQLite DB. Trying to > drop table_B while a resultset is open on table_A throws > "java.sql.SQLException: database table is locked". That's an SQLITE_LOCKED error. Here:

[sqlite] SQLite-jdbc Bug - database table is locked

2016-02-24 Thread Simon Slavin
On 24 Feb 2016, at 2:49am, Pankaj Bisen wrote: > I have two unrelated tables table_A and table_B in my SQLite DB. Trying to > drop table_B while a resultset is open on table_A throws SQLite does not have table-level locking. If anything in the database file needs to be locked then the whole

[sqlite] SQLite-jdbc Bug - database table is locked

2016-02-24 Thread Pankaj Bisen
Hello Everyone, I have two unrelated tables table_A and table_B in my SQLite DB. Trying to drop table_B while a resultset is open on table_A throws "java.sql.SQLException: database table is locked". Following simple code will illustrate the Bug clearly. public class Class1 { public static