aspose file tools*
The moose likes JDBC and the fly likes SQLite3 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "SQLite3 "Database disk image is malformed"" Watch "SQLite3 "Database disk image is malformed"" New topic
Author

SQLite3 "Database disk image is malformed"

Greg Reeder
Ranch Hand

Joined: Jun 14, 2011
Posts: 99

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?

Thanks

Greg
Madhan Sundararajan Devaki
Ranch Hand

Joined: Mar 18, 2011
Posts: 312

Taking scheduled backups can prevent such accidents.


S.D. MADHAN
Not many get the right opportunity !
Greg Reeder
Ranch Hand

Joined: Jun 14, 2011
Posts: 99

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.
 
 
subject: SQLite3 "Database disk image is malformed"