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

2016-12-09 Thread Keith Medcalf
er developers is in order. > > > > > > > -Original Message- > > > From: sqlite-users [mailto:sqlite-users- > boun...@mailinglists.sqlite.org] > > > On Behalf Of Jay Weinstein > > > Sent: Friday, 9 December, 2016 11:50 > > >

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

2016-12-09 Thread Jay Weinstein
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_BUSY] The > > database

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

2016-12-09 Thread Keith Medcalf
qlite-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_BUSY] The > database file is locked (database is locked) > > When I run the two C programs using

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

2016-12-09 Thread Jay Weinstein
When I run the two C programs using rc = sqlite3_busy_timeout(db, 1000); if ( rc != SQLITE_OK ) { fprintf(stderr, "SQL error: sqlite3_busy_timeout failed.\n"); exit(0); } everything works perfectly. No sqlite busy erros or table locked. But, whe

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

2016-12-07 Thread Simon Slavin
On 7 Dec 2016, at 11:28pm, Jay Weinstein wrote: > Is it correct to say busy timeout will work for two separate processes and > I don't have use fork in C/C++ or ProcessBuilder in java to execute one as > a child and a parent? The timeout setting is attached to the database connection. If you e

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

2016-12-07 Thread Jay Weinstein
Hi, Is it correct to say busy timeout will work for two separate processes and I don't have use fork in C/C++ or ProcessBuilder in java to execute one as a child and a parent? Thanks, Jay On Wed, Dec 7, 2016 at 11:02 AM, R Smith wrote: > Yes, multiple access is a feature, a basic necessity eve

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

2016-12-07 Thread Jay Weinstein
Thanks for the info! On Wed, Dec 7, 2016 at 11:02 AM, R Smith wrote: > Yes, multiple access is 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://ww

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

2016-12-07 Thread R Smith
Yes, multiple access is 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 "timeout" method On 2016/12/07 8:54 PM

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

2016-12-07 Thread Simon Slavin
On 7 Dec 2016, at 6:54pm, Jay Weinstein wrote: > 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

[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