WrappedResultSet gotcha in 3.2.4
I'm posting this as an FYI for those migrating from prior 3.2.x version to the latest 3.2.4 version of JBoss.
The ResultSet class returned from a Statement.executeQuery() (and any other JDBC call) call is now a org.jboss.resource.adapter.jdbc.WrappedResultSet class type and not the ResultSet class type that the vendor's JDBC driver would typically return.
The gotcha is that if you need to have the actual ResultSet class from your JDBC driver in order to use vendor specific methods that are not found in the ResultSet interface, you can no longer simply cast the ResultSet to your JDBC vendor's ResultSet class if you obtain that connection via the JBoss connection pools.
For example, in order to fully access BLOB/CLOB fields in Sybase, one must do the following:
SybResultSet rs = (SybResultSet) stmt.executeQuery(sql.toString());
if (rs != null && rs.next()) {
TextPointer tp = rs.getSybTextPointer("clob_field");
tp.sendData(bytes, 0, bytes.length, false);
}
...
The above code no longer works in 3.2.4 since the JBoss specific WrappedResultSet is now returned. If you attempt to cast the WrappedResultSet to your vendor's ResultSet, you will get a ClassCastException.
It did work fine in 3.2.3 and I presume earlier versions because the actual vendor's ResultSet class was returned. I confirmed this in 3.2.3 by simply viewing the result of a rs.getClass().getName().
Luckily, Adrian, the author of the WrappedResultSet, was wise enough to allow us mere mortals access to the underlying ResultSet as shown below.
WrappedResultSet wrs = (WrappedResultSet) stmt.executeQuery(sql.toString());
SybResultSet rs = (SybResultSet) wrs.getUnderlyingResultSet();
if (rs != null && rs.next()) {
TextPointer tp = rs.getSybTextPointer("clob_field");
tp.sendData(bytes, 0, bytes.length, false);
}
...
While the above code does work, I am a bit concerned about relying on the implementation of the JBoss specific WrappedResultSet. Plus, the JDBC code is no longer completely portable across app servers.
I looked at the code of the WrappedResultSet and for the most part it seems that it's function is to toggle between the 1.3 and 1.4 SDK versions where new accessor methods were added to the 1.4 version of the ResultSet interface.
