rownum is always 1 for all records!

[Ravi Tiruvaipati]

Hi Guys,
I am trying to access rownum (predefined column for all tables in Oracle) from java code and for some reason it is always 1 (number) for all the records in the resultset. Here is the query I am tring...

<font size="2">
import java.sql.*;
public class testcon{
public static void main(String[] args)
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc  :-o	  dbc:sd1db";
Connection con = DriverManager.getConnection(url, "user", "pwd");
Statement stmt = con.createStatement(
        ResultSet.TYPE_SCROLL_INSENSITIVE,
        ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt.executeQuery("select rownum, hours.* from hours where " + 
"posted='N' and post_type='P'"); 
while(rs.next()){
System.out.println(rs.getString("rownum")+"\t"+rs.getString("pdno"));
}
rs.close();
stmt.close();
con.close();
}catch(SQLException ex)
{
System.out.println("Not able to run the program...");
System.out.println(ex.getMessage());
}catch(Exception e)
{
System.out.println(e.getMessage());
}
}
}
</font>

When I try the same sql statement in oracle, it does returns unique values for rownum. I dont understand why the same query doesn't work when tried from java.
appreciate your help.
regards
ravi
[ September 30, 2003: Message edited by: Ravi Tiruvaipati ]

[Sainudheen Mydeen]

Hi Ravi
I think this is something to do with the ResultSet.
Replace

 Statement stmt = con.createStatement(        ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); 

to

Statement stmt = con.createStatement() 

and give a try
---------------
Sainudheen