I think the answer to this is "no" based on http://www.sqlite.org/faq.html#q6 But a confirmation or other solution would be nice... I have a shared library being called by a transaction-oriented Java system. I'm doing periodic commits (every 5 seconds) to speed up processing. However, I want to commit even when not polled by the Java system. There could be long periods of silence and all the data needs to be accessible by others. I thought of spawning a thread which would do the commits....but it would appear that's not possible (or at least a really bad idea). Since there is currently no continuous execution path it would seem I'm stuck. Would have to have the Java system do a heartbeat or such to ensure the commit gets done. Is this the correct interpretation of the the thread-safe ability of SQLite? Michael D. Black Senior Scientist Advanced Analytics Directorate Northrop Grumman Information Systems
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
