Statement stm=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);

when I am declaring statement as above shown. then jsp page showing errors that ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY are undefined variables. how to solve this problems. please send a mail to sngolla at rediffmail dot com.

I know it may sound stupid, but you may wanna check if you have the
import java.sql.*;

and then later you can check that the ResultSet you are trying to obtain is scrollable through the following line of code:

  int type = rs.getType();

The variable type will be one of the following:

  1003 to indicate ResultSet.TYPE_FORWARD_ONLY
  1004 to indicate ResultSet.TYPE_SCROLL_INSENSITIVE
  1005 to indicate ResultSet.TYPE_SCROLL_SENSITIVE

Hope this helps,
Nicky

Thank you Mr.Nicky Eshkenazi for your response. In jsp ,

int test=rs.getType();

when I am executing the above statement then it is displaying that rs.getType() method is not available in ResultSet interface.

what will be the problem.

Thank you.
sreeman

Hi,

If you are using JDBC 2.0 u can use Scrollable ResultSet.
Check which version of JDBC u are using ?

Savitha