executeQuery returning empty resultSet

See more:

Java

Hi Everyone,

I have a loop where by using statement.executeQuery() a query is executed 2 times.For first time query is executed successfully but second time it returns empty resultSet.If I run the query at backend(Oracle 11g) it returns correct result but not when executed from Java Application.the query is a simple SELECT statement.Please help

int size=0;
for(int i=0;i<2;i++){
    rs=stmt.executeQuery("SELECT Column1,Column2 FROM Table1,Table2 WHERE Table1.Column = Table2.Column");
   while(rs.next()){
      size++;
      String strValue = rs.getString(1);
   }
}

[Edit]Code block added[/Edit]