Java Code Returning Null Resultset

Hi,

Here's a snippet of my java code :

Code:


boolean b = statementSQLServer.execute("select ROW_ID from S_INDUST where NAME='InWire'");

resultSetSQLServer = statementSQLServer.getResultSet();

System.out.println("b = " + b);
System.out.println("Are there any rows ?? " + resultSetSQLServer.next());



This code is returning null resultset.

But when I fire the same query directly into MS SQL, it is returning the corresponding rows.

I dont know where i'm going wrong. But just to make things more clearer, here's my connectivity code :

Code:


Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
connectionSQLServer = DriverManager.getConnection("jdbc:odbc:dm", "user", "pass");

statementSQLServer = connectionSQLServer.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);




Please help me out if possible....