We have an application that attaches 2 java threads that establish their
own connection to SQLite databases. While one is running (loading a
table), the other thread attempts an ATTACH DATABASE command and
receives a "cannot ATTACH database within transactions". A transaction
has been started in the first thread and not the second. Based on what
I can see in the SQLite FAQ, there is no caveats to multi-threaded
applications, so I don't understand why this would occur. Any help on
understanding what we should be doing differently is appreciated. We
MUST use transactions to load the database, so disabling this is not an
option.
Thanks,
Chris
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
