--- ArtemGr <[EMAIL PROTECTED]> wrote:
> On Jul 12, 2:54 pm, ArtemGr <[EMAIL PROTECTED]> wrote:
> > Does SQLite uses Shared Cache?http://www.sqlite.org/sharedcache.html
>
> Wow. Recent modification to SQLite address this problem!
> http://sqlite.org/34to35.html
>
> Can we expect, that SQLite JDBC driver would have an option to enable
> these? Pleeease. : ))
For the native sqlitejdbc driver, it should be straightforward to support
shared cache by calling sqlite3_enable_shared_cache(1) and recompiling
sqlitejdbc with a threadsafe version of sqlite 3.5. (As an added bonus, a
-DTHREADSAFE=1 compiled sqlite 3.5 would probably eliminate all the spurious
crashes seen in the native version of the sqlitejdbc driver related to
prepared statement finalization in different threads.)
But because NestedVM does not support pthreads, using the shared cache
with the current design of nested sqlitejdbc is not possible. The code
would have to be restructured to force all sqlite database connections
to the same database to be done on the same thread. Examples of this
asynchronous style of programming can be seen in a test program in the
sqlite source tree.
____________________________________________________________________________________
Pinpoint customers who are looking for what you sell.
http://searchmarketing.yahoo.com/
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---
