add to arrayList in resultSet

Hello Everyone:

My ResultSet has 1 column and 2 rows with string values (names) ABC and XYZ. I want to add these values in an arrayList, so I did the following. I am showing only the relevant code

int numberOfColumns = rsmd.getColumnCount();
while(rs.next())
{

multiElement.add(rs.getObject(numberOfColumns));

}

when I print the arrayList I see:
multiElement : [ABC]
multiElement : [ABC, XYZ]
multiElement : [ABC, XYZ, ABC]
multiElement : [ABC, XYZ, ABC, XYZ]

The correct output should be simply
multiElement : [ABC, XYZ]

How could I correct the output. Using multiElement.clear() in the while loop also did not help.

Thanks for your help!

How are you printing the ArrayList?

Within the while loop by using
System.out.println("multiElement : " + multiElement) after adding to multiElement

I have improved my output but still see names being appended multiple times. The problem is that the while loop executes for the number of rows it has, so the values keep getting appended. I don't know how to stop it after one iteration.

while(rs.next())
{

names = rs.getString("names")
multiElement.add(names)

}

this returns the output
multiElement: [ABC, XYZ]
multiElement: [ABC, XYZ, ABC, XYZ]

which is much better than before but needs to stop after the first iteration. How can I do that?

1 column and 2 rows?, why you have 4 data

. . col1 col2
row1 X Y
row2 A B

am i wrong?

i suggest to modify your sql statement... so that you can get 1 row data only,
but if you sure your always want first row of resultset, you may try

http://java.sun.com/javase/6/docs/ap...l#absolute(int)
or
use if statement instead of while loop

If your ResultSet really does have 1 column and 2 rows then I see no reason why the while loop wouldn't terminate in the right place. The problem is probably with your queries.

As long as we are all picking on you, don't use the metadata to determine which columns to retrieve from the ResultSet. Either hard-code the numbers, or hard-code the names. You are going to great lengths to always get the last column in the ResultSet.

Try simplifying your program temporarily. Instead of putting the results in a list, just use System.out.println to display them. That will help you see if you are getting good data back from your query.