Re: [sqlite] accessing a sqlite db with multiple java processes.
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.
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