안드로이드 개발 질문/답변
(글 수 45,052)
안녕하세요. 늦은 밤까지 수고가 많으십니다.^_^
전체 소스가 길어서 다는 못올리구요. 지금 데이터베이스를 여는 과정에서 외부 sdcard의 경로를 통해서 읽어서 불러오고 데이터베이스가 존재
하지 않을 경우에는 그냥 내부에 데이터베이스가 생성되는데요.
그럼 질문드립니다.
밑에 소스가 오픈소스인데요. 전체적으로는 에러가 없으나 경고가 하나있네요. 빨간색으로 표시되있어요.ㅜㅋ
private void openDB(){
String filePath = getFilesDir().getAbsolutePath() + File.separator + DB_NAME;
SQLiteDatabase sqlite = null;
sqlite = SQLiteDatabase.openDatabase(filePath, null, SQLiteDatabase.OPEN_READWRITE);
Cursor cursor = sqlite.rawQuery("select code_num from category;", null);
sqlite.close();
db = openOrCreateDatabase(DB_NAME, DB_MODE, null);
showToast("DB("+DB_NAME+")생성 or 열림");
}
에뮬에서 작동했는데 오류가 뜨네요..Sorry...ㅜ




관련된 로그 첨부 하겠습니다.
10-05 12:27:11.286: ERROR/Zygote(32): setreuid() failed. errno: 2
10-05 12:27:19.436: ERROR/Zygote(32): setreuid() failed. errno: 17
10-05 12:27:20.816: ERROR/BatteryService(57): usbOnlinePath not found
10-05 12:27:20.816: ERROR/BatteryService(57): batteryVoltagePath not found
10-05 12:27:20.816: ERROR/BatteryService(57): batteryTemperaturePath not found
10-05 12:27:20.836: ERROR/SurfaceFlinger(57): Couldn't open /sys/power/wait_for_fb_sleep or /sys/power/wait_for_fb_wake
10-05 12:27:27.287: ERROR/EventHub(57): could not get driver version for /dev/input/mouse0, Not a typewriter
10-05 12:27:27.287: ERROR/EventHub(57): could not get driver version for /dev/input/mice, Not a typewriter
10-05 12:27:27.567: ERROR/System(57): Failure starting core service
10-05 12:27:27.567: ERROR/System(57): java.lang.SecurityException
10-05 12:27:27.567: ERROR/System(57): at android.os.BinderProxy.transact(Native Method)
10-05 12:27:27.567: ERROR/System(57): at android.os.ServiceManagerProxy.addService(ServiceManagerNative.java:146)
10-05 12:27:27.567: ERROR/System(57): at android.os.ServiceManager.addService(ServiceManager.java:72)
10-05 12:27:27.567: ERROR/System(57): at com.android.server.ServerThread.run(SystemServer.java:184)
10-05 12:27:28.546: ERROR/SoundPool(57): error loading /system/media/audio/ui/Effect_Tick.ogg
10-05 12:27:28.556: ERROR/SoundPool(57): error loading /system/media/audio/ui/KeypressStandard.ogg
10-05 12:27:28.556: ERROR/SoundPool(57): error loading /system/media/audio/ui/KeypressSpacebar.ogg
10-05 12:27:28.556: ERROR/SoundPool(57): error loading /system/media/audio/ui/KeypressDelete.ogg
10-05 12:27:28.566: ERROR/SoundPool(57): error loading /system/media/audio/ui/KeypressReturn.ogg
10-05 12:27:30.556: ERROR/ThrottleService(57): Could not open GPS configuration file /etc/gps.conf
10-05 12:27:30.606: ERROR/ThrottleService(57): Error reading data file
10-05 12:27:31.426: ERROR/logwrapper(132): executing /system/bin/tc failed: No such file or directory
10-05 12:27:31.486: ERROR/logwrapper(137): executing /system/bin/tc failed: No such file or directory
10-05 12:27:31.566: ERROR/logwrapper(139): executing /system/bin/tc failed: No such file or directory
10-05 12:28:06.996: ERROR/Database(228): sqlite3_open_v2("/data/data/material.data.db/files/Material.db", &handle, 2, NULL) failed
10-05 12:28:07.067: ERROR/AndroidRuntime(228): FATAL EXCEPTION: main
10-05 12:28:07.067: ERROR/AndroidRuntime(228): java.lang.RuntimeException: Unable to start activity ComponentInfo{material.data.db/material.data.db.ASMSActivity}: android.database.sqlite.SQLiteException: unable to open database file
10-05 12:28:07.067: ERROR/AndroidRuntime(228): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2663)
10-05 12:28:07.067: ERROR/AndroidRuntime(228): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2679)
10-05 12:28:07.067: ERROR/AndroidRuntime(228): at android.app.ActivityThread.access$2300(ActivityThread.java:125)
10-05 12:28:07.067: ERROR/AndroidRuntime(228): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:2033)
10-05 12:28:07.067: ERROR/AndroidRuntime(228): at android.os.Handler.dispatchMessage(Handler.java:99)
10-05 12:28:07.067: ERROR/AndroidRuntime(228): at android.os.Looper.loop(Looper.java:123)
10-05 12:28:07.067: ERROR/AndroidRuntime(228): at android.app.ActivityThread.main(ActivityThread.java:4627)
10-05 12:28:07.067: ERROR/AndroidRuntime(228): at java.lang.reflect.Method.invokeNative(Native Method)
10-05 12:28:07.067: ERROR/AndroidRuntime(228): at java.lang.reflect.Method.invoke(Method.java:521)
10-05 12:28:07.067: ERROR/AndroidRuntime(228): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:868)
10-05 12:28:07.067: ERROR/AndroidRuntime(228): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:626)
10-05 12:28:07.067: ERROR/AndroidRuntime(228): at dalvik.system.NativeStart.main(Native Method)
10-05 12:28:07.067: ERROR/AndroidRuntime(228): Caused by: android.database.sqlite.SQLiteException: unable to open database file
10-05 12:28:07.067: ERROR/AndroidRuntime(228): at android.database.sqlite.SQLiteDatabase.dbopen(Native Method)
10-05 12:28:07.067: ERROR/AndroidRuntime(228): at android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1812)
10-05 12:28:07.067: ERROR/AndroidRuntime(228): at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:817)
10-05 12:28:07.067: ERROR/AndroidRuntime(228): at material.data.db.ASMSActivity.openDB(ASMSActivity.java:60)
10-05 12:28:07.067: ERROR/AndroidRuntime(228): at material.data.db.ASMSActivity.onCreate(ASMSActivity.java:54)
10-05 12:28:07.067: ERROR/AndroidRuntime(228): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)