G'day, I'm using 0.36 nested, and am having a locking problem. It
seems that after doing an executeUpdate() call from a
PreparedStatement, the db gets locked and I can't do any queries on
the db from any other connections. A -journal file is created while
this is the case. My java app seems to run fine though, it can keep
doing queries/updates.
If I shutdown my java app, I can then use sqlite3 command line to do a
query, this works, and the -journal file goes away.
My prepared statement is pretty simple, I do something like:
PreparedStatement stat = conn.prepareStatement("UPDATE foo SET bar = ?
WHERE id = ?");
stat.setLong(1, new Date().getTime() / 1000);
stat.setInt(2, 1);
stat.executeUpdate();
stat.close();
I do Connection conn =
DriverManager.getConnection("jdbc:sqlite:filename"); once at startup,
and use conn throughout my entire app.
Any ideas why this might be happening?
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---
