SQLite: Must a Cursor be closed when the DB is closed?

Question

I have an open database an read out some data. After my read operations are done I close the database but not the cursor.

Do I need to close the Cursor too? I assume it will be done by the close of the db, but is that true? What may happen if I don't close the Cursor?

SQLiteDatabase db = ...;
Cursor c = database.rawQuery("SELECT * FROM foo");
//read some values using the Cursor

c.close(); //<- is this required?
db.close();

score 0 · Answer 1 · edited May 23 '17 at 12:26

0

The documentation says:

When finished iterating through results, call close() on the cursor to release its resources.

If you do not close the cursor, you might get an exception later.

edited May 23 '17 at 12:26

Community

1
1

answered Apr 28 '17 at 09:13

CL.

173,858
17
217
259

The question is does db.close() call close() on all its Cursors? – Chriss Apr 28 '17 at 09:56
AFAICS it does not. – CL. Apr 28 '17 at 10:18

score 0 · Answer 2 · edited Mar 05 '19 at 09:00

0

If you close a database, the corresponding cursor will also be closed as far as I know.

An example of an exception that was thrown when I tried to traverse through a cursor (via cursor.moveToNext()) after having closed it's corresponding SQLite database is as follows:

java.lang.IllegalStateException: Cannot perform this operation because the connection pool has been closed.

edited Mar 05 '19 at 09:00

M.K

1,464
2
24
46

answered Mar 05 '19 at 07:53

HJDesulme

16
6

SQLite: Must a Cursor be closed when the DB is closed?

2 Answers2