I am fetching HashMap from JSONArray and sending it to SQLite. Its giving me.java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.String. HashMap conversion issue.
The type is HashMap>.
for(int i=0;i<adsarray.length();i++){
JSONObject obj=adsarray.getJSONObject(i);
HashMap mapReceivedAdDetails=new HashMap();
HashMap mapBusinessInfo=new HashMap();
//mapBusinessInfo.put
mapReceivedAdDetails.put("RecAdId", obj.getInt("received_ad_id"));
mapReceivedAdDetails.put("RecBusinessId",obj.getInt("business_id"));
mapReceivedAdDetails.put("RecBusinessId",obj.getInt("user_id"));
mapReceivedAdDetails.put("RecAdtitle",obj.getString("received_ad_title"));
mapReceivedAdDetails.put("RecAdDetail",obj.getString("received_ad_detail"));
mapReceivedAdDetails.put("RecBusinessZip",obj.getString("business_zip"));
mapReceivedAdDetails.put("RecBusinessCountry", obj.getString("business_country"));
mapReceivedAdDetails.put("AdCreated", obj.getString("adreceived_created"));
mapReceivedAd.put(i, mapReceivedAdDetails);
//Log.i("ReceivedId",mapReceivedAd.toString());
mapBusinessInfo.put("BusinessId",obj.getInt("business_id"));
mapBusinessInfo.put("BusUserId",obj.getInt("user_id"));
mapBusinessInfo.put("BusName",obj.getString("business_name"));
mapBusinessInfo.put("BusSt1",obj.getString("business_street1"));
mapBusinessInfo.put("BusSt2",obj.getString("business_street2"));
mapBusinessInfo.put("BusCity",obj.getString("business_city"));
mapBusinessInfo.put("BusState",obj.getString("business_state"));
mapBusinessInfo.put("BusCountry",obj.getString("business_country"));
mapBusinessInfo.put("BusZip",obj.getString("business_zip"));
mapBusinessInfo.put("BusContactNo",obj.getString("business_contactno"));
mapBusinessInfo.put("BusWebsite",obj.getString("business_website"));
mapBusinessInfo.put("BusCreated",obj.getString("business_created"));
mapBusinessDetail.put(i,mapBusinessInfo);
// Log.i("BusinessDetail",mapBusinessDetail.toString());
/* ad_business_id=obj.getInt("business_id");
ad_user_id=obj.getInt("user_id");
receive_ad_title=obj.getString("received_ad_title");
receive_ad_detail=obj.getString("received_ad_detail");
ad_business_zip=obj.getString("business_zip");
ad_business_country=obj.getString("business_country");*/
//ad_date_created=obj.getString("date_created");
//Log.i("+ad_business_id+"+"+ad_user_id+" "+receive_ad_title+" "+receive_ad_detail+" "+ad_business_zip+" "+ad_business_country+" ");
}
SQLIte code
while(i<mapBusinessInfo.size())
{
insert.bindLong(1, Integer.parseInt(mapBusinessInfo.get(i).get("BusUserId")));
insert.bindLong(2, Integer.parseInt(mapBusinessInfo.get(i).get("BusinessId")));
insert.bindString(3, mapBusinessInfo.get(i).get("BusName"));
insert.bindString(4, mapBusinessInfo.get(i).get("BusSt1"));
insert.bindString(5, mapBusinessInfo.get(i).get("BusSt2"));
insert.bindString(6, mapBusinessInfo.get(i).get("BusCity"));
insert.bindString(7, mapBusinessInfo.get(i).get("BusState"));
insert.bindString(8, mapBusinessInfo.get(i).get("BusCountry"));
insert.bindString(9, mapBusinessInfo.get(i).get("BusZip"));
insert.bindString(10, mapBusinessInfo.get(i).get("BusContactNo"));
insert.bindString(11, mapBusinessInfo.get(i).get("BusWebsite"));
insert.bindLong(12, Long.parseLong(mapBusinessInfo.get(i).get("BusCreated")));
insert.execute();
i++;
}
db.setTransactionSuccessful();
Log.i("Transaction", "Successful");
}
Aucun commentaire:
Enregistrer un commentaire