I'm using JDBC and the JDBC-ODBC to do some database work with JavaBeans and Servlets. I want to use some of the fetures of JDBC 2.0, in particular scrollable Resultsets. However, everytime I try and do this I get the error: java.lang.UnsupportedOperationException The code compiles fine using IBM Visual Age 3.5. One idea I have is that the Java library that's being used at runtime is different to that under which the classes are compiled. Is there any way of finding out at run time which version of Java and/or JDBC is being used? Additional info: IBM Visual Age 3.5 is my IDE, JRun 3.0 is my web server. The resultset I'm trying to do this with is returned from a CallableStatement call, which uses a SQL Server Stored Procedure. Any help would be appreciated. Thanks Steven
some jdbc-odbc drivers do not fully implement all features of the jdbc 2.0 ResultSet Interface. Usually this includes scrollable resultsets. Your problem may be the driver not able to implement this feature. Try to download the latest version of your driver(and check its documentation to see that it implements this feature) or change to a different driver if you need this feature. Jamie
eat bricks! HA! And here's another one! And a tiny ad!
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop