I'm trying to insert the below json response from a server into my sqlite DB and then read from the DB. The problem I am getting is that when I run my code it compiles fine and runs with no errors. But when trying to read from the DB I just get back what seems like an empty string so I know that the table is being created.

I have the correct permissions within the manifest. I have also reference all my classes within there.

{"locations": [{"locations":"Newcastle","location_id":"1"},{"locations":"London","location_id":"2"},{"locations":"Sunderland","location_id":"3"}]}

Below where I use:

Log.v("one", one);
Log.v("two", two);

below It only prints out the first set within the JSON object so Newcastle and 1. I don't get any errors at all which is stumping me. When I call the method getName within the Location class I just seem to get a blank string back!

// This class creates the table as well as inserts and returns data from the sqlite DB

public class Location {

    private DatabaseHelper mDbHelper;
    private SQLiteDatabase mDb;
    private final Context mCtx;

    private static final String vd_location = ("CREATE TABLE " + TABLE_VD_LOCATION  + " ("
            + LOCATION + " TEXT,"
            + LOCATION_ID + " TEXT " +");");

    private static class DatabaseHelper extends SQLiteOpenHelper {

        DatabaseHelper(Context context) {
            super(context, DATABASE_NAME, null, DATABASE_VERSION);
        }

        @Override
        public void onCreate(SQLiteDatabase db) {
            db.execSQL(vd_location);
        }

        @Override
        public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        }
    }

    public Location(Context ctx) {
        this.mCtx = ctx;
    }

    public Location open() throws SQLException {
        this.mDbHelper = new DatabaseHelper(this.mCtx);
        this.mDb = this.mDbHelper.getWritableDatabase();
        return this;
    }

    public void close() {
        this.mDbHelper.close();
    }

    public void addOffer (JSONObject json){

        try{

            JSONArray  earthquakes = json.getJSONArray("offers");

            for(int i=0;i<earthquakes.length();i++){                        
                open();

                JSONObject e = earthquakes.getJSONObject(i);

                String one = e.getString("locations");
                String two = e.getString("location_id");

                Log.v("one", one);
                Log.v("two", two);

                mDb.execSQL("INSERT INTO " + TABLE_VD_LOCATION + " ( locations, location_id ) " +
                        "VALUES (?, ?)",
                        new Object [] {
                            e.getString("locations"),
                            e.getString("location_id")});
                close();
            }

        }catch(Exception e){

        }finally{
            close();
        }
    }

    public String getName(long l) throws SQLException{

        String[] columns = new String[]{ LOCATION, LOCATION_ID};
        Cursor c = mDb.query(TABLE_VD_LOCATION, columns, null, null, null, null, null);
        String result = "";

        int iRow = c.getColumnIndex(LOCATION);
        int iName = c.getColumnIndex(LOCATION_ID);

        for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()){
            result = result + c.getString(iRow) + " " + c.getString(iName) + " " + "\n";
        }
        return result;
    }
}

// This code reads from the DB, this is just some very hacked together code so excuse it, it also works when used on other tables

public void getData(){
    boolean didItWork = true;
    try {       
        Location loc = new Location(this);
        loc.open();
        String data = loc.getName(0);
        loc.close();

        Dialog t = new Dialog(this);
        t.setTitle("get" + data);
        t.show();


    } catch (Exception e) {

        didItWork = false;
        String error = e.toString();
        Dialog d = new Dialog(this);
        d.setTitle("Dang it!");
        TextView tv = new TextView(this);
        tv.setText(error);
        d.setContentView(tv);
        d.show();
    } finally {
        if (didItWork) {
            Dialog d = new Dialog(this);
            d.setTitle("Heck Yea!");
            TextView tv = new TextView(this);
            tv.setText("Success");
            d.setContentView(tv);
            d.show();
            //entry.close();
        }
    }
}