Re: [sqlite] Disconnected machine with database, SELECT still works !

2006-09-23 Thread Trevor Talbot
On 9/23/06, Martin Alfredsson <[EMAIL PROTECTED]> wrote: >How exactly are you accessing the database over the network? Two machines with Windows XP on a LAN. Using file sharing a place my app.exe on one machine and instructs it to use the file (database) on the other machine,

Re: [sqlite] sqlite3_close doesn't release always the file handle.

2006-09-23 Thread Joe Wilson
--- [EMAIL PROTECTED] wrote: > Joe Wilson <[EMAIL PROTECTED]> wrote: > > --- [EMAIL PROTECTED] wrote: > > > Ran <[EMAIL PROTECTED]> wrote: > > > > Hi all, > > > > > > > > I *think* that sqlite3_close behave strangly. > > > > > > > > I use version 3.3.7 on Linux (Fedora Core 5). > > > > > > > >

Re: [sqlite] sqlite3_close doesn't release always the file handle.

2006-09-23 Thread drh
Joe Wilson <[EMAIL PROTECTED]> wrote: > --- [EMAIL PROTECTED] wrote: > > Ran <[EMAIL PROTECTED]> wrote: > > > Hi all, > > > > > > I *think* that sqlite3_close behave strangly. > > > > > > I use version 3.3.7 on Linux (Fedora Core 5). > > > > > > What I do is to open a database, and start a

Re: [sqlite] sqlite3_close doesn't release always the file handle.

2006-09-23 Thread Joe Wilson
--- Joe Wilson <[EMAIL PROTECTED]> wrote: > --- [EMAIL PROTECTED] wrote: > > Ran <[EMAIL PROTECTED]> wrote: > > > Hi all, > > > > > > I *think* that sqlite3_close behave strangly. > > > > > > I use version 3.3.7 on Linux (Fedora Core 5). > > > > > > What I do is to open a database, and start a

Re: [sqlite] sqlite3_close doesn't release always the file handle.

2006-09-23 Thread Joe Wilson
--- [EMAIL PROTECTED] wrote: > Ran <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > I *think* that sqlite3_close behave strangly. > > > > I use version 3.3.7 on Linux (Fedora Core 5). > > > > What I do is to open a database, and start a transaction in it. Then, > > without ending the transaction,

Re: [sqlite] Disconnected machine with database, SELECT still works !

2006-09-23 Thread Paolo Vernazza
Martin Alfredsson wrote: Hi ! Tried to solve a problem and what I did was to open the database over the net and then physically disconnect the machine. I can still SELECT ! sqlite3_prepare() works and gives SQLITE_OK sqlite3_step() gives SQLITE_ROW but is very, very slow sqlite3_finalize()

[sqlite] Disconnected machine with database, SELECT still works !

2006-09-23 Thread Martin Alfredsson
>How exactly are you accessing the database over the network? > By that you mean ? Two machines with Windows XP on a LAN. Using file sharing a place my app.exe on one machine and instructs it to use the file (database) on the other machine, sqlite3_open("\\LW75\SHARE\data.sq3", ) I start my

Re: [sqlite] sqlite3_close doesn't release always the file handle.

2006-09-23 Thread drh
Ran <[EMAIL PROTECTED]> wrote: > Hi all, > > I *think* that sqlite3_close behave strangly. > > I use version 3.3.7 on Linux (Fedora Core 5). > > What I do is to open a database, and start a transaction in it. Then, > without ending the transaction, open again the database and simply close it. >

Re: [sqlite] Disconnected machine with database, SELECT still works !

2006-09-23 Thread Trevor Talbot
On 9/23/06, Martin Alfredsson <[EMAIL PROTECTED]> wrote: Tried to solve a problem and what I did was to open the database over the net and then physically disconnect the machine. I can still SELECT ! sqlite3_prepare() works and gives SQLITE_OK sqlite3_step() gives SQLITE_ROW but is very, very

Re: [sqlite] sqlite3_close doesn't release always the file handle.

2006-09-23 Thread Ran
I filed the bug report as you suggested: #1990. Ran. On 9/23/06, Will Leshner <[EMAIL PROTECTED]> wrote: On 9/22/06, Ran <[EMAIL PROTECTED]> wrote: > What I do is to open a database, and start a transaction in it. Then, > without ending the transaction, open again the database and simply

[sqlite] Disconnected machine with database, SELECT still works !

2006-09-23 Thread Martin Alfredsson
Hi ! Tried to solve a problem and what I did was to open the database over the net and then physically disconnect the machine. I can still SELECT ! sqlite3_prepare() works and gives SQLITE_OK sqlite3_step() gives SQLITE_ROW but is very, very slow sqlite3_finalize() works. First when I do

Re: [sqlite] version 3.3.4

2006-09-23 Thread Nemanja Corlija
On 9/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hi all, Anyone knows where I could download the precompiled binary of version 3.3.4 from? Just go to http://www.sqlite.org/download.html and find a package that you need. Copy its link and replace current version number in it with the

[sqlite] Locking problems

2006-09-23 Thread Martin Alfredsson
>Usually, the SQLITE_LOCKED means that you tried to prepare or execute a >new SQL statement without resetting or finalizing a previous one on a >single connection. The statements should be prepared and executed this I'm NOT getting SQLITE_LOCKED. The error I get is SQLITE_BUSY (5). For some

[sqlite] Schema change hook API

2006-09-23 Thread 신기배
Hello, I'm SQLiteDBMS developer. SQLiteDBMS is minor F/OSS project for SQLite3 via TCP/IP network. http://sqlitedbms.sf.net SQLiteDBMS will support replication on next release. Normal SQL and prepared statement was captured by sqltie3_*_hook. But, "CREATE ...", "DROP ..." and "ALTER ..."