Hi, again, all- I am writing a standalone app, using some of the Restlet client utilities for convenience. (This app is using Restlet 2.1 RC2, and Java 7.)
I'm trying to read some data from an Informix database (using JDBC IfxDriver v3.7). When I send my JDBC query, I get an exception from Informix indicating that the RowSet is TYPE_FORWARD_ONLY. The exception happens in RowSetRepresentation.create() when trying to populate the WebRowSet object. (CachedRowSet.populate() calls ResultSet.absolute().) I tracked down the location where the SQL statement appears to be created (JdbcClientHelper.handleSqlRequests()) and it looks like it's calling Connection.createStatement(), which does create a statement that returns a TYPE_FORWARD_ONLY ResultSet. (There's a different overload that creates different ResultSet types.) I don't see a way to get JdbcClientHelper to request a scrollable ResultSet (so the call to absolute() won't fail). Obviously this is working for lots of folks, so I'm not sure what I'm missing. (I used this library myself in a prior project, although that was an earlier version, and used Java 6 & MySQL.) I don't know if the issue I'm having is specific to the Informix driver, or if the CachedRowSet implementation changed in Java 7. Does anyone have any suggestions? -------------------------- John Wismar Alldata Technology 916-478-3296 ------------------------------------------------------ http://restlet.tigris.org/ds/viewMessage.do?dsForumId=4447&dsMessageId=2910224
