Run 'strace' on your linux process to see whether unlink is called on the file in question.
Because inserts runs after the file is apparently deleted suggests that another process or perhaps another method within your program is removing the file. --- Dan <[EMAIL PROTECTED]> wrote: > > What would cause the SQLite JDBC to delete the db file on Linux? > I've tried it both with Pure Java, and with a native ( I compiled a > native .so). > > My application works fine on Windows, but when I run it on Linux, I > see the file get created, but then after I finish setting up the > tables and initial data values, the file disappears. Although the > file disappears, my inserts continue to run without throwing > exception. > > The order of events relative to the DB: > > execute several CREATE TABLEs as one batch job on Statement object > execute several PreparedStatements > execute several INSERTs as one batch on Statement object > << file gets deleted somewhere in here>> > do nothing for 15 seconds, then every 15 seconds > execute several Inserts on a different thread. > > I NEVER call close() on the connection, I do close all statements. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
