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

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 Richard Hipp
On Tue, Oct 29, 2013 at 9:23 AM, Matthew Dumbleton wrote: > 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

[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'