(Top-posting and overquoting fixed.) On Monday, January 21, 2008 1:57 PM, Mark Riehl wrote: > > On Jan 21, 2008 4:48 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > > Mark Riehl <[EMAIL PROTECTED]> wrote: > > > For some reason I haven't been able to track down, SQLite is creating > > > a journal file after the C++ process connects, however, the journal > > > file doesn't go away. > > > > Are you, by any chance, opening a transaction and keeping it open? > > > > Igor Tandetnik > > I'm just executing SQL insert statements. I'm not using the BEGIN > TRANSACTION; ... END TRANSACTION; wrappers around the inserts. > > I thought that there was an implied BEGIN ...COMMIT around every > INSERT statement?
There is. And if your code has no active transactions, SQLite allows other processes to access the database. So something odd is happening, but I don't think you've shared enough information for this list to guess what. -- James ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
