Re: [sqlite] how let readonly connection wait for locked database ?

2011-08-12 Thread Wenbo Zhao
Simon, no, i don't think this can help. because my problem is busy handler was not triggered at the situation. Another reply is from Mr. Hipp ! I believe it must work, because he is the god here :-) thank you anyway. 2011/8/11 Simon Slavin slav...@bigfraud.org On 11 Aug 2011, at 3:35am, Wenbo

[sqlite] how let readonly connection wait for locked database ?

2011-08-10 Thread Wenbo Zhao
Hi guys, I want a readonly connection wait for locked database instead of error return immediately. The question is equivalence to how to let a reaonly connection have busy_handler triggered when the database is locked. In my practice, the readonly connection will fail when db locked and

Re: [sqlite] blocking when locking

2009-09-21 Thread Wenbo Zhao
with such a basic question. I'm still new in SQLite. Pavel On Sun, Sep 20, 2009 at 2:04 AM, Wenbo Zhao zha...@gmail.com wrote: I was talking about this example by 2009/9/19 Igor Tandetnik itandet...@mvps.org Imagine the classic example, where a transaction first verifies that the balance

Re: [sqlite] blocking when locking

2009-09-20 Thread Wenbo Zhao
for transaction that _made_ any reads, 'write lock' - for transaction that _made_ any writes. Pavel On Sat, Sep 19, 2009 at 12:18 AM, Wenbo Zhao zha...@gmail.com wrote: This is not a good example i think. If a transaction is intent to update after the select, it should start a write

Re: [sqlite] blocking when locking

2009-09-18 Thread Wenbo Zhao
This is not a good example i think. If a transaction is intent to update after the select, it should start a write lock before the select. And as described in previous 'dead lock' example, the update in this example could fail due to 'dead lock' I believe the 'read lock' is designed for a 'read

Re: [sqlite] make test was failed

2009-09-14 Thread Wenbo Zhao
i can't see the attachment why don't you use the sqlite-amalgamation*.zip ? that's very easy to compile 2009/9/14 TEZ sqli...@tezukuri.hobby-site.org make test became faild. What's wrong? I tried with sqlite-3.6.17.tar.gz and sqlite-3.6.18.tar.gz, but both packages failed by running make

Re: [sqlite] looking for a solution of Object/Relation Mapping with sqlite

2009-09-11 Thread Wenbo Zhao
with 25 left outer joins. If your objects and queries are simple, there's no harm in coding the database access by hand. - Original Message - From: Wenbo Zhao zha...@gmail.com To: sqlite-users@sqlite.org Sent: Thursday, September 10, 2009 8:12 PM Subject: [sqlite] looking

[sqlite] looking for a solution of Object/Relation Mapping with sqlite

2009-09-10 Thread Wenbo Zhao
Hi, all I have been looking for a simple and practical solution of Object/Relation Mapping over JDBC to use with sqlite. I think this should be a common problem for all users who write app with sqlite in java. On the net, it seems everybody is talking about Hibernate in this field. I'm new in