android.database.sqlite.SQLiteException: no such table / java.lang.reflect.InvocationTargetException

android.database.sqlite.SQLiteException: no such table

테이블 생성이 안되어 있음

sqlite java.lang.reflect.InvocationTargetException

안되서 딴대 참고함 ...

참고 : http://here4you.tistory.com/50

//

android.database.sqlite.SQLiteException: near "IF": syntax error (code 1): , while compiling: 

CREATE TABLE T_CHAT IF NOT EXISTS (CHAT_NO INTEGER PRIMARY KEY AUTOINCREMENT, BOARD_NO INTEGER  CHAT_CONTENT TEXT , INST_DE TEXT , INST_USER_PK TEXT)

원인 

CREATE TABLE T_CHAT IF NOT EXISTS 

변경

CREATE TABLE IF NOT EXISTS T_CHAT 

//

table T_CHAT has 4 columns but 5 values were supplied

4열이 있지만 5개의 값을 넣음 ...

android.database.StaleDataException: Attempting to access a closed CursorWindow.Most probable cause: cursor is deactivated prior to calling this method.

java.lang.IllegalStateException: Couldn't read row 0, col 4 from CursorWindow.

//

adb devices

adb -s 775d4c77 shell

//

why dead ...

public void drop(){

 String sql = "DROP TABLE IF NOT EXISTS T_CHAT";

      db.execSQL(sql);

  }

android.database.sqlite.SQLiteException: near "NOT": syntax error (code 1): , while compiling: DROP TABLE IF NOT EXISTS T_CHAT