버튼을 누르면 SQLite를 통해서 Arr로 데이터를 가져와 마커에 생성하려고 합니다.

그런데 버튼을 누르면 시뮬레이터가 멈추고 1분정도 있다가 기다리던가 강제종료를 하라고 합니다.

이러한 로그가 반복되서 나오는것을 볼수 있는데.. 어디를 검색해봐도 알수가 없네요;;

토스트 메시지는 잘 뜹니다..;; 그런데 마커를 만들어줘야되는데 마커가 생성이 안됩니다..

로그를 봐도 어디서 수정해줘야할지 감이 안와서 글을 남깁니다.

고수님들의 도움 부탁드립니다..

기기로 돌려도 같은 현상이 지속되네요..
Sqlite로 마커 생성하기..잘됩니다.
////////////////////////////////////////////////////////

mapView = (MapView) findViewById(R.id.mapview);

mapView.setBuiltInZoomControls(true);

mapOverlays = mapView.getOverlays();

drawable = getResources().getDrawable(R.drawable.marker);

itemizedOverlay = new MyItemizedOverlay(drawable, mapView);

for (int i = 0; i < nameArr.size(); i++) {

GeoPoint point = new GeoPoint

((int)(Double.parseDouble(latArr.get(i))*1E6),

(int)(Double.parseDouble(lngArr.get(i))*1E6));

OverlayItem overlayItem = new OverlayItem(point, nameArr.get(i), 

addressArr.get(i));

itemizedOverlay.addOverlay(overlayItem);

}


버튼 클릭시 주변검색 에러나는 소스 부분
////////////////////////////////////////////////////////////////////////////////////////////////////////////////

ArrayList<String> nameArr = dbhelper.getName();

ArrayList<String> addressArr = dbhelper.getAddress();

ArrayList<String> latArr = dbhelper.getLat();

ArrayList<String> lngArr = dbhelper.getLng();

@Override

public void onClick(View v) {

  Toast.makeText(getApplicationContext(), "local Search Succ",Toast.LENGTH_SHORT ).show();

double distance;

Location locationA = new Location("point A");

           

          locationA.setLatitude(gps.getLatitude());

          locationA.setLongitude(gps.getLongitude());                

          Location locationB = new Location("point B");

        for (int j = 0; j < nameArr.size(); j++) {     

          locationB.setLatitude(Double.parseDouble(latArr.get(j)));

          locationB.setLongitude(Double.parseDouble(lngArr.get(j)));

          distance = locationA.distanceTo(locationB); 

          String meter;

          meter = Double.toString(distance);

           

           

       

          if (distance < 5000)

          {

이부분까지는 문제없이 잘 진행됩니다. 토스트를 띄워본 결과 그런데 아래 부분에서

마커를 찍어주려고만하면...맛이 가네요

어떻게해야 원활하게 마커가 나올수 있을까요?

          for (int k = 0; k < latArr.size(); k++) {


          GeoPoint point = new GeoPoint

      ((int)(locationB.getLatitude()*1E6),

      (int)(locationB.getLongitude()*1E6));

      OverlayItem overlayItem = new OverlayItem(point, nameArr.get(k), 

      addressArr.get(k));

      itemizedOverlay2.addOverlay(overlayItem);

      Toast.makeText(getApplicationContext(), "local Search Succ",Toast.LENGTH_SHORT ).show();

     

}

             

          }


}

         

           

       

         

           

}

});


