Re: Can't cast ResultSetProxy to oracle.jdbc.driver.ResultSet using datasource

For what it's worth, Websphere uses proxy objects for most jdbc type objects, including ConnectionProxy, StatementProxy, ResultSetProxy, etc, but not for the data objects. The solution is to shift the casting from the resultSet to the clob, as follows:

oracle.sql.CLOB clobDB = (oracle.sql.CLOB)resultSet.getClob("Data");

Hope this helps.
  Joe Received on Fri May 03 2002 - 18:16:39 CDT