error: cannot find symbol resultset

Question

I am really stuck at this...I am trying to convert Result Set into string and this is my code :

QueryExecution qExec = QueryExecutionFactory.create(s, ds) ;
       ResultSet rs = qExec.execSelect() ;
       //String x=rs.toString();
       String[] arr = null;

        while (rs.next()) {
            String em = (String)rs.getString(0);
           arr = em.split("\n");
           for (int i =0; i < arr.length; i++){
              subjectoutput.setText(arr[i]); 
           }
       }

and it gives error:

JavaApplication2.java:137: error: incompatible types
            while (rs.next()) {
                          ^
  required: boolean
  found:    QuerySolution
JavaApplication2.java:138: error: cannot find symbol
                String em = (String)rs.getString(0);
                                      ^
  symbol:   method getString(int)
  location: variable rs of type ResultSet
2 errors

my query result is this:

    ----------------------------
| x                                           
================================================
| <<[e-mail]>> |
------------------------------------------------

Answer 1

It looks like you're trying to use ResultSet as if it were from JDBC. But you're using Jena ARQ here. This isn't a JDBC implementation and it doesn't follow that API. QueryExecution is here, and ResultSet is here.

For this ResultSet object, you should call hasNext() to see if there is another record, and next() to fetch the record. So your loop might look more like this:

while (rs.hasNext()) {
    QuerySolution qs = rs.next();
    ... // Do something with qs
}

ResultSet.getString(int) is a JDBC function, and there's no such function on either ResultSet or QuerySolution, so I couldn't tell you exactly how to get the information that you want out of the result set.