로그 전체 입니다.
08-18 09:21:30.732: E/Cursor(363): Finalizing a Cursor that has not been deactivated or closed. database = data/data/com.flow.findlib/databases/seoul.db, table = null, query = select * from books
08-18 09:21:30.732: E/Cursor(363): android.database.sqlite.DatabaseObjectNotClosedException: Application did not close the cursor or database object that was opened here
08-18 09:21:30.732: E/Cursor(363): at android.database.sqlite.SQLiteCursor.<init>(SQLiteCursor.java:210)
08-18 09:21:30.732: E/Cursor(363): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:53)
08-18 09:21:30.732: E/Cursor(363): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1345)
08-18 09:21:30.732: E/Cursor(363): at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1315)
08-18 09:21:30.732: E/Cursor(363): at com.flow.findlib.DBAccess.getLat(DBAccess.java:147)
08-18 09:21:30.732: E/Cursor(363): at com.flow.findlib.MainActivity.localsearch(MainActivity.java:235)
08-18 09:21:30.732: E/Cursor(363): at com.flow.findlib.MainActivity.access$2(MainActivity.java:232)
08-18 09:21:30.732: E/Cursor(363): at com.flow.findlib.MainActivity$5.onClick(MainActivity.java:170)
08-18 09:21:30.732: E/Cursor(363): at android.view.View.performClick(View.java:2408)
08-18 09:21:30.732: E/Cursor(363): at android.view.View$PerformClick.run(View.java:8816)
08-18 09:21:30.732: E/Cursor(363): at android.os.Handler.handleCallback(Handler.java:587)
08-18 09:21:30.732: E/Cursor(363): at android.os.Handler.dispatchMessage(Handler.java:92)
08-18 09:21:30.732: E/Cursor(363): at android.os.Looper.loop(Looper.java:123)
08-18 09:21:30.732: E/Cursor(363): at android.app.ActivityThread.main(ActivityThread.java:4627)
08-18 09:21:30.732: E/Cursor(363): at java.lang.reflect.Method.invokeNative(Native Method)
08-18 09:21:30.732: E/Cursor(363): at java.lang.reflect.Method.invoke(Method.java:521)
08-18 09:21:30.732: E/Cursor(363): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
08-18 09:21:30.732: E/Cursor(363): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
08-18 09:21:30.732: E/Cursor(363): at dalvik.system.NativeStart.main(Native Method)
08-18 09:21:30.762: E/Cursor(363): Finalizing a Cursor that has not been deactivated or closed. database = data/data/com.flow.findlib/databases/seoul.db, table = null, query = select * from books
08-18 09:21:30.762: E/Cursor(363): android.database.sqlite.DatabaseObjectNotClosedException: Application did not close the cursor or database object that was opened here
08-18 09:21:30.762: E/Cursor(363): at android.database.sqlite.SQLiteCursor.<init>(SQLiteCursor.java:210)
08-18 09:21:30.762: E/Cursor(363): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:53)
08-18 09:21:30.762: E/Cursor(363): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1345)
08-18 09:21:30.762: E/Cursor(363): at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1315)
08-18 09:21:30.762: E/Cursor(363): at com.flow.findlib.DBAccess.getAddress(DBAccess.java:98)
08-18 09:21:30.762: E/Cursor(363): at com.flow.findlib.MainActivity.localsearch(MainActivity.java:234)
08-18 09:21:30.762: E/Cursor(363): at com.flow.findlib.MainActivity.access$2(MainActivity.java:232)
08-18 09:21:30.762: E/Cursor(363): at com.flow.findlib.MainActivity$5.onClick(MainActivity.java:170)
08-18 09:21:30.762: E/Cursor(363): at android.view.View.performClick(View.java:2408)
08-18 09:21:30.762: E/Cursor(363): at android.view.View$PerformClick.run(View.java:8816)
08-18 09:21:30.762: E/Cursor(363): at android.os.Handler.handleCallback(Handler.java:587)
08-18 09:21:30.762: E/Cursor(363): at android.os.Handler.dispatchMessage(Handler.java:92)
08-18 09:21:30.762: E/Cursor(363): at android.os.Looper.loop(Looper.java:123)
08-18 09:21:30.762: E/Cursor(363): at android.app.ActivityThread.main(ActivityThread.java:4627)
08-18 09:21:30.762: E/Cursor(363): at java.lang.reflect.Method.invokeNative(Native Method)
08-18 09:21:30.762: E/Cursor(363): at java.lang.reflect.Method.invoke(Method.java:521)
08-18 09:21:30.762: E/Cursor(363): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
08-18 09:21:30.762: E/Cursor(363): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
08-18 09:21:30.762: E/Cursor(363): at dalvik.system.NativeStart.main(Native Method)
08-18 09:21:30.862: E/Cursor(363): Finalizing a Cursor that has not been deactivated or closed. database = data/data/com.flow.findlib/databases/seoul.db, table = null, query = select * from books
08-18 09:21:30.862: E/Cursor(363): android.database.sqlite.DatabaseObjectNotClosedException: Application did not close the cursor or database object that was opened here
08-18 09:21:30.862: E/Cursor(363): at android.database.sqlite.SQLiteCursor.<init>(SQLiteCursor.java:210)
08-18 09:21:30.862: E/Cursor(363): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:53)
08-18 09:21:30.862: E/Cursor(363): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1345)
08-18 09:21:30.862: E/Cursor(363): at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1315)
08-18 09:21:30.862: E/Cursor(363): at com.flow.findlib.DBAccess.getName(DBAccess.java:84)
08-18 09:21:30.862: E/Cursor(363): at com.flow.findlib.MainActivity.localsearch(MainActivity.java:233)
08-18 09:21:30.862: E/Cursor(363): at com.flow.findlib.MainActivity.access$2(MainActivity.java:232)
08-18 09:21:30.862: E/Cursor(363): at com.flow.findlib.MainActivity$5.onClick(MainActivity.java:170)
08-18 09:21:30.862: E/Cursor(363): at android.view.View.performClick(View.java:2408)
08-18 09:21:30.862: E/Cursor(363): at android.view.View$PerformClick.run(View.java:8816)
08-18 09:21:30.862: E/Cursor(363): at android.os.Handler.handleCallback(Handler.java:587)
08-18 09:21:30.862: E/Cursor(363): at android.os.Handler.dispatchMessage(Handler.java:92)
08-18 09:21:30.862: E/Cursor(363): at android.os.Looper.loop(Looper.java:123)
08-18 09:21:30.862: E/Cursor(363): at android.app.ActivityThread.main(ActivityThread.java:4627)
08-18 09:21:30.862: E/Cursor(363): at java.lang.reflect.Method.invokeNative(Native Method)
08-18 09:21:30.862: E/Cursor(363): at java.lang.reflect.Method.invoke(Method.java:521)
08-18 09:21:30.862: E/Cursor(363): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
08-18 09:21:30.862: E/Cursor(363): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
08-18 09:21:30.862: E/Cursor(363): at dalvik.system.NativeStart.main(Native Method)
08-18 09:21:30.962: D/lat(363): 37.544622
08-18 09:21:30.962: D/lng(363): 37.544622
08-18 09:21:30.962: D/distance(363): 12836.11328125
08-18 09:21:31.091: D/lat(363): 37.621504
08-18 09:21:31.091: D/lng(363): 37.621504
08-18 09:21:31.091: D/distance(363): 11049.857421875
08-18 09:21:31.221: D/lat(363): 37.613498
08-18 09:21:31.221: D/lng(363): 37.613498
08-18 09:21:31.221: D/distance(363): 9266.0693359375
08-18 09:21:31.241: D/AndroidRuntime(363): Shutting down VM
08-18 09:21:31.241: W/dalvikvm(363): threadid=1: thread exiting with uncaught exception (group=0x4001d800)
08-18 09:21:31.261: E/AndroidRuntime(363): FATAL EXCEPTION: main
08-18 09:21:31.261: E/AndroidRuntime(363): java.util.IllegalFormatConversionException: f is incompatible with java.lang.Integer
08-18 09:21:31.261: E/AndroidRuntime(363): at java.util.Formatter$Transformer.badArgumentType(Formatter.java:1452)
08-18 09:21:31.261: E/AndroidRuntime(363): at java.util.Formatter$Transformer.transformFromFloat(Formatter.java:1923)
08-18 09:21:31.261: E/AndroidRuntime(363): at java.util.Formatter$Transformer.transform(Formatter.java:1421)
08-18 09:21:31.261: E/AndroidRuntime(363): at java.util.Formatter.doFormat(Formatter.java:1082)
08-18 09:21:31.261: E/AndroidRuntime(363): at java.util.Formatter.format(Formatter.java:994)
08-18 09:21:31.261: E/AndroidRuntime(363): at java.lang.String.format(String.java:2254)
08-18 09:21:31.261: E/AndroidRuntime(363): at java.lang.String.format(String.java:2219)
08-18 09:21:31.261: E/AndroidRuntime(363): at com.flow.findlib.MainActivity.localsearch(MainActivity.java:280)
08-18 09:21:31.261: E/AndroidRuntime(363): at com.flow.findlib.MainActivity.access$2(MainActivity.java:232)
08-18 09:21:31.261: E/AndroidRuntime(363): at com.flow.findlib.MainActivity$5.onClick(MainActivity.java:170)
08-18 09:21:31.261: E/AndroidRuntime(363): at android.view.View.performClick(View.java:2408)
08-18 09:21:31.261: E/AndroidRuntime(363): at android.view.View$PerformClick.run(View.java:8816)
08-18 09:21:31.261: E/AndroidRuntime(363): at android.os.Handler.handleCallback(Handler.java:587)
08-18 09:21:31.261: E/AndroidRuntime(363): at android.os.Handler.dispatchMessage(Handler.java:92)
08-18 09:21:31.261: E/AndroidRuntime(363): at android.os.Looper.loop(Looper.java:123)
08-18 09:21:31.261: E/AndroidRuntime(363): at android.app.ActivityThread.main(ActivityThread.java:4627)
08-18 09:21:31.261: E/AndroidRuntime(363): at java.lang.reflect.Method.invokeNative(Native Method)
08-18 09:21:31.261: E/AndroidRuntime(363): at java.lang.reflect.Method.invoke(Method.java:521)
08-18 09:21:31.261: E/AndroidRuntime(363): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
08-18 09:21:31.261: E/AndroidRuntime(363): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
08-18 09:21:31.261: E/AndroidRuntime(363): at dalvik.system.NativeStart.main(Native Method)
08-18 09:21:33.372: D/dalvikvm(363): GC_EXPLICIT freed 4695 objects / 321736 bytes in 112ms
08-18 09:21:33.392: E/Cursor(363): Finalizing a Cursor that has not been deactivated or closed. database = data/data/com.flow.findlib/databases/seoul.db, table = null, query = select * from books
08-18 09:21:33.392: E/Cursor(363): android.database.sqlite.DatabaseObjectNotClosedException: Application did not close the cursor or database object that was opened here
08-18 09:21:33.392: E/Cursor(363): at android.database.sqlite.SQLiteCursor.<init>(SQLiteCursor.java:210)
08-18 09:21:33.392: E/Cursor(363): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:53)
08-18 09:21:33.392: E/Cursor(363): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1345)
08-18 09:21:33.392: E/Cursor(363): at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1315)
08-18 09:21:33.392: E/Cursor(363): at com.flow.findlib.DBAccess.getLng(DBAccess.java:160)
08-18 09:21:33.392: E/Cursor(363): at com.flow.findlib.MainActivity.localsearch(MainActivity.java:236)
08-18 09:21:33.392: E/Cursor(363): at com.flow.findlib.MainActivity.access$2(MainActivity.java:232)
08-18 09:21:33.392: E/Cursor(363): at com.flow.findlib.MainActivity$5.onClick(MainActivity.java:170)
08-18 09:21:33.392: E/Cursor(363): at android.view.View.performClick(View.java:2408)
08-18 09:21:33.392: E/Cursor(363): at android.view.View$PerformClick.run(View.java:8816)
08-18 09:21:33.392: E/Cursor(363): at android.os.Handler.handleCallback(Handler.java:587)
08-18 09:21:33.392: E/Cursor(363): at android.os.Handler.dispatchMessage(Handler.java:92)
08-18 09:21:33.392: E/Cursor(363): at android.os.Looper.loop(Looper.java:123)
08-18 09:21:33.392: E/Cursor(363): at android.app.ActivityThread.main(ActivityThread.java:4627)
08-18 09:21:33.392: E/Cursor(363): at java.lang.reflect.Method.invokeNative(Native Method)
08-18 09:21:33.392: E/Cursor(363): at java.lang.reflect.Method.invoke(Method.java:521)
08-18 09:21:33.392: E/Cursor(363): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
08-18 09:21:33.392: E/Cursor(363): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
08-18 09:21:33.392: E/Cursor(363): at dalvik.system.NativeStart.main(Native Method)
08-18 09:21:35.721: D/dalvikvm(363): GC_EXPLICIT freed 783 objects / 91152 bytes in 57ms