Re: [sqlite] Tomcat crashes with SQLite

If you did not compile sqlite as multi-threaded this is exactly what would happen. On Jun 22, 2007, at 9:06 PM, Frederic de la Goublaye wrote: Hi I just tried this driver: http://www.zentus.com/sqlitejdbc/ The result is ten times slower or even more. Maybe I am wrong using this new

Re: [sqlite] Tomcat crashes with SQLite

Hi I just tried this driver: http://www.zentus.com/sqlitejdbc/ The result is ten times slower or even more. Maybe I am wrong using this new driver. So for the moment I am still using this one: http://www.ch-werner.de/javasqlite/ BUT I HAVE STILL THE CRASH TROUBLES: An unexpected exception has

[sqlite] Worked perfectly!

-- #/bin/sh ROW_ID=`sqlite3 test.db

Re: [sqlite] What about with LAST_INSERT_ROWID() ?

[In the message "[sqlite] What about with LAST_INSERT_ROWID() ?" on Jun 22, 15:09, litenoob writes:] > > Hmm.. don't know sed or awk, but I suppose this weekend would be a good time > to learn! > > Alright, going along with this, is there a better way to get the last row id > inserted? This is

[sqlite] What about with LAST_INSERT_ROWID() ?

Hmm.. don't know sed or awk, but I suppose this weekend would be a good time to learn! Alright, going along with this, is there a better way to get the last row id inserted? This is my (completely inefficient) workaround: - - - - - sqlite3 $dbfilename << EOF INSERT INTO tablename (col1,

Re: [sqlite] Re: How to sort not binary?

On 22.06.2007 17:48 CE(S)T, Yves Goergen wrote: > Match m1 = Regex.Match(param1, "^([0-9]+)"); > if (m1.Success) > { > Match m2 = Regex.Match(param2, "^([0-9]+)"); > if (m2.Success) > { > int cmpNum = int.Parse(m1.Groups[1].Value) - >

Re: [sqlite] Capturing output from SQLlite with variables in a BASH script

- Original Message From: Martin Jenkins <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Friday, June 22, 2007 2:00:45 PM Subject: Re: [sqlite] Capturing output from SQLlite with variables in a BASH script litenoob wrote: > Hi, I'm wondering how to write a BASH script that will

Re: [sqlite] Capturing output from SQLlite with variables in a BASH script

litenoob wrote: Hi, I'm wondering how to write a BASH script that will capture my SQLite output. I can do it for a single line with something like this: somevar=`sqlite3 dbfilename "SELECT name FROM tablename WHERE name='smith' LIMIT 1;"` However, if I want to do anything with multiple lines,

Re: [sqlite] Capturing output from SQLlite with variables in a BASH script

[In the message "[sqlite] Capturing output from SQLlite with variables in a BASH script" on Jun 22, 13:02, litenoob writes:] > > Hi, I'm wondering how to write a BASH script that will capture my SQLite > output. > > I can do it for a single line with something like this: > > somevar=`sqlite3

Re: [sqlite] blob data streaming

On 4/10/07, Teg <[EMAIL PROTECTED]> wrote: Hello Andrew, Tuesday, April 10, 2007, 3:25:29 PM, you wrote: AF> Using sqlite3 (3.3.15 or later), is there a method to retrieve portions of a AF> blob rather than the whole thing? AF> If not, would others find it useful and handy? Store the file

[sqlite] Capturing output from SQLlite with variables in a BASH script

Hi, I'm wondering how to write a BASH script that will capture my SQLite output. I can do it for a single line with something like this: somevar=`sqlite3 dbfilename "SELECT name FROM tablename WHERE name='smith' LIMIT 1;"` However, if I want to do anything with multiple lines, I haven't

[sqlite] Unicode collation

Hello, I wonder whether there are any plans to include internally proper Unicode comparisons? Don't get me wrong, I think that it's great that SQLite supports custom collations, there's absolutely no problem to handle it in internally for my database, but problem is that if I define UNICODE

Re: [sqlite] Re: How to sort not binary?

On 12.05.2007 22:57 CE(S)T, Ingo Koch wrote: > Yves Goergen wrote: > >> I guess that doesn't work when I'm accessing the database through the >> System.Data.SQLite interface in .NET? > > Fortunately your guess is wrong. ;-) System.Data.SQLite supports > user defined collation sequences. See

[sqlite] Pragma busy

Hi all, The following errors are generated in a multi threaded program where each thread has its own independent Connection to sqlite. The command sql=[PRAGMA synchronous=FULL] Results in a rc=[5] and errorr msg=[database is locked] How can this can be avoided? I've tried

Re: [sqlite] Cache invalidation after insert statements.

At 11:20 22/06/2007, you wrote: HI all. Thanks for everyones help the problem is now solved. The memory drive worked like a bomb. Basically the problem on that server was that the insanely high IO prevented the OS from caching the file which slowed down the performance. After installing a mem

RE: [sqlite] Trigger on Attached Database

Try to create a TEMPorary trigger after the ATTACH command. Regards Marc >Is it possible to do this: > > Open DB1 > > Attatch DB2 > > >In DB1 have a trigger that does > > Insert into DB2. ? > >Theoretically it seems possible but we couldn't get it to work. Before I >investigate further just

Re: [sqlite] Cache invalidation after insert statements.

HI all. Thanks for everyones help the problem is now solved. The memory drive worked like a bomb. Basically the problem on that server was that the insanely high IO prevented the OS from caching the file which slowed down the performance. After installing a mem drive ( using mfs ) and reducing

Re: [sqlite] Recommend server for Windows?

Hi Gilles, On 6/20/07, Gilles Ganault <[EMAIL PROTECTED]> wrote: At 16:49 19/06/2007 -0700, Medi Montaseri wrote: The context is that, until now, our apps were almost used on stand-alone hosts with only a few customers hosting the (small) SQLite database file on a shared drive on the LAN, so