ResultSet to Array

[Srinivasa Maddi]

How can i convert a ResultSet to an array of String values. I tried the following

    
int i =1;
while(rs.next())
{
String[] options = rs.getString(i);
i++;
}
Getting the following compile error 
Module.java:286: incompatible types
found   : java.lang.String
required: java.lang.String[]
                            String[] options = rs.getString(i);
                                                           ^
1 error
 

[Shailesh Chandra]

What is the datatype of column, which you are expecting to retrieve as array ?

Shailesh

[Srinivasa Maddi]

String

[Shailesh Chandra]

I am not sure but probably you are looking for this.

int i = 0;
String[] options = new String[rs.getMetaData().getColumnCount()];
while (rs.next()) {
  options[i] = rs.getString(i);
  i++;
}

Shailesh

[steve souza]

'getString' returns a String and you are assigning it to an ayrray. You should allocate a String[] array for each and loop through it for the columns, assigning the string to the different elements of the array.

[Srinivasa Maddi]

Thank you all for responding

[Jack Bolton]

Shailesh Chandra wrote:I am not sure but probably you are looking for this.

int i = 0;
String[] options = new String[rs.getMetaData().getColumnCount()];
while (rs.next()) {
  options[i] = rs.getString(i);
  i++;
}

Shailesh

with this code, the options array has all the values from the resultset.

but if i do this:

for(int i=0;i<options.length;i++){
System.out.println(options[i]);
}

i got:

null
1
null

when in fact it should be the values from the database that the resultset had.

whats going on here?>