I have table not found in SQLite database table.
-
Here is my logcat: 08-11 13:40:18.540 15571-15571/com.test E/SQLiteLog﹕ (1) no such table: mydb 08-11 13:40:18.547 15571-15571/com.test E/SQLiteDatabase﹕ Error inserting name=abc dates=2015-08-11 01:39:56 mobno=12344553mailid=abc@abc.com bday=2/2/4341 android.database.sqlite.SQLiteException: no such table: mydb (code 1): , while compiling: INSERT INTO mydb(name,dates,mobno,mailid,bday) VALUES (?,?,?,?,?) Here is my DatabaseHelper.java file package com.test; import android.content.ContentValues; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; import android.util.Log; import java.sql.SQLException; public class DatabaseHelper { public static final String KEY_ROWID="_id"; public static final String KEY_NAME="name"; public static final String KEY_BDAY="bday"; public static final String KEY_MOBNO="mobno"; public static final String KEY_MAIL="mailid"; public static final String KEY_DATE="dates"; private static final String DATABASE_NAME="mydb"; private static final String DATABASE_TABLE="mytable"; private static final int DATABASE_VERSION=1; private DbHelper ourhelper; private Context ourcontext; private SQLiteDatabase ourdatabase; public DatabaseHelper(Context c){ ourcontext=c; } public DatabaseHelper open() throws SQLException{ ourhelper = new DbHelper(ourcontext); ourdatabase= ourhelper.getWritableDatabase(); return this; } public long createentry(String name, String bday, String mobno, String mail, String dater) { ContentValues cv=new ContentValues(); cv.put(KEY_NAME,name); cv.put(KEY_BDAY,bday); cv.put(KEY_MOBNO,mobno); cv.put(KEY_MAIL, mail); cv.put(KEY_DATE, dater); return ourdatabase.insert(DATABASE_NAME,null,cv); } public void close() { ourhelper.close(); } public String getdata() { String[] columns=new String[]{KEY_NAME,KEY_BDAY,KEY_MOBNO,KEY_MAIL,KEY_DATE}; Cursor c=ourdatabase.query(DATABASE_TABLE, columns, null, null, null, null, null); String result=""; int iName= c.getColumnIndex(KEY_NAME); int iBday= c.getColumnIndex(KEY_BDAY); int iMob= c.getColumnIndex(KEY_MOBNO); int iMail= c.getColumnIndex(KEY_MAIL); int iDate= c.getColumnIndex(KEY_DATE); for (c.moveToFirst
-
Here is my logcat: 08-11 13:40:18.540 15571-15571/com.test E/SQLiteLog﹕ (1) no such table: mydb 08-11 13:40:18.547 15571-15571/com.test E/SQLiteDatabase﹕ Error inserting name=abc dates=2015-08-11 01:39:56 mobno=12344553mailid=abc@abc.com bday=2/2/4341 android.database.sqlite.SQLiteException: no such table: mydb (code 1): , while compiling: INSERT INTO mydb(name,dates,mobno,mailid,bday) VALUES (?,?,?,?,?) Here is my DatabaseHelper.java file package com.test; import android.content.ContentValues; import android.content.Context; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; import android.util.Log; import java.sql.SQLException; public class DatabaseHelper { public static final String KEY_ROWID="_id"; public static final String KEY_NAME="name"; public static final String KEY_BDAY="bday"; public static final String KEY_MOBNO="mobno"; public static final String KEY_MAIL="mailid"; public static final String KEY_DATE="dates"; private static final String DATABASE_NAME="mydb"; private static final String DATABASE_TABLE="mytable"; private static final int DATABASE_VERSION=1; private DbHelper ourhelper; private Context ourcontext; private SQLiteDatabase ourdatabase; public DatabaseHelper(Context c){ ourcontext=c; } public DatabaseHelper open() throws SQLException{ ourhelper = new DbHelper(ourcontext); ourdatabase= ourhelper.getWritableDatabase(); return this; } public long createentry(String name, String bday, String mobno, String mail, String dater) { ContentValues cv=new ContentValues(); cv.put(KEY_NAME,name); cv.put(KEY_BDAY,bday); cv.put(KEY_MOBNO,mobno); cv.put(KEY_MAIL, mail); cv.put(KEY_DATE, dater); return ourdatabase.insert(DATABASE_NAME,null,cv); } public void close() { ourhelper.close(); } public String getdata() { String[] columns=new String[]{KEY_NAME,KEY_BDAY,KEY_MOBNO,KEY_MAIL,KEY_DATE}; Cursor c=ourdatabase.query(DATABASE_TABLE, columns, null, null, null, null, null); String result=""; int iName= c.getColumnIndex(KEY_NAME); int iBday= c.getColumnIndex(KEY_BDAY); int iMob= c.getColumnIndex(KEY_MOBNO); int iMail= c.getColumnIndex(KEY_MAIL); int iDate= c.getColumnIndex(KEY_DATE); for (c.moveToFirst