scrollable ResultSet

[anirudh kumar]

I want to scroll the Record with rs.prevoius()so what can i do for this below in this code a sql "UnsupportedOpertationException" genreted in runtime

    try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:MyData");
stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
//stmt = con.createStatement( );
//System.out.println("Stmt Created");
//stmt.setFetchSize(25);
rs= stmt.executeQuery("Select * from Directory");
System.out.println("con created");
}catch(Exception e){System.out.println("Sql error :" +e);}
ENTER.addActionListener(this);
SAVE.addActionListener(this);
VIEW.addActionListener(this);
}

public void actionPerformed(ActionEvent ae) 
{
if(ae.getSource() == ENTER)
{
System.out.println("Enter button clicked");

try{

System.out.println(" In side Try of Enter button");
System.out.println("rs created inside ENTER button");
while (rs.previous())

{
System.out.println(rs.getString("NAME"));
System.out.println(rs.getString("PHONE"));
tNAME.setText(rs.getString("NAME"));
tPHONE.setText(rs.getString("PHONE"));
tNAME.setText(rs.getString(" "));
tPHONE.setText(rs.getString(" "));

}
}catch(Exception e){System.out.println("Error in  Enter botton" + e);}
}

[ Edited by Dave to format code and remove the ]
[This message has been edited by David O'Meara (edited December 10, 2001).]

[Shiva Kumar]

Hi,
May be the problem is in your JDBC Driver or in the DataBase. what DataBase you are using? Oracle, Access, MySQL are supporting this type of scrollable ResultSet with the Support of JDB driver, Please check your JDBC driver version or download the JDBC Driver(2.0 or 3.0) from the NET and update it.
I worked with Access, MySQL and Oracle with JDBC driver 3.0, the scrollable ResultSet worked fine.
Shiva.