Cursor de base de données
Bonsoir.
J'ai une erreur sur cette ligne que ne n'arrive pas résoudre grrrr !!
Code:
Cursor mCursor = db.rawQuery("select titre from activites where date LIKE '%mercredi 19 juin 2013%'", new String[]{"activites"});
Voici le log :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
| 06-19 20:03:44.112: D/AndroidRuntime(12249): Shutting down VM
06-19 20:03:44.132: W/dalvikvm(12249): threadid=3: thread exiting with uncaught exception (group=0x4001b188)
06-19 20:03:44.142: E/AndroidRuntime(12249): Uncaught handler: thread main exiting due to uncaught exception
06-19 20:03:44.172: E/AndroidRuntime(12249): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.medichome/com.example.medichome.CalendarDayView}: android.database.sqlite.SQLiteException: bind or column index out of range: handle 0x2f1db0
06-19 20:03:44.172: E/AndroidRuntime(12249): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2496)
06-19 20:03:44.172: E/AndroidRuntime(12249): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2512)
06-19 20:03:44.172: E/AndroidRuntime(12249): at android.app.ActivityThread.access$2200(ActivityThread.java:119)
06-19 20:03:44.172: E/AndroidRuntime(12249): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1863)
06-19 20:03:44.172: E/AndroidRuntime(12249): at android.os.Handler.dispatchMessage(Handler.java:99)
06-19 20:03:44.172: E/AndroidRuntime(12249): at android.os.Looper.loop(Looper.java:123)
06-19 20:03:44.172: E/AndroidRuntime(12249): at android.app.ActivityThread.main(ActivityThread.java:4363)
06-19 20:03:44.172: E/AndroidRuntime(12249): at java.lang.reflect.Method.invokeNative(Native Method)
06-19 20:03:44.172: E/AndroidRuntime(12249): at java.lang.reflect.Method.invoke(Method.java:521)
06-19 20:03:44.172: E/AndroidRuntime(12249): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:860)
06-19 20:03:44.172: E/AndroidRuntime(12249): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618)
06-19 20:03:44.172: E/AndroidRuntime(12249): at dalvik.system.NativeStart.main(Native Method)
06-19 20:03:44.172: E/AndroidRuntime(12249): Caused by: android.database.sqlite.SQLiteException: bind or column index out of range: handle 0x2f1db0
06-19 20:03:44.172: E/AndroidRuntime(12249): at android.database.sqlite.SQLiteProgram.native_bind_string(Native Method)
06-19 20:03:44.172: E/AndroidRuntime(12249): at android.database.sqlite.SQLiteProgram.bindString(SQLiteProgram.java:178)
06-19 20:03:44.172: E/AndroidRuntime(12249): at android.database.sqlite.SQLiteQuery.bindString(SQLiteQuery.java:190)
06-19 20:03:44.172: E/AndroidRuntime(12249): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:55)
06-19 20:03:44.172: E/AndroidRuntime(12249): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1221)
06-19 20:03:44.172: E/AndroidRuntime(12249): at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1194)
06-19 20:03:44.172: E/AndroidRuntime(12249): at com.example.medichome.DBAdapter.getAllActiviteByDate(DBAdapter.java:198)
06-19 20:03:44.172: E/AndroidRuntime(12249): at com.example.medichome.CalendarDayView.onCreate(CalendarDayView.java:236)
06-19 20:03:44.172: E/AndroidRuntime(12249): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
06-19 20:03:44.172: E/AndroidRuntime(12249): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2459)
06-19 20:03:44.172: E/AndroidRuntime(12249): ... 11 more
06-19 20:03:44.412: D/dalvikvm(12249): GC freed 4754 objects / 282200 bytes in 177ms
06-19 20:03:44.422: E/Database(12249): Leak found
06-19 20:03:44.422: E/Database(12249): java.lang.IllegalStateException: /data/data/com.example.medichome/databases/medichome_database SQLiteDatabase created and never closed
06-19 20:03:44.422: E/Database(12249): at android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1695)
06-19 20:03:44.422: E/Database(12249): at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:739)
06-19 20:03:44.422: E/Database(12249): at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:761)
06-19 20:03:44.422: E/Database(12249): at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:754)
06-19 20:03:44.422: E/Database(12249): at android.app.ApplicationContext.openOrCreateDatabase(ApplicationContext.java:473)
06-19 20:03:44.422: E/Database(12249): at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:193)
06-19 20:03:44.422: E/Database(12249): at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:98)
06-19 20:03:44.422: E/Database(12249): at com.example.medichome.DBAdapter.open(DBAdapter.java:106)
06-19 20:03:44.422: E/Database(12249): at com.example.medichome.CalendarDayView.onCreate(CalendarDayView.java:217)
06-19 20:03:44.422: E/Database(12249): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
06-19 20:03:44.422: E/Database(12249): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2459)
06-19 20:03:44.422: E/Database(12249): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2512)
06-19 20:03:44.422: E/Database(12249): at android.app.ActivityThread.access$2200(ActivityThread.java:119)
06-19 20:03:44.422: E/Database(12249): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1863)
06-19 20:03:44.422: E/Database(12249): at android.os.Handler.dispatchMessage(Handler.java:99)
06-19 20:03:44.422: E/Database(12249): at android.os.Looper.loop(Looper.java:123)
06-19 20:03:44.422: E/Database(12249): at android.app.ActivityThread.main(ActivityThread.java:4363)
06-19 20:03:44.422: E/Database(12249): at java.lang.reflect.Method.invokeNative(Native Method)
06-19 20:03:44.422: E/Database(12249): at java.lang.reflect.Method.invoke(Method.java:521)
06-19 20:03:44.422: E/Database(12249): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:860)
06-19 20:03:44.422: E/Database(12249): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618)
06-19 20:03:44.422: E/Database(12249): at dalvik.system.NativeStart.main(Native Method)
06-19 20:03:44.432: I/dalvikvm(12249): threadid=7: reacting to signal 3
06-19 20:03:44.476: E/dalvikvm(12249): Unable to open stack trace file '/data/anr/traces.txt': Permission denied
06-19 20:03:46.062: I/Process(12249): Sending signal. PID: 12249 SIG: 9 |
Merci