Re: [sqlite] Accessing Sqlite from Java

2004-05-27 Thread Jalil Vaidya
Check the Java section at http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers --- "Rao, Prasanna [EPM/RTC]" <[EMAIL PROTECTED]> wrote: > Hi, > Is there any driver or sample to look at for > accessing sqlite > database from java app. > > Thanks > Prasanna Rao = 01001010 0111 01101

Re: [sqlite] delete record fail when disk full

2004-05-27 Thread Darren Duncan
At 9:06 PM +0800 5/27/04, Kei wrote: Hi all, Thank you. Does the size of the second rollback file depend on the size of database file or another issue? If the size of database file is 2MB, will the rollabck file also consume 2MB? Best regards, Kei The size of the rollback file is equivalent to the

Re: [sqlite] delete record fail when disk full

2004-05-27 Thread Christian Smith
On Thu, 27 May 2004, Kei wrote: >Hi all, > >Thank you. Does the size of the second rollback file depend on the size of >database file or another issue? >If the size of database file is 2MB, will the rollabck file also consume >2MB? No, pages are appended to the rollback file as and when they ar

Re: [sqlite] Triggers and performances

2004-05-27 Thread Christian Smith
On Wed, 26 May 2004, Pix wrote: >Hi, >I'm using triggers to perform some operations on my SQLite DB. >Particularly I'm using them to easily maintain DB coerency (e.g. if I >delete an item from a table, the trigger will delete all rows from >another table that are referencig to that item). > >My qu

[sqlite] Accessing Sqlite from Java

2004-05-27 Thread Rao, Prasanna [EPM/RTC]
Hi, Is there any driver or sample to look at for accessing sqlite database from java app. Thanks Prasanna Rao - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] equal to expression returning incorrect results

2004-05-27 Thread Dennis Cote
> - Original Message - > From: "Kurt Welgehausen" <[EMAIL PROTECTED]> > > No one can really evaluate this without knowing your view > > definition. > > Here you are. I'm still not sure that it is relavent though. > > CREATE VIEW Device_Property_List AS > SELECT > D.device_id AS

Re: [sqlite] delete record fail when disk full

2004-05-27 Thread Kei
Hi all, Thank you. Does the size of the second rollback file depend on the size of database file or another issue? If the size of database file is 2MB, will the rollabck file also consume 2MB? Best regards, Kei - Original Message - From: "Darren Duncan" <[EMAIL PROTECTED]> To: <[EMAIL