Your code fragment seems fine.
There seems to be a finalization problem between the NativeDB and the PrepStmt.
See if it still crashes if you close each prepared statement after use.
In addition, you might also try this untested patch to sqlitejdbc:
--- PrepStmt.java-orig 2007-08-21 19:27:11.000000000 -0400
+++ PrepStmt.java 2007-08-21 19:54:03.000000000 -0400
@@ -33,7 +33,14 @@
/** Weaker close to support object overriding (see docs in RS.java). */
public void close() throws SQLException {
batch = null;
- if (pointer == 0 || db == null) clearRS(); else clearParameters();
+ if (pointer == 0 || db == null) {
+ clearRS();
+ } else {
+ clearParameters();
+ int resp = db.finalize(this);
+ if (resp != SQLITE_OK && resp != SQLITE_MISUSE)
+ db.throwex();
+ }
}
public void clearParameters() throws SQLException {
____________________________________________________________________________________
Yahoo! oneSearch: Finally, mobile search
that gives answers, not web links.
http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---
