[sqlite] Sqlite3 Data Base write failure cases.

Hi Team, What are the possible failure cases of DB write in case of single connection. Because in my application i needs to handle those cases. Can anyone help me for the same. Thank you ___ sqlite-users mailing list

[sqlite] SQLITE_OPEN_FULLMUTEX

Hi Members, I enabled the SQLITE_OPEN_FULLMUTEX in that case if one thread is trying to write in to the DB and other thread is trying to read from the DB (Same connection). In that case will it cause any SQLITE_LOCKED error. In some of the forum i found that if we enable the

Re: [sqlite] [EXTERNAL] SQLITE_OPEN_FULLMUTEX

gt; > -Ursprüngliche Nachricht- > Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > Im Auftrag von Prajeesh Prakash > Gesendet: Mittwoch, 28. November 2018 08:33 > An: SQLite mailing list > Betreff: [EXTERNAL] [sqlite] SQLI

Re: [sqlite] [EXTERNAL] SQLITE_OPEN_FULLMUTEX

Yes they are sharing the same DB connection > On November 28, 2018 at 1:57 PM Simon Slavin wrote: > > > On 28 Nov 2018, at 8:03am, Prajeesh Prakash > wrote: > > > That means (with SQLITE_OPEN_FULLMUTEX) if two threads are trying to do > > write and read

[sqlite] How to Save NULL data to DB

Hi Team, How to save NULL parameter into the DB. I saw something like (null) on table but when i am reading from the table it popup as a string not the NULL value. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] [EXTERNAL] Number of changes

ed. To get the number of changes made by the *last > statement*, use sqlite3_changes(). This applies only to connections that are > not shared between threads. > > -Ursprüngliche Nachricht- > Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org

[sqlite] Number of changes

Hi team, How we can find the number of changes done on a particular table in DB using sqlite3 library function (C program). I tried with sqlite3_total_changes() but its doesn't helps me. I am writing only one record but its giving me 22 records. At present my db contains 23 table and i tried

Re: [sqlite] [EXTERNAL] sqlite3_exec()

aders, who > will still see the state of the DB at the time their transaction started. > > > > Von: Prajeesh Prakash [mailto:prajeeshprakash@elear.solutions] > Gesendet: Montag, 03. Dezember 2018 08:39 > An: SQLite mailing list ; Hick > Gunter > Betreff

Re: [sqlite] SQLITE_LOCKED and SQLITE_BUSY

Hi Team, I am writing to a table 1 and reading from table 2 both operation are from different DB connection i am getting SQLITE_LOCKED and when i try to read and write the same table from different connection i am getting same error. (I know read and write are the incompatible at same time).

[sqlite] Getting SQLITE_LOCKED

Hi Team, I am writing to a table 1 and reading from table 2 both operation are from different DB connection i am getting SQLITE_LOCKED and when i try to read and write the same table from different connection i am getting same error. (I know read and write are the incompatible at same time).

Re: [sqlite] [EXTERNAL] Getting SQLITE_LOCKED

