03-02 13:07:32.230: D/dalvikvm(6829): GC_EXTERNAL_ALLOC freed 88K, 52% free 2612K/5379K, external 2032K/2137K, paused 173ms
03-02 13:07:32.450: D/myLogs(6829): ActivityTaskPattern
03-02 13:07:32.500: D/myLogs(6829): getTaskByName Str s = name = Пример
03-02 13:07:32.500: I/Database(6829): sqlite returned: error code = 1, msg = no such column: Пример
03-02 13:07:32.510: D/myLogs(6829): isNull
03-02 13:07:32.520: D/AndroidRuntime(6829): Shutting down VM
03-02 13:07:32.520: W/dalvikvm(6829): threadid=1: thread exiting with uncaught exception (group=0x40015560)
03-02 13:07:32.562: E/AndroidRuntime(6829): FATAL EXCEPTION: main
03-02 13:07:32.562: E/AndroidRuntime(6829): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.proj_timer/com.example.proj_timer.ActivityTaskPattern}: java.lang.NullPointerException
03-02 13:07:32.562: E/AndroidRuntime(6829): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1647)
03-02 13:07:32.562: E/AndroidRuntime(6829): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1663)
03-02 13:07:32.562: E/AndroidRuntime(6829): at android.app.ActivityThread.access$1500(ActivityThread.java:117)
03-02 13:07:32.562: E/AndroidRuntime(6829): at android.app.ActivityThread$H.handleMessage(ActivityThread.java:931)
03-02 13:07:32.562: E/AndroidRuntime(6829): at android.os.Handler.dispatchMessage(Handler.java:99)
03-02 13:07:32.562: E/AndroidRuntime(6829): at android.os.Looper.loop(Looper.java:123)
03-02 13:07:32.562: E/AndroidRuntime(6829): at android.app.ActivityThread.main(ActivityThread.java:3683)
03-02 13:07:32.562: E/AndroidRuntime(6829): at java.lang.reflect.Method.invokeNative(Native Method)
03-02 13:07:32.562: E/AndroidRuntime(6829): at java.lang.reflect.Method.invoke(Method.java:507)
03-02 13:07:32.562: E/AndroidRuntime(6829): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:839)
03-02 13:07:32.562: E/AndroidRuntime(6829): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597)
03-02 13:07:32.562: E/AndroidRuntime(6829): at dalvik.system.NativeStart.main(Native Method)
03-02 13:07:32.562: E/AndroidRuntime(6829): Caused by: java.lang.NullPointerException
03-02 13:07:32.562: E/AndroidRuntime(6829): at com.example.proj_timer.ActivityTaskPattern.onCreate(ActivityTaskPattern.java:44)
03-02 13:07:32.562: E/AndroidRuntime(6829): at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
03-02 13:07:32.562: E/AndroidRuntime(6829): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1611)
03-02 13:07:32.562: E/AndroidRuntime(6829): ... 11 more
03-02 13:07:36.260: I/Process(6829): Sending signal. PID: 6829 SIG: 9
3)
Думал я над ним, думал, кроме NullPointerException ничего не пойму, да и с чего он выкинулся?Запросы по другим полям(не текстовым) работают
2)что нужно выводить в лог, чтобы было информативней?
1)Где посмотреть как форматировать,как вставлять код?
Если убрать проверку исключений и оставить только
Cursor c= mDB.query(DB_TABLE_TASK, null, COLUMN_TASK_NAME+" = "+taskName, null,null,null,null);
return c;
, в логах появляется:
03-02 13:43:11.530: W/dalvikvm(15403): threadid=1: thread exiting with uncaught exception (group=0x40015560)
03-02 13:43:11.560: E/AndroidRuntime(15403): FATAL EXCEPTION: main
03-02 13:43:11.560: E/AndroidRuntime(15403): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.example.proj_timer/com.example.proj_timer.ActivityTaskPattern}: android.database.sqlite.SQLiteException: no such column: Пример: , while compiling: SELECT * FROM myTasks WHERE name = Пример
03-02 13:43:11.560: E/AndroidRuntime(15403): at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1647)
03-02 13:43:11.560: E/AndroidRuntime(15403): at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1663)
myTasks- это DB_TABLE_TASK="myTasks", а name - COLUMN_TASK_NAME="name";