SpecialSnowflake
SpecialSnowflake

Reputation: 995

android sqlite no such table

I'm using a premade database and I seem to be getting an error when I try to update a row. The exact error from logcat is: (1) no such table: AUD. Heres what my dbhelper class looks like:

public class DataBaseHelper extends SQLiteOpenHelper {
private static String TAG = "DataBaseHelper"; // Tag just for the LogCat window
//destination path (location) of our database on device
private static String DB_PATH = "/data/data/com.example.simplecurrency3/databases/"; 
private static String DB_NAME ="Currencies";// Database name
private SQLiteDatabase mDataBase; 
private final Context mContext;

public DataBaseHelper(Context context) {
super(context, DB_NAME, null, 2);// 1? its Database Version
if(android.os.Build.VERSION.SDK_INT >= 17){
   DB_PATH = context.getApplicationInfo().dataDir + "/databases/";         
}
else
{
   DB_PATH = "/data/data/" + context.getPackageName() + "/databases/";
}
this.mContext = context;
}   

public void createDataBase() throws IOException {
//If database not exists copy it from the assets

boolean mDataBaseExist = checkDataBase();
if(!mDataBaseExist)
{
    this.getReadableDatabase();
    this.close();
    try 
    {
        //Copy the database from assests
        copyDataBase();
        Log.e(TAG, "createDatabase database created");
    } 
    catch (IOException mIOException) 
    {
        throw new Error("ErrorCopyingDataBase");
    }
}
}
//Check that the database exists here: /data/data/your package/databases/Da Name
private boolean checkDataBase()
{
    File dbFile = new File(DB_PATH + DB_NAME);
    //Log.v("dbFile", dbFile + "   "+ dbFile.exists());
    return dbFile.exists();
}

//Copy the database from assets
private void copyDataBase() throws IOException
{
    InputStream mInput = mContext.getAssets().open(DB_NAME);
    String outFileName = DB_PATH + DB_NAME;
    OutputStream mOutput = new FileOutputStream(outFileName);
    byte[] mBuffer = new byte[1024];
    int mLength;
    while ((mLength = mInput.read(mBuffer))>0)
    {
        mOutput.write(mBuffer, 0, mLength);
    }
    mOutput.flush();
    mOutput.close();
    mInput.close();
}

//Open the database, so we can query it
public boolean openDataBase() throws SQLException
{
    String mPath = DB_PATH + DB_NAME;
    //Log.v("mPath", mPath);
    mDataBase = SQLiteDatabase.openDatabase(mPath, null, SQLiteDatabase.CREATE_IF_NECESSARY);
    //mDataBase = SQLiteDatabase.openDatabase(mPath, null, SQLiteDatabase.NO_LOCALIZED_COLLATORS);
    return mDataBase != null;
}

@Override
public synchronized void close() 
{
    if(mDataBase != null)
        mDataBase.close();
    super.close();
}

@Override
public void onCreate(SQLiteDatabase db) {
    // TODO Auto-generated method stub

}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
    // TODO Auto-generated method stub

}

}

And when I try to update a row:

        Context context = getActivity().getApplicationContext();
        DataBaseHelper dbHelper = new DataBaseHelper(context);
        dbHelper.openDataBase();
        SQLiteDatabase db = dbHelper.getWritableDatabase();         
        db.execSQL("UPDATE AUD SET AUD = 2.0")

Upvotes: 0

Views: 99

Answers (2)

Sadegh
Sadegh

Reputation: 2679

You have never called createDataBase() method! You can put it into onCreate() method.

Good luck

Upvotes: 1

toadalskiii
toadalskiii

Reputation: 136

Instead of updating a row, first check whether the table really exists by using the following query.

SELECT name FROM sqlite_master WHERE type='table'

Upvotes: 0

Related Questions