Re: [sqlite] Re: SQLite and Java

Thanks David, I downloaded the JDBC driver written by you after going thru the archives of mailing lists Regards, Umesh On 8/10/06, David Crawshaw <[EMAIL PROTECTED]> wrote: Umesh Nayak <[EMAIL PROTECTED]> wrote: > Does SQLite work with Java? Yes. I have written a JDBC driver for SQLite 3:

[sqlite] SQLite BCB3

I've found the answer to my earlier post. In order to use SQLite with BCB3 Pro windows application you must 1) Uncheck "Use Dynamic RTL" 2) Uncheck "Build with run time Packages" -- Forwarded message -- From: JJ Thymes <[EMAIL PROTECTED]> Date: Aug 9, 2006 11:30 AM Subject:

[sqlite] More on triggers

Hi, I just want to confirm one more thing, If two tasks create two seperate triggers each of its own, on the same condition each not caring whether already a trigger exists, and both of them had opened a session, now if the trigger is fired which one will be notified? 1)

[sqlite] Disable custom collate

Hi, I created a table with a field and index that uses a custom collation function MYCOLLATE. The problem I am having is portability, I cannot perform simple selects on the table on other sqlite based applications since the custom collation function is not available. Does anybody out ther

Re: [sqlite] concurent writes and locks

Why not make your application simple and use a mutex to synchronize your threads and serialize the database access? [EMAIL PROTECTED] wrote: I have two threads heavily writing to the db. Hence, I get some SQLITE_BUSY return values. If I get it from sqlite3_step(), I wait a few ms and call

Re: [sqlite] Disable custom collate

On 8/10/06, JP <[EMAIL PROTECTED]> wrote: I created a table with a field and index that uses a custom collation function MYCOLLATE. The problem I am having is portability, I cannot perform simple selects on the table on other sqlite based applications since the custom collation function is not

[sqlite] java applet access to sqlite on an arm architecture?

Hello, I was wondering if it is possible for a java applet to access sqlite2.8 databases that is installed on an arm architecture. Currently the arm system has apache, php and sqlite installed. The applet will run on windows/linux machine via a browser, but the applet file will be accessed

[sqlite] Re: More on triggers

chetana bhargav wrote: If two tasks create two seperate triggers each of its own, on the same condition each not caring whether already a trigger exists, and both of them had opened a session, now if the trigger is fired which one will be notified? First, triggers are parts of the database,

Re: [sqlite] concurent writes and locks

John Stanton wrote: Why not make your application simple and use a mutex to synchronize your threads and serialize the database access? Well, I figure, if the db has an advanced locking/synchronization mechanism (that even makes a distinction between reads and writes), using that will

Re: [sqlite] Re: concurent writes and locks

Igor Tandetnik wrote: eric-5PSWdYX/[EMAIL PROTECTED] wrote: I have two threads heavily writing to the db. Hence, I get some SQLITE_BUSY return values. If I get it from sqlite3_step(), I wait a few ms and call sqlite3_step() again etc. This happens in one thread, thread A. The other thread

Re: [sqlite] concurent writes and locks

On 8/10/06, Eric van der Maarel <[EMAIL PROTECTED]> wrote: John Stanton wrote: > Why not make your application simple and use a mutex to synchronize your > threads and serialize the database access? Well, I figure, if the db has an advanced locking/synchronization mechanism (that even makes a

[sqlite] Attach db code

Hi All, Can someone give me the code you use to attach a database. I have a db file with 5 Million records and have three different tables. Index is also created in it. I want to load it in memory to apply some queries for testing. Best regards, Manzoor Ilahi Tamimy

Re: [sqlite] Attach db code

First, connect to your db file. As this is the first connection this will be referred as 'main'. Then you need to attach a memory database. ATTACH DATABASE ":memory:" AS mem; Create your table definitions in memory, por example: CREATE TABLE mem.table1 (... You can get some info from: SELECT

RE: [sqlite] Second Btree Transaction stuck at commit

Hi Richard, I found out I did not solve the problem yesterday because the btree commit got stuck again. After some debugging, I saw the dirty list in the pager became circular and caused infinite loop... (maybe due to my misuse?) So I put in an extra check into the function makeDirty(PgHder