Search code examples
javajdbc

Java SQL resultset retrieval order is not correct

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

Now 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. Why is this?

Solution

  • You have not specified an "order by" clause. In general, databases are not required to return rows in any order unless an "order by" clause is specified. Add an order by clause to your select statement.