[sqlite] Android - Occasional Error when closing a database

2013-10-29 Thread Matthew Dumbleton
I have an android application using sqlite that starts with a database being created and then filled with a lot of data. I have noticed that occasionally, after the data is entered and the transaction ended, the close method call produces an error 'unable to close due to unfinalised statements'

Re: [sqlite] Android - Occasional Error when closing a database

2013-10-29 Thread Richard Hipp
On Tue, Oct 29, 2013 at 9:23 AM, Matthew Dumbleton msd...@hotmail.comwrote: I have an android application using sqlite that starts with a database being created and then filled with a lot of data. I have noticed that occasionally, after the data is entered and the transaction ended, the close

Re: [sqlite] Android - Occasional Error when closing a database

2013-10-29 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 29/10/13 06:23, Matthew Dumbleton wrote: I have noticed that occasionally, after the data is entered and the transaction ended, the close method call produces an error 'unable to close due to unfinalised statements' and logCat shows the

Re: [sqlite] Android - Occasional Error when closing a database

2013-10-29 Thread Matthew Dumbleton
I insert the data using: SQLiteStatement myStatement = databaseWriter.compileStatement(statementString); myStatement.executeInsert(); After Richards reply I went back and enclosed all these in try finally blocks with myStatement.close(); now in the finally bracket. Guess I missed one