gaEcMEf5

1Fatal Exception: android.database.sqlite.SQLiteException: no such table: table_name(code 1): , while compiling: SELECT * FROM table_name
2       at android.database.sqlite.SQLiteConnection.nativePrepareStatement(SQLiteConnection.java)
3       at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
4       at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
5       at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
6       at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:58)
7       at android.database.sqlite.SQLiteQuery.(SQLiteQuery.java:37)
8       at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
9       at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1316)
10       at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1163)
11       at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1034)
12       at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1202)
13       at com.takeoffandroid.database.DBAccess.getCount(SourceFile:384)
14       at   com.takeoffandroid.database.DBAccess.isTableCountLogic(SourceFile:402)
15       at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:66)
16       at android.os.Handler.dispatchMessage(Handler.java:102)
17       at android.os.Looper.loop(Looper.java:148)
18       at android.os.HandlerThread.run(HandlerThread.java:61)
19	
20private static final String TEXT_TYPE = " TEXT";
21private static final String COMMA_SEP = ",";
22private static final String INTEGER_PRIMARY_KEY = " INTEGER PRIMARY KEY AUTOINCREMENT";
23
24
25public static final String TABLE_NAME = "table_name";
26
27private static final String COLUMN_ID = "ID";
28
29private static final String COLUMN_URL = "url";
30private static final String COLUMN_JSON = "json";
31
32private static final String CREATE_TABLE_QUERY = "CREATE TABLE IF NOT EXISTS " + TABLE_NAME + " (" +
33            COLUMN_ID + INTEGER_PRIMARY_KEY + COMMA_SEP +
34            COLUMN_URL + TEXT_TYPE + COMMA_SEP +
35            COLUMN_JSON + TEXT_TYPE + ")";
36
37
38
39public static DBAccess init(Context context) {
40
41
42        if (mInstance == null)
43            synchronized (DBAccess.class) {
44                if (mInstance == null) {
45                    mInstance = new DBAccess(context);
46
47                }
48            }
49        return mInstance;
50    }
51
52    public DBAccess(Context context) {
53        super(context, DATABASE_NAME, null, DATABASE_VERSION);
54    }
55
56    @Override
57    public void onCreate(SQLiteDatabase db) {
58            db.execSQL(CREATE_TABLE_QUERY);
59    }
60	
61public  int getCount() {
62
63
64        int count=0;
65        SQLiteDatabase db=getReadableDatabase();
66        Cursor cursor=db.query(TABLE_NAME, null, null, null, null, null, null);
67
68        count = cursor.getCount();
69
70        CLog.i("Table count", "Table count size is "+String.valueOf(count));
71
72        cursor.close();
73        db.close();
74        close();
75
76        return count;
77
78    }