Android : SQL Lite insertion or create table issue
- by Ram
Team,
can anyone please help me to understand what could be the problem in the below snippet of code? It fails after insertion 2 and insertion 3 debug statements
I have the contentValues in the Array list, I am iterating the arraylist and inserting the content values in to the database.
Log.d("database","before insertion 1 ");
liteDatabase = this.openOrCreateDatabase("Sales", MODE_PRIVATE,
null);
Log.d("database","before insertion 2 ");
liteDatabase
.execSQL("Create table activity ( ActivityId VARCHAR,Created VARCHAR,AMTaps_X VARCHAR,AMTemperature_X VARCHAR,AccountId VARCHAR,AccountLocation VARCHAR,AccountName VARCHAR,Classification VARCHAR,ActivityType VARCHAR,COTaps_X VARCHAR,COTemperature_X VARCHAR,Comment VARCHAR,ContactWorkPhone VARCHAR,CreatedByName VARCHAR,DSCycleNo_X VARCHAR,DSRouteNo_X VARCHAR,DSSequenceNo_X VARCHAR,Description VARCHAR,HETaps_X VARCHAR,HETemperature_X VARCHAR,Pro_Setup VARCHAR,LastUpdated VARCHAR,LastUpdatedBy VARCHAR,Licensee VARCHAR,MUTaps_X VARCHAR,MUTemperature_X VARCHAR,Objective VARCHAR,OwnerFirstName VARCHAR,OwnerLastName VARCHAR,PhoneNumber VARCHAR,Planned VARCHAR,PlannedCleanActualDt_X VARCHAR,PlannedCleanReason_X VARCHAR,PrimaryOwnedBy VARCHAR,Pro_Name VARCHAR,ServiceRepTerritory_X VARCHAR,ServiceRep_X VARCHAR,Status VARCHAR,Type VARCHAR,HEINDSTapAuditDate VARCHAR,HEINEmployeeType VARCHAR)");
Log.d("database","before insertion 3 ");
int counter = 0;
int size = arrayList.size();
for (counter = 0; counter < size; counter++) {
ContentValues contentValues = (ContentValues) arrayList
.get(counter);
liteDatabase.insert("activity", "activityInfo", contentValues);
Log.d("database", "Database insertion is done");
}
}
