MS-SQL Data ResultSet Problem

[Anand Karia]

I am using netbeans ide with MS-SQL 2000 Server. My problem is that

When I am using

String sql = "select * from product";
Statement st = cnn.createStatement();
ResultSet rs = st.executeQuery(sql);
if(rs.next()==false){
lblShow.setText("No record Found");
}
else{
 rs.last();  //Here ERROR Message occurs
 displayRecord1();
}

Data is shown on command prompt but when i am using rs.first() or rs.Previous() or rs.last() then it shows error on it
com.microsoft.sqlserver.jdbc.SQLServerException: The requested operation is not supported on forward only result sets.

BUT WHEN I CHANGE THE STATEMENT LIKE

Statement st = cnn.createStatement(ResultSet.TYPESCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);

com.microsoft.sqlserver.jdbc.SQLServerException: The TDS protocol stream is not valid.

OR WHEN I CHANGE THE STATEMENT LIKE

Statement st = cnn.createStatement(ResultSet.TYPESCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

com.microsoft.sqlserver.jdbc.SQLServerException: The TDS protocol stream is not valid.

OR WHEN I CHANGE THE STATEMENT LIKE

Statement st = cnn.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_READ_ONLY);

com.microsoft.sqlserver.jdbc.SQLServerException: The requested operation is not supported on forward only result sets.

OR WHEN I CHANGE THE STATEMENT LIKE

Statement st = cnn.createStatement(ResultSet.TYPE_FORWARD_ONLY,ResultSet.CONCUR_UPDATABLE);

com.microsoft.sqlserver.jdbc.SQLServerException: The TDS protocol stream is not valid.

LAST but not least: While using INSERT,UPDATE,DELETE cnn.createStatement() is working perfectly.

I am using following jar files
sqljdbc4.jar
jtds-1.2.5.jar

I do not know where i make mistake? Can anybody please help me out in solving this problem.

[Paul Sturrock]

I am using following jar files
sqljdbc4.jar
jtds-1.2.5.jar

That is two distinct driver implementations. Your errors suggest you are not using jTDS, so I would remove that from your classpath, or change to using jTDS and drop sqljdbc4.jar. jTDS supports forward only result sets.

[Anand Karia]

Dear Paul Sturrock

Thank you very much. I remove sqljdbc4.jar file and use only jTDS.1.2.5.jar file and make a connection from it. It work perfectly.

Now my application can easily be executed for Postgresql, MS-SQL without making any single code change.

Thanks you very much.