When you load a JDBC driver, create a connection and then create a statement object with the following syntax,
If "con" is the connection object created.
Statement st= con.createStatement();
This is the default connection type we create. The default parameters internally passed with the create statement are
TYPE_SCROLL_FORWARD AND CONCUR_READ_ONLY
Hence you were uanble to use the JDBC2.0 API.
But to use JDBC2.0 API which provides you with a advantage of dual-moving and updatable result set,
you should pass these parameters in the createStatement method to work with JDBC2.0 API.
Please write your create statement as:
Statement st= con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
Now try any method in JDBC2.0 API, it works.
Also refer the link below for more information:
http://java.sun.com/docs/books/tutorial/jdbc/jdbc2dot0/cursor.html Hope the above information will be helpful to you. If you need further help, please contect me. I will help you out it I can.
[ June 17, 2003: Message edited by: Vamshi Krishna ]
