Thank you, I thought I had checked everything, but strace helped me realize what was going on. The file was being deleted by other code. Windows won't let you delete a file that is in-use/locked, but Linux does.
I'm glad I had this issue though or I may not have tried the native code, its MUCH faster. On Nov 1, 12:27 pm, Joe Wilson <[EMAIL PROTECTED]> wrote: > 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 > aroundhttp://mail.yahoo.com- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
