[sqlite] transaction in one thread and other thread also trying to write data

Hi all, My application is multithreaded. It maintains only connection per application. Database accessed by single process only. ThreadA will do database write operations(bulk) in a transaction. ThreadB will do single write operation without transaction but same connection pointer. Here, a

Re: [sqlite] sqlite suddenly thrown error

sqlite3_step( m_insert_stmt ); if(!reset_once) { reset_once = true; sqlite3_reset( m_insert_stmt ); } return r; } On Mon, Mar 31, 2014 at 3:52 PM, d b wrote: > >>You might have failed to call sqlite3

Re: [sqlite] sqlite suddenly thrown error

4 at 3:33 PM, d b wrote: > My application calls sqlite3_finalize() after insertion of 10,000 > record(loop). Is there any other reason? > > > On Mon, Mar 31, 2014 at 3:23 PM, d b wrote: > >> sqlite3_bind_text() returned 21 error. It is throwing for all insertions >>

Re: [sqlite] sqlite suddenly thrown error

My application calls sqlite3_finalize() after insertion of 10,000 record(loop). Is there any other reason? On Mon, Mar 31, 2014 at 3:23 PM, d b wrote: > sqlite3_bind_text() returned 21 error. It is throwing for all insertions > once error introduced. > > For ex: Here, Inserted firs

Re: [sqlite] sqlite suddenly thrown error

restart the application only. On Mon, Mar 31, 2014 at 2:23 PM, d b wrote: > Hi, > > I am getting sqlite error 21. > > > There is only one sqlite prepared statement for insertion. It's not > multi threaded app. The below function repeatedly calling for every record

[sqlite] sqlite suddenly thrown error

Hi, I am getting sqlite error 21. There is only one sqlite prepared statement for insertion. It's not multi threaded app. The below function repeatedly calling for every record insertion. This app was running from last 4 days. On third, it was started throwing error 21. What could be the re

[sqlite] check constraint

Hi, I would like to add check constraint for existing database. Is it possible? for ex: create table emp(id integer primary key autoincrement, fullname,fathername,mothername as text); insert into emp(fullname,fathername,mothername) values("a","b","c"); insert into emp(fullname,fathernam

[sqlite] crashed

Hi all, crashed at winShmBarrier from sqlite free/sqlite mutex leave/sqlite page apis. application using database extensively on windows that time. any idea? Thanks, d b ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

Re: [sqlite] sqlite error

I didn't set any timeout value. It was fine with delete/insert/update/select queries. Suddenly, started giving sqlite error with error code 1. On Tue, Jan 21, 2014 at 9:03 AM, d b wrote: > Hi all, > > sqlite throws error code 1 while sqlite busy with read/write operations. &

[sqlite] sqlite error

Hi all, sqlite throws error code 1 while sqlite busy with read/write operations. what could be the reason. But, I could not reproduce this with test program. what is the best way to handle sqlite error. Is it like sqlite abort case? Thanks, d b

Re: [sqlite] sqlite abort

Thank you. What is the default time? what is the ideal time for sqlite? On Fri, Jan 17, 2014 at 6:53 PM, d b wrote: > Hi all, > > When database busy with read/write operations, it's thrown sqlite abort > error while delete a record. > > what does it mean sqlite

[sqlite] sqlite abort

Hi all, When database busy with read/write operations, it's thrown sqlite abort error while delete a record. what does it mean sqlite abort(Callback routine requested an abort)? Shouldn't application delete when database busy with read/write operations? Thanks, a v

[sqlite] prepared statemnt for column names and sorting preference

Hi, select * from emp order by empid desc; //here empid is column name among clolumns. Now, I want to write prepared statement for above query. select * from emp order by ? ?; //I want to substitute column name and sorting preference. is it possible with sqlite? thanks, a _

Re: [sqlite] query optimization

Thanks alot RSmith. On Mon, Nov 18, 2013 at 6:04 PM, d b wrote: > Hi Igor/Keith, > > I tried with both queries. I expect to delete all rows belongs to key 1. > But not deleted. Am I missing something while writing queries? > > delete from emp where key = 1 and (name='&

Re: [sqlite] query optimization

ldata) values(3, 'd', 'yy'); insert into emp (key, name, personaldata) values(1, 'e', 'yyy'); ------ On Mon, Nov 18, 2013 at 5:20 PM, d b wrote: > Thanks RSmith. > > It works. > > But, I am looking

Re: [sqlite] query optimization

Thanks RSmith. It works. But, I am looking for single query for prepared statements. That's the actual struggle for me. On Mon, Nov 18, 2013 at 4:24 PM, d b wrote: > Hi RSmith, > > Thanks. Still, I could not delete with single query. > > > create table if not exi

Re: [sqlite] query optimization

27;yyy'); bool delete_emp(int key, string name = "") { string query = ???; if(name.length() > 0) { //needs to delete specific row. by unique key. } else { //needs to delete rows belongs to key } }

Re: [sqlite] query optimization

Hi Luis, Those are parameters. This is the query after replacing with ?1 and ?2. delete from emp where key = '123' and (case when name = 'abc' is null THEN 1 else name = 'abc' end); It covered "delete from emp where key = '123' and name = 'abc';" but not other query. I tried with "select (ca

[sqlite] query optimization

Hi, I am trying to make single query instead of below two queries. Can somebody help? 1. delete from emp where key = '123'; 2. delete from emp where key = '123' and name = 'abc'; if Key available, execute 1st query. if key and name available, execute 2nd query. Is it possible to write in

[sqlite] store image file as blob

Hi, My sqlite database module has to store images (max. 100 KB) on client machine. 1. store images on file system and have reference in database 2. store image as blob in database. Which is the best way to store these images? Any suggestions are welcome. Best Regards, va.