I know that this issue has nothing to do with direct Java coding, but i am taking a shot in the dark here and hope that someone will know what I can do.
For my java program, I am using an sqlite3 database to store my information. During the past 2 months or so, it has performed magically. I just inserted an update command; "
sqlite> update virtual_accounts set description = 'Lunch Funds', balance = '200', note = 'success' where unid = 'v-101';"
This command was completed succesfully. Now, every time I try to select documents from a differant table
"Select * from transact;"
i get a "database disk image is malformed". the only changes made to that table have been made through my java database controller methods, the same that I have used for the past months without an issue. Does anyone know what happened and how I can prevent such a major headache later on, esp when I the program is not in development and in the hands of an end-user?
Taking scheduled backups can just prevent major data loss when the issue sufaces, but has nothing to do with preventing this from happening again. My main issue is that I have no idea how this happened and it makes me question the qualitly of sqlite.
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads