This week's book giveaway is in the OCPJP forum. We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line! See this thread for details.
Well, I am working on JDBC right now but many a times I get the following error "UnsupportedOperationException". When I use the following methods, I am getting the above mentioned exception. * con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); * rs.beforeFirst(); etc..... Pour some light on it. THANX.
I had the same problem when I used jdk1.2.2 When I compile with jdk1.3, I get the following error java.sql.SQLException: Result set type is TYPE_FORWARD_ONLY at sun.jdbc.odbc.JdbcOdbcResultSet.beforeFirst(JdbcOdbcResultSet.java:20 45) plz help thanks
Originally posted by Thomas Paul: It means that the JDBC driver you are using does not support the operation. You may wish to try to find a better driver that more fully supports JDBC 2.0 functionality.
sabera: 1. You did not create a scrollable resultset upon statement creation then tried to use a method that can only be used on a scrollable resultset. fix: Statement s = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); and if the above gives you a "feature not implemented" exception then read further. 2. the database driver you are using does not implement a scrollable resultset. So even though you specified that you wanted one in the statement creation, the driver ignored your request. Then when you try to use these features of scrollable resultsets, you get this error. You might want to update your driver or find a new driver that supports these features you want to use in your programs. available drivers: http://industry.java.sun.com/products/jdbc/drivers odbc drivers in general do not support a lot of the JDBC 2.x features.
[This message has been edited by Jamie Robertson (edited August 02, 2001).]
Respected Sir, I am using sql server 2000 on windows 2000 and jdbc odbc drivers i am getting the exception like.. java.lang.UnsupportedOperationException how to solve the problem without using type-4 drivers how to upgrade my jdbc odbc drivers to support my application is there any way to upgrade my type - 1 drivers itself to get solution pl mail me back thankyou yours suji