Re: [sqlite] The database disk image is malformed

2012-12-13 Thread Simon Slavin
On 13 Dec 2012, at 8:56pm, Jeff Archer wrote: > I have found that this can be repaired by SQLiteExpertPro by the > Database | Repair functionality Worth noting that there's a difference between restoring the database to a condition where it no longer gives

Re: [sqlite] The database disk image is malformed

2012-12-13 Thread Richard Hipp
On Thu, Dec 13, 2012 at 3:56 PM, Jeff Archer < jsarc...@nanotronicsimaging.com> wrote: > I have encountered an error of the database disk image is malformed. > Database was send in by a customer so I'm not exactly sure how it came to > be this. I have found that this can be repaired by

[sqlite] The database disk image is malformed

2012-12-13 Thread Jeff Archer
I have encountered an error of the database disk image is malformed. Database was send in by a customer so I'm not exactly sure how it came to be this. I have found that this can be repaired by SQLiteExpertPro by the Database | Repair functionality but have not been able yet to find anything in

Re: [sqlite] How to verify referential integrity of SQLite database

2012-12-13 Thread gwenn
Hello, You can give the following tool a try if you want: https://github.com/gwenn/checkfkey But I'm not sure that it correctly handles composite. Regards. On Thu, Dec 13, 2012 at 4:22 PM, Jean-Christophe Deschamps wrote: > >> Jay A. Kreibich wrote: >> > I can also see

Re: [sqlite] JDBC Drivers for SQLite?

2012-12-13 Thread Tilsley, Jerry M.
I will sure and report back, I appreciate the response and assistance! -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of LMHmedchem Sent: Wednesday, December 12, 2012 12:33 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite]

Re: [sqlite] How to verify referential integrity of SQLite database

2012-12-13 Thread Jean-Christophe Deschamps
Jay A. Kreibich wrote: > I can also see situations when someone might want to run one > set or the other set of checks. Breaking it out, so that these > checks are done by a different PRAGMA (integrity_check_v2 ?) seems > like a wise idea. Indeed; with a separate PRAGMA

Re: [sqlite] malloc failures on ubuntu

2012-12-13 Thread Richard Hipp
On Wed, Dec 12, 2012 at 11:41 PM, bkk wrote: > Really appritiate if any one can help me on this, I didnot get a solution > for > this > > Apparently, nobody else can reproduce your problem. All of our tests are working fine. > > Thanks > Brijesh > > > > -- > View this

Re: [sqlite] malloc failures on ubuntu

2012-12-13 Thread bkk
Really appritiate if any one can help me on this, I didnot get a solution for this Thanks Brijesh -- View this message in context: http://sqlite.1065341.n5.nabble.com/malloc-failures-on-ubuntu-tp65936p66126.html Sent from the SQLite mailing list archive at Nabble.com.

Re: [sqlite] JDBC Drivers for SQLite?

2012-12-13 Thread LMHmedchem
I have sqlite-jdbc-3.7.2.jar that I use as the sqlite driver for squirrel-sql. It is 3.1MB, so I don't think I can send it as an email attachment. You may want to search for that file name. If you can't find it, let me know and I will put is somewhere on the net for you. LMH Tilsley, Jerry

Re: [sqlite] How to verify referential integrity of SQLite database

2012-12-13 Thread Clemens Ladisch
Jay A. Kreibich wrote: > I can also see situations when someone might want to run one > set or the other set of checks. Breaking it out, so that these > checks are done by a different PRAGMA (integrity_check_v2 ?) seems > like a wise idea. Indeed; with a separate PRAGMA

Re: [sqlite] How to verify referential integrity of SQLite database

2012-12-13 Thread Dominique Devienne
On Wed, Dec 12, 2012 at 10:01 PM, Jos Groot Lipman wrote: > When you enable foreign keys *after* you insert records, no guarantee is > given by SQLite that the foreign key constraints are fulfilled. This may not > be what most users would want or expect but it certainly not a