> > Despite what the sqlite wiki says, I think sqlite3_finalize now works > > from another thread as long as nothing else is using that sqlite3 > > connection or any prepared statements on that connection. Of course, > > I could be wrong. > > Even if you are not wrong this still means that what driver does is > illegal. A call to sqlite3_finalize from java's finalize may appear > while some other statement is already executing. Or finalize may be > never called. Releasing memory in JDBC's close methods should be good > enough.
If you examine the code you will see that the PrepStmt (prepared statement) instance is derived from RS (result set) which holds onto a reference to a Conn (connection). So the PrepStmt, RS or Conn will not be finalized as long as any of these instances are being referenced by some object in any thread. ____________________________________________________________________________________ Sucker-punch spam with award-winning protection. Try the free Yahoo! Mail Beta. http://advision.webevents.yahoo.com/mailbeta/features_spam.html --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
