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 donts...@home.nl 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 corrupt

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 fk_integrity_check,

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] 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] malloc failures on ubuntu

2012-12-13 Thread Richard Hipp
On Wed, Dec 12, 2012 at 11:41 PM, bkk brijeshk_...@yahoo.com 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 message in

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] 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 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 j...@antichoc.net wrote: Jay A. Kreibich wrote: I can also see situations

[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] 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

Re: [sqlite] The database disk image is malformed

2012-12-13 Thread Simon Slavin
On 13 Dec 2012, at 8:56pm, Jeff Archer jsarc...@nanotronicsimaging.com 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