[sqlite] org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)

2016-12-07 Thread Jay Weinstein
Hi, I’m running two programs, one written in java and one written in C, which are both trying to access a sqlite database. I'm getting the error org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked) when I run both as separate processes and when the java

Re: [sqlite] org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)

2016-12-07 Thread Jay Weinstein
ttps://www.sqlite.org/c3ref/busy_timeout.html > > and > http://www.sqlite.org/tclsqlite.html > see the section: The "timeout" method > > > > On 2016/12/07 8:54 PM, Jay Weinstein wrote: > >> Hi, >> >> I’m running two programs, one written in java and one written

Re: [sqlite] org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)

2016-12-09 Thread Jay Weinstein
t; -Original Message- > > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > > On Behalf Of Jay Weinstein > > Sent: Friday, 9 December, 2016 11:50 > > To: SQLite mailing list > > Subject: Re: [sqlite] org.sqlite.SQLiteException: [SQLITE

Re: [sqlite] org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)

2016-12-09 Thread Jay Weinstein
db; config = new SQLiteConfig(); config.setBusyTimeout("100"); conn = DriverManager.getConnection(s, config.toProperties()); conn.setAutoCommit(false); stmt = conn.createStatement(); On Wed, Dec 7, 2016 at 4:17 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 7 Dec 2016,

Re: [sqlite] org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)

2016-12-07 Thread Jay Weinstein
a feature, a basic necessity even. > > The answer is here: > http://www.sqlite.org/pragma.html#pragma_busy_timeout > > Explanation: > https://www.sqlite.org/c3ref/busy_timeout.html > > and > http://www.sqlite.org/tclsqlite.html > see the section: The "timeou