displayList( )라는 함수가 있습니다.

이 안에서 디비를 이용해 리스트를 보여줍니다.

커서를 사용한 후에 onPause때 닫아줍니다.

그런데 아래와 같은 에러가 자꾸 납니다.

커서를 닫아주지 않아서 나는 에러인데

그래서 닫는 위치를 dispalyList( ) 안에서 커서 사용후 닫아줬더니

리스트가 나오질 않습니다.

커서를 어느 부분에서 닫아줘야 하는건가요?

06-27 13:35:05.561: E/Cursor(22957): Finalizing a Cursor that has not been deactivated or closed. database = /mnt/sdcard/polexgolf/course.list, table = null, query = select * from list group by club
06-27 13:35:05.561: E/Cursor(22957): android.database.sqlite.DatabaseObjectNotClosedException: Application did not close the cursor or database object that was opened here
06-27 13:35:05.561: E/Cursor(22957):  at android.database.sqlite.SQLiteCursor.<init>(SQLiteCursor.java:210)
06-27 13:35:05.561: E/Cursor(22957):  at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:53)
06-27 13:35:05.561: E/Cursor(22957):  at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1350)
06-27 13:35:05.561: E/Cursor(22957):  at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1320)
06-27 13:35:05.561: E/Cursor(22957):  at com.polex.pip.golf.SelectClubActivity.DisplayList(SelectClubActivity.java:292)
06-27 13:35:05.561: E/Cursor(22957):  at com.polex.pip.golf.SelectClubActivity$1.onPostExecute(SelectClubActivity.java:83)
06-27 13:35:05.561: E/Cursor(22957):  at com.polex.pip.golf.SelectClubActivity$1.onPostExecute(SelectClubActivity.java:1)
06-27 13:35:05.561: E/Cursor(22957):  at android.os.AsyncTask.finish(AsyncTask.java:417)
06-27 13:35:05.561: E/Cursor(22957):  at android.os.AsyncTask.access$300(AsyncTask.java:127)
06-27 13:35:05.561: E/Cursor(22957):  at android.os.AsyncTask$InternalHandler.handleMessage(AsyncTask.java:429)
06-27 13:35:05.561: E/Cursor(22957):  at android.os.Handler.dispatchMessage(Handler.java:99)
06-27 13:35:05.561: E/Cursor(22957):  at android.os.Looper.loop(Looper.java:143)
06-27 13:35:05.561: E/Cursor(22957):  at android.app.ActivityThread.main(ActivityThread.java:4732)
06-27 13:35:05.561: E/Cursor(22957):  at java.lang.reflect.Method.invokeNative(Native Method)
06-27 13:35:05.561: E/Cursor(22957):  at java.lang.reflect.Method.invoke(Method.java:521)
06-27 13:35:05.561: E/Cursor(22957):  at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:860)
06-27 13:35:05.561: E/Cursor(22957):  at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618)
06-27 13:35:05.561: E/Cursor(22957):  at dalvik.system.NativeStart.main(Native Method)