Multipe Queries and ResultSets stored in one ArrayList

Question

I'm trying to store multiple ResultSets into one ArrayList. I'm catching an error on my while-loop at the first ResultSet.

Here's my code:

List<String> target= new ArrayList<String>();

try{
    wpCall.Connect("database");
            wpCall.ResetParms();
                sql = "SELECT column";
                sql += "FROM table";
                sql += "WHERE col2= 'val1'";
                sql += "AND col3= 'field2'";
            ResultSet rst1 = wpCall.GetResult(sql);
                while(rst1.next()) {
                    String values= rst1.getString(1);
                    target.add(values);
                }
    wpCall.Connect("database");
            wpCall.ResetParms();
                sql = "SELECT column";
                sql += "FROM table";
                sql += "WHERE col2= 'val2'";
                sql += "AND col3= 'field2'";
            ResultSet rst1 = wpCall.GetResult(sql);
                while(rst1.next()) {
                    String values2= rst1.getString(1);
                    target.add(values2);
                }
  } 
  finally { 
     System.out.print("Values: " + Target+ "\n");
}

Thanks for any help!

Answer 1

Your SQL is malformed, you have missed some spaces:

Your first statement should be:

sql = "SELECT column";
sql += " FROM table";
sql += " WHERE col2= 'val1'";
sql += " AND col3= 'field2'";

And your second statement should be:

sql = "SELECT column";
sql += " FROM table";
sql += " WHERE col2= 'val2'";
sql += " AND col3= 'field2'";