mardi 15 mars 2016

Table is not getting created in sqlite [duplicate]

This question already has an answer here:

Im using the following code to create table

String CREATE_SHIPMENTSTATUS_TABLE = "CREATE TABLE IF NOT EXISTS " + TABLE_SHIPMENTSTATUS + "("
        + KEY_ID + " INT PRIMARY KEY NOT NULL,"
        + KEY_DATE + " TEXT NOT NULL,"
        + KEY_NOTES + " TEXT NOT NULL,"
        + KEY_PHOTOS + " TEXT NOT NULL,"
        + KEY_DOCUMENTS + " TEXT NOT NULL,"
        + KEY_VESSALNAME + " TEXT NOT NULL,"
        + KEY_ETD + " TEXT NOT NULL,"
        + KEY_ETA + " TEXT NOT NULL,"
        + KEY_REVISEDETA + " TEXT NOT NULL"
        + ")";

Im adding datas as follows,

public void addShipmentStatus(ShipmentStatusDao pendingOrders) {
        SQLiteDatabase db = this.getWritableDatabase();

        ContentValues values = new ContentValues();

        values.put(KEY_ID, pendingOrders.getId());
        values.put(KEY_DATE, pendingOrders.getDate());
        values.put(KEY_NOTES, pendingOrders.getNotes());
        values.put(KEY_PHOTOS, pendingOrders.getPhotos());
        values.put(KEY_DOCUMENTS, pendingOrders.getDocuments());
        values.put(KEY_VESSALNAME, pendingOrders.getVessalName());
        values.put(KEY_ETD, pendingOrders.getEtd());
        values.put(KEY_ETA, pendingOrders.getEta());
        values.put(KEY_REVISEDETA, pendingOrders.getRevisedEta());


         db.insert(TABLE_SHIPMENTSTATUS, null, values);

        db.close(); // Closing database connection
    }

In my code I use the following code to invoke it,

db.addShipmentStatus(new ShipmentStatusDao(i, notes, date, image, vessalName, docs, etd, eta, revisedEta));

The problem is that Im getting an exception that no table exists while creating table. Why is that table is not getting created?

Following is my error log.

Error inserting revised_Eta=N/A vessalName=N/A photos=N/A id=2 eta=N/A documents=N/A etd=N/A notes=Quality Check In progress notes date=11-FEB-16 android.database.sqlite.SQLiteException: no such table: shipmentStatus (code 1): , while compiling: INSERT INTO shipmentStatus(revised_Eta,vessalName,photos,id,eta,documents,etd,notes,date) VALUES (?,?,?,?,?,?,?,?,?) at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:1118) at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:691) at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588) at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:58) at android.database.sqlite.SQLiteStatement.(SQLiteStatement.java:31) at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1589) at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1461) at com.vaighai.handlers.NotificationDbHandler.addShipmentStatus(NotificationDbHandler.java:234) at com.vaighai.fragments.StatusFragment$3.onResponse(StatusFragment.java:167) at com.vaighai.fragments.StatusFragment$3.onResponse(StatusFragment.java:126) at com.android.volley.toolbox.JsonRequest.deliverResponse(JsonRequest.java:65) at com.android.volley.ExecutorDelivery$ResponseDeliveryRunnable.run(ExecutorDelivery.java:99) at android.os.Handler.handleCallback(Handler.java:730) at android.os.Handler.dispatchMessage(Handler.java:92) at android.os.Looper.loop(Looper.java:176) at android.app.ActivityThread.main(ActivityThread.java:5419) at java.lang.reflect.Method.invokeNative(Native Method) at java.lang.reflect.Method.invoke(Method.java:525) at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1046) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:862) at dalvik.system.NativeStart.main(Native Method)

Aucun commentaire:

Enregistrer un commentaire