Wednesday, 7 August 2013

Java SQL Resultset retrieval order is not correct

Java SQL Resultset retrieval order is not correct

Hi I have the following three row in my table say tb1
key time id rowid
X 11:40 1 1
Y 4:50 1 2
Z 6:48 1 2
No I am using JDBC to get records and iterating over resultset as shown
below:
rs = statement.executeQuery("select * from tb1")
ResultSetMetaData md = rs.getMetaData();
int cols = md.getColumnCount();
while(rs.next())
{
for(int i = 1; i <= cols ; i++)
{
System.out.println("col name " + md.getColumnName(i));
System.out.println("col name " + rs.getObject(i));
}
}
When I execute the above code strangely it always prints second row first
and then first row and then third row. In short resultset data retrieval
is not in order. I dont understand why? Please guide. thanks in advance.

No comments:

Post a Comment