Hi Team, Actually this is the case. From my main application i created two thread (One thread is for read from table 1 on the DB and another thread is for write into a separate table (Say table 2) on the DB). Similary i created two separate connection to DB (For these two thread to

Re: [sqlite] Getting SQLITE_LOCKED

Sorry i was a wrong attempt. > > On November 29, 2018 at 5:07 PM Prajeesh Prakash > wrote: > > Hi Team, > > I am writing to a table 1 and reading from table 2 both operation are > from different DB connection i am getting SQLITE_LOCKED > > an

[sqlite] sqlite3_exec()

Hi Team, Is this sqlite3_exec() function is a blocking call in the case of writing.I have two thread one is for reading and other is for writing the DB. Both thread have the same DB connection(Of course i am in FULLMUTEX mode and sqlite point of few there is no multiple thread every thing is

[sqlite] sqlite3_column_text() and sqlite3_column_int()

Hi, When i am trying to fetch the table data using sqlite3_column_text() i am getting wrong column entry even if i gave the correct column number as the second argument. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] sqlite3_exec()

Dear Members, I have one doubt, Is that sqlite3_exec function is working under the main application thread (Thread which calls the sqlite3_exec) or in a separate thread (If i am trying to INSERT the data in to DB without registering the Async writer). Thank you Prajeesh

Re: [sqlite] sqlite3_exec()

In that case if i am not registering the async writer then also my db will get updated (If i am writing to DB) am i correct? > > On November 27, 2018 at 8:29 PM Simon Slavin wrote: > > On 27 Nov 2018, at 2:43pm, Prajeesh Prakash > wrote: > > > &

Re: [sqlite] sqlite3_exec()

As per the asyncwriter code, that thread is not giving any BD update success or failure status so is there any way to get the status from the Asyncwriter thread because my application needs to know the status of the DB changes. > On November 27, 2018 at 10:31 PM Keith Medcalf wrote: > > > >

Re: [sqlite] sqlite3 Asynchronous I/O

Yes it is. > > On November 27, 2018 at 3:12 PM Shawn Wagner > wrote:es > > By asynchronous i/o, do you mean the vfs module described here: > https://www.sqlite.org/asyncvfs.html ? > > On Tue, Nov 27, 2018, 1:24 AM Prajeesh Prakash > >

[sqlite] sqlite3 Asynchronous I/O

Hi Members, I am using sqlite3 Asynchronous I/O on my application. So is there any way to get the status of the DB update (After the write operation) from the asyncWriterThread so that my application can do the proper error handling. I am expecting a reply. Thank you Prajeesh P

Re: [sqlite] sqlite3 Asynchronous I/O

gt; wrote: > > By asynchronous i/o, do you mean the vfs module described here: > https://www.sqlite.org/asyncvfs.html ? > > On Tue, Nov 27, 2018, 1:24 AM Prajeesh Prakash > > > > > > Hi Members, > > > > I am using sqlite3 As

[sqlite] SQLITE_LOCKED and SQLITE_BUSY

Hi members, The SQLITE_LOCKED error will happen on same database connection when two thread trying to do read/write operation at same time. SQLITE_BUSY will get when one thread on one connection is doing read/write operation and another thread on another connection trying to read/write the DB.

Re: [sqlite] SQLITE_OPEN_FULLMUTEX vs SQLITE_OPEN_NOMUTEX

described above. In > both cases neither operation will be isolated in any way from the other (that > requires using separate connections). > > --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says a > lot about anticipated traffic volume. > &g

Re: [sqlite] SQLITE_OPEN_FULLMUTEX vs SQLITE_OPEN_NOMUTEX

--- > The fact that there's a Highway to Hell but only a Stairway to Heaven > says a lot about anticipated traffic volume. > > > > > > -Original Message- > > From: sqlite-users [mailto:sqlite-users- > > boun...@mailin

[sqlite] SQLITE_OPEN_FULLMUTEX vs SQLITE_OPEN_NOMUTEX

Hi Members, Can any one please give a clear idea about SQLITE_OPEN_FULLMUTEX and SQLITE_OPEN_NOMUTEX because i am totally confused with the concept. If we enable FULLMUTEX what will happen if two thread trying to update the same table (Both thread are from same DB connection) in case of

Re: [sqlite] [EXTERNAL] sqlite3_exec()

w" > records. > > -Ursprüngliche Nachricht- > Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > Im Auftrag von Prajeesh Prakash > Gesendet: Samstag, 01. Dezember 2018 14:51 > An: SQLite mailing list > Betreff: [EXTERNAL

Re: [sqlite] Sqlite3 Data Base write failure cases.

and do the write operation one by one). Thank You > On December 17, 2018 at 3:16 PM Simon Slavin wrote: > > > On 17 Dec 2018, at 9:01am, Prajeesh Prakash > wrote: > > > What are the possible failure cases of DB write in case of single > > connection. Because in my