We only use .commit when we are using transactions: If any type of "BEGIN TRANSACTION;" is underway, a failure to "COMMIT;" data will guarantee that data will not be in a database. Interestingly however, even when not committed our queries will still work - our data will simply not be available in the next session if we do not .commit our changes.
FWIW: No matter our language-binding technology, I always advise folks to use a .close operation when provided for any type of statements, as well as connections. While we can often get away with not doing so, from a cross 'tech point of view - and from JDBC to those .NET bindings - using .close it is simply a good thing to get used to doing. On Mon, May 23, 2016 at 2:21 PM, Rajendra Shirhatti <rrshirha...@gmail.com> wrote: > Yes, I'm very positive the data is stored otherwise the application would > throw some exception. > The database is encrypted by calling passing a private key to the > connection using ChangePassword(). > > Thank you, Raj > > On Mon, May 23, 2016 at 9:16 AM, R.A. Nagy <r.a.n...@gmail.com> wrote: > > > Are we sure that data are being stored at-all? > > > > Also, how is the database being encrypted? > > > > > > On Sun, May 22, 2016 at 3:02 PM, Rajendra Shirhatti < > rrshirha...@gmail.com > > > > > wrote: > > > > > Hi Randall, > > > Thank you so much for your reply. > > > I don't have enough data to confirm whether database file is missing or > > > it's due to some other reason. > > > According to my initial investigation, it looks like the application is > > > able to create database and perform all the operations successfully > upon > > > service start. I'm leaning towards the possibility that the tables are > > > somehow getting deleted or the database file becomes inaccessible when > > the > > > service is RESTARTED. We open the database connection during service > > > startup and it stays alive as long as service is running. > > > Is there any scenario that could corrupt the database because the > > > connection was not closed successfully? > > > > > > Thank you once again. > > > > > > -Raj > > > > > > On Sun, May 22, 2016 at 4:54 AM, R.A. Nagy <r.a.n...@gmail.com> wrote: > > > > > > > Try: > > > > > > > > .schema [tablename] > > > > > > > > Since there is probably nothing there, you probably need to create a > > > table. > > > > > > > > If you are new to SQL / SQLite, then here are some helpful videos: > > > > > > > > > > https://www.youtube.com/playlist?list=PLItP5KoawLqkPV2jqAVCH79fZGO5k0Uzy > > > > > > > > > > > > Cheers, > > > > > > > > -Randall Nagy > > > > President, Soft9000.com > > > > > > > > > > > > > > > > > > > > On Sat, May 21, 2016 at 4:09 PM, Rajendra Shirhatti < > > > rrshirha...@gmail.com > > > > > > > > > wrote: > > > > > > > > > Hi, > > > > > We've a .Net Windows Service that uses SQLite 1.0.93.0 for database > > > > > operations. The SQLite package contains two binaries, > > > > > system.data.sqlite.dll and sqlite.interop.dll. > > > > > > > > > > The database is encrypted and the blob it contains is encrypted as > > > well. > > > > > SQLite is intermittently throwing following exceptions while > > retrieving > > > > > data from the database. > > > > > > > > > > > > > > > - *SQL logic error or missing database no such table*. > > > > > > > > > > The code is trying to execute a simple query which looks something > > > like > > > > > this: > > > > > SELECT x, y from [tablename] > > > > > > > > > > This exception is raised while executing > > SQLiteCommand.ExecuteReader(). > > > > The > > > > > stack trace points to > > > > > at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String > > > > strSql, > > > > > SQLiteStatement previous, UInt32 timeoutMS, String& strRemain) > > > > > at System.Data.SQLite.SQLiteCommand.BuildNextCommand() > > > > > at System.Data.SQLite.SQLiteDataReader.NextResult() > > > > > > > > > > > > > > > > > > > > * - Data Source cannot be empty. Use :memory: to open an in-memory > > > > > database- unable to open database file * > > > > > > > > > > These two exceptions are raised while trying to open the > connection. > > > > > > > > > > > > > > > Any help or guidance would be appreciated. > > > > > > > > > > Thank you, > > > > > Raj > > > > > _______________________________________________ > > > > > sqlite-users mailing list > > > > > sqlite-users@mailinglists.sqlite.org > > > > > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > > > _______________________________________________ > > > > sqlite-users mailing list > > > > sqlite-users@mailinglists.sqlite.org > > > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > > > _______________________________________________ > > > sqlite-users mailing list > > > sqlite-users@mailinglists.sqlite.org > > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
