Re: [sqlite] accessing a sqlite db with multiple java processes.

2009-05-27 Thread Laurent Burgy
my bad...
but i don't know how to block the writing to the database to wait until the
release of the lock... It seems to me that when the writing is impossible
because there's a lock, the driver raises the exception...
Maybe the good thing to do would be to wait for a regular FileLock to be
released and then write...


On Wed, May 27, 2009 at 10:19 AM, Martin.Engelschalk <
engelsch...@codeswift.com> wrote:

> http://www.sqlite.org/faq.html#q5




-- 
Laurent
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] accessing a sqlite db with multiple java processes.

2009-05-27 Thread Martin.Engelschalk
Hi,

i imagine that your problem has nothing to do with your driver.
Have you looked at http://www.sqlite.org/faq.html#q5 ?

Martin

Laurent Burgy schrieb:
> Hi,
> I was using sqlite with only one java process (using the sqlitejdbc driver)
> and everything was ok... now i'm trying to run several instances of the same
> program on the same db...and i've a bunch of "database is locked"
> exceptions.
>
> i was wandering if it was possible to access the same db with several jobs
> ?
>
> If so (and maybe this is not the right place to ask), what are the best
> practices using sqlitejdbc ? (or any other jdbc driver)...
>
>
> thanks
>
>   
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users