File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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 and Relational Databases
Bookmark "SQLite3 "Database disk image is malformed"" Watch "SQLite3 "Database disk image is malformed"" New topic

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?


Madhan Sundararajan Devaki
Ranch Hand

Joined: Mar 18, 2011
Posts: 312

Taking scheduled backups can prevent such accidents.

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.
I agree. Here's the link:
subject: SQLite3 "Database disk image is malformed"
It's not a secret anymore!