Re: [sqlite] Bug: Database connection closed on different thread

patters <[EMAIL PROTECTED]> wrote: > Greetings, > > We ran into a bug that's not documented behavior: closing a connection that > was created in a different thread (where thread A calls sqlite3_open[16], > "hands off" the connection to thread B, and thread B calls sqlite3_close). > > The

[sqlite] Bug: Database connection closed on different thread

Greetings, We ran into a bug that's not documented behavior: closing a connection that was created in a different thread (where thread A calls sqlite3_open[16], "hands off" the connection to thread B, and thread B calls sqlite3_close). The documentation (http://www.sqlite.org/faq.html#q6) says

Re: [sqlite] SQL command support question

Those commands are specific to the sqlite3 command line tool program. Run sqlite3 from a command line to get them. José Antonio Gonçalves Motta wrote: I'm accessing SQLite through a JDBC driver in a java program, but I get an error everytime I use SQLite line command (like ".output"). Is it

[sqlite] Re: SQL command support question

José Antonio Gonçalves Motta <[EMAIL PROTECTED]> wrote: I'm accessing SQLite through a JDBC driver in a java program, but I get an error everytime I use SQLite line command (like ".output"). You are confusing SQLite database engine with sqlite3 command line utility. Commands like .output are

RE: [sqlite] SQL command support question

Regarding: I'm accessing SQLite through a JDBC driver in a java program, but I get an error everytime I use SQLite line command (like ".output"). Is it because the driver doesn't understand those commands?" Commands such as ".output" are not part of sqlite proper. They are part of the

Re: [sqlite] getting a segfault on FreeBSD 6.2R with sqlite 3.4.1

Could you recompile everything with -g to enable debugging with line numbers in the backtrace? If FreeBSD has valgrind, running the program through that would be useful as well. --- "Chad Leigh -- Shire.Net LLC" <[EMAIL PROTECTED]> wrote: > Running it in gdb shows > > Program received signal

RE: [sqlite] PRAGMA synchronous=0; and crash recovery

I think everyone has this requirement, I was finding many slowness problems using synchronous = on, and I started tweaking the app with memory tables, I recommend you look into it, you can create a memory Database by specifying :memory: as the filename. The connection you receive from this you