Hi! I have built SQLite-JDBC with SQLite version 3.6.23.1 for my own purposes, and called it "v57". It seems to me that it's better to use newer version of SQLite (instead of version 3.6.14.2 shipped with "v56") as it includes several important bug fixes.
The file sqlitejdbc-v057-pure.jar can be downloaded from URL http://ubuntuone.com/p/ChV/ Hope this will be useful for someone. Best regards, Max Zinal. P.S. Here are test results (for the tests which were part of a build process). There were three (mostly identical) test failures, although the resulting binary seems to work normally. JUnit version 4.1 .......................I.............................................................E..E..E..................... Time: 29,266 There were 3 failures: 1) insert(test.TransactionTest) java.sql.SQLException: database is locked at org.sqlite.DB.throwex(DB.java:288) at org.sqlite.NestedDB.prepare(NestedDB.java:115) at org.sqlite.DB.prepare(DB.java:114) at org.sqlite.Stmt.executeQuery(Stmt.java:89) at test.TransactionTest.insert(TransactionTest.java:75) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 25) at java.lang.reflect.Method.invoke(Method.java:597) at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java: 99) at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java: 81) at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java: 34) at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java: 75) at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java: 45) at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java: 71) at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java: 35) at org.junit.internal.runners.TestClassRunner $1.runUnprotected(TestClassRunner.java:42) at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java: 34) at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java: 52) at org.junit.internal.runners.CompositeRunner.run(CompositeRunner.java: 29) at org.junit.runner.JUnitCore.run(JUnitCore.java:121) at org.junit.runner.JUnitCore.run(JUnitCore.java:100) at org.junit.runner.JUnitCore.run(JUnitCore.java:91) at org.junit.runner.JUnitCore.runMain(JUnitCore.java:75) at org.junit.runner.JUnitCore.main(JUnitCore.java:42) 2) locking(test.TransactionTest) java.sql.SQLException: database is locked at org.sqlite.DB.throwex(DB.java:288) at org.sqlite.NestedDB.prepare(NestedDB.java:115) at org.sqlite.DB.prepare(DB.java:114) at org.sqlite.Stmt.executeUpdate(Stmt.java:102) at test.TransactionTest.locking(TransactionTest.java:58) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 25) at java.lang.reflect.Method.invoke(Method.java:597) at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java: 99) at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java: 81) at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java: 34) at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java: 75) at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java: 45) at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java: 71) at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java: 35) at org.junit.internal.runners.TestClassRunner $1.runUnprotected(TestClassRunner.java:42) at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java: 34) at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java: 52) at org.junit.internal.runners.CompositeRunner.run(CompositeRunner.java: 29) at org.junit.runner.JUnitCore.run(JUnitCore.java:121) at org.junit.runner.JUnitCore.run(JUnitCore.java:100) at org.junit.runner.JUnitCore.run(JUnitCore.java:91) at org.junit.runner.JUnitCore.runMain(JUnitCore.java:75) at org.junit.runner.JUnitCore.main(JUnitCore.java:42) 3) multiRollback(test.TransactionTest) java.sql.SQLException: database is locked at org.sqlite.DB.throwex(DB.java:288) at org.sqlite.NestedDB.prepare(NestedDB.java:115) at org.sqlite.DB.prepare(DB.java:114) at org.sqlite.Stmt.executeQuery(Stmt.java:89) at test.TransactionTest.multiRollback(TransactionTest.java:140) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java: 39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java: 25) at java.lang.reflect.Method.invoke(Method.java:597) at org.junit.internal.runners.TestMethodRunner.executeMethodBody(TestMethodRunner.java: 99) at org.junit.internal.runners.TestMethodRunner.runUnprotected(TestMethodRunner.java: 81) at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java: 34) at org.junit.internal.runners.TestMethodRunner.runMethod(TestMethodRunner.java: 75) at org.junit.internal.runners.TestMethodRunner.run(TestMethodRunner.java: 45) at org.junit.internal.runners.TestClassMethodsRunner.invokeTestMethod(TestClassMethodsRunner.java: 71) at org.junit.internal.runners.TestClassMethodsRunner.run(TestClassMethodsRunner.java: 35) at org.junit.internal.runners.TestClassRunner $1.runUnprotected(TestClassRunner.java:42) at org.junit.internal.runners.BeforeAndAfterRunner.runProtected(BeforeAndAfterRunner.java: 34) at org.junit.internal.runners.TestClassRunner.run(TestClassRunner.java: 52) at org.junit.internal.runners.CompositeRunner.run(CompositeRunner.java: 29) at org.junit.runner.JUnitCore.run(JUnitCore.java:121) at org.junit.runner.JUnitCore.run(JUnitCore.java:100) at org.junit.runner.JUnitCore.run(JUnitCore.java:91) at org.junit.runner.JUnitCore.runMain(JUnitCore.java:75) at org.junit.runner.JUnitCore.main(JUnitCore.java:42) FAILURES!!! Tests run: 109, Failures: 3 -- Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to sqlitejdbc-unsubscr...@googlegroups.com
