Kiran,
You have to look at the driver you are using.Scrollable result set must be
supported by the driver.In other words your jdbc driver must implement sun
jdbc 2.0 version.
Hope this helps
Srini
>From: Kiran Badhe <[EMAIL PROTECTED]>
>Reply-To: "A mailing list for discussion about Sun Microsystem's Java
> Servlet API Technology." <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Scrollable resultset
>Date: Thu, 11 May 2000 02:45:15 PDT
>
>Hi,
>
>I am a newbie in Java. I have written following code to use the scrollable
>resultset.When I run the compiled class file it gives me following error.
>
>Exception in thread "main" java.lang.UnsupportedOperationException at
>sun.jdbc.odbc.JdbcOdbcConnection.createStatement(JdbcOdbcConnection.java.1018)
>
>
>Does any body know how to make this feature work?
>
>Thanks.
>Kiran
>
>- My Code---
>
>import java.sql.*;
>import java.io.*;
>public class T1
>{
>public static void main(String[] args)
>throws SQLException,IOException,ClassNotFoundException
>{
>Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
>Connection conn =
>DriverManager.getConnection("jdbc:odbc:uat","works","works");
>
>Statement stmt;
>System.err.println("Connected.");
>//Statement stmt =
>conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
>stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
>ResultSet.CONCUR_READ_ONLY);
>ResultSet rs = stmt.executeQuery("SELECT * FROM TAB");
>System.err.println("Created");
>//PreparedStatement stmt = conn.prepareStatement("SELECT * FROM TAB");
>//ResultSet rs = stmt.executeQuery();
>
>rs.afterLast();
>while (rs.previous())
>{
>System.err.println("The Table name is " + rs.getString("TNAME"));
>}
>
>}
>}
>
>
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>___________________________________________________________________________
>To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
>of the message "signoff SERVLET-INTEREST".
>
>Archives: http://archives.java.sun.com/archives/servlet-interest.html
>Resources: http://java.sun.com/products/servlet/external-resources.html
>LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
