--- [EMAIL PROTECTED] wrote:
> I have tested the Nested JDBC driver in Linux ((K)Ubuntu 7.04) and the
> same problem exists there aswell. I also tried your versions of the
> sqlite3 and both, the JIT mode and interpreted mode versions had the
> same issue aswell.
Thanks for the test case. It seems to be a new problem in NestedVM,
and not the Nested JDBC driver. I'll take a look at it when I have
time.
If you pipe the output of this perl script containing a reduced test
case to a NestedVM-compiled sqlite3 commandline shell you can reproduce
the problem - but only if you're using a file-based database.
If you're using a :memory: database, then this problem will not occur.
This suggests that the problem is in a NestedVM I/O system call, as
a natively compiled version of sqlite3 works correctly with the same SQL.
#!perl
my $data = "D" x 8126;
print "
PRAGMA page_size=1024;
PRAGMA cache_size=10;
CREATE TABLE messages (id INTEGER PRIMARY KEY AUTOINCREMENT, data);
BEGIN;
INSERT INTO messages (data) VALUES ('$data');
COMMIT;
DELETE FROM messages WHERE id != 1234567;
VACUUM;
VACUUM;
";
____________________________________________________________________________________
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.
http://answers.yahoo.com/dir/?link=list&sid=396546091
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"SQLiteJDBC" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlitejdbc?hl=en
-~----------~----~----~----~------~----~------~--~---
