왜 db insert 가 안될까요?? (로그파일포함)

졸짱

https://www.androidpub.com/android_dev_qna/835272

2010.10.02 02:14:00

4077

디비 insert 시 문제입니다.

테이블만들고 쿼리 날리는것까지 되는데 왜 안될까요??

execSQL() 이용하였구요 로그파일 오류는 다음과 같습니다

01-01 00:40:49.490: ERROR/AndroidRuntime(3213): Uncaught handler: thread main exiting due to uncaught exception
01-01 00:40:49.520: ERROR/AndroidRuntime(3213): android.database.sqlite.SQLiteException: unknown error: insert into rank values('kaka',1001, current_date);
01-01 00:40:49.520: ERROR/AndroidRuntime(3213):     at android.database.sqlite.SQLiteDatabase.native_execSQL(Native Method)
01-01 00:40:49.520: ERROR/AndroidRuntime(3213):     at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1610)
01-01 00:40:49.520: ERROR/AndroidRuntime(3213):     at cic.ulsan.ac.kr.kcrossword.Ending.run_query(Ending.java:177)
01-01 00:40:49.520: ERROR/AndroidRuntime(3213):     at cic.ulsan.ac.kr.kcrossword.Ending$1.onClick(Ending.java:92)
01-01 00:40:49.520: ERROR/AndroidRuntime(3213):     at com.android.internal.app.AlertController$ButtonHandler.handleMessage(AlertController.java:158)
01-01 00:40:49.520: ERROR/AndroidRuntime(3213):     at android.os.Handler.dispatchMessage(Handler.java:99)
01-01 00:40:49.520: ERROR/AndroidRuntime(3213):     at android.os.Looper.loop(Looper.java:123)
01-01 00:40:49.520: ERROR/AndroidRuntime(3213):     at android.app.ActivityThread.main(ActivityThread.java:4363)
01-01 00:40:49.520: ERROR/AndroidRuntime(3213):     at java.lang.reflect.Method.invokeNative(Native Method)
01-01 00:40:49.520: ERROR/AndroidRuntime(3213):     at java.lang.reflect.Method.invoke(Method.java:521)
01-01 00:40:49.520: ERROR/AndroidRuntime(3213):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:860)
01-01 00:40:49.520: ERROR/AndroidRuntime(3213):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:618)
01-01 00:40:49.520: ERROR/AndroidRuntime(3213):     at dalvik.system.NativeStart.main(Native Method)

----------------------------------------------------------------------------------------------------------------------------------------

rank 테이블은 create table rank(id text, point integer, sysdate date) 형식으로 되어있습니다.

아시는분 빠른 답변 부탁드릴께요~~

이 게시물을

2010.10.02 03:36:23

JustinLee

        public long insertActivity(String activity,  String date) {
        ContentValues initialValues = new ContentValues();
        initialValues.put(KEY_ACTIVITY, activity);
        initialValues.put(KEY_DATE, date);

        return _db.insert(DATABASE_ACTIVITY_TABLE, null, initialValues);
    }

저는 이런식으로 해서 쿼리하는뎅..

어쨋든
ID 가 text니까
String type으로 날려줘야하잖아요
'kaka' 가 아니고 \"kaka\" 아닐까요?

어떻게 쿼리를 날리셧는지
execSQL 쓰셧으면

     private static final String queryEx   =   "insert into rank values (\"kaka\",300);";
_db.execSQL(queryEx);

이런식으로 하셧남?