OK, I'll see if the problem continues to exist and give it a try.
Thank you!
On Aug 22, 1:58 am, Joe Wilson <[EMAIL PROTECTED]> wrote:
> 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]
-~----------~----~----~----~------~----~------~--~---
