1 Reply Latest reply on Jan 23, 2014 7:32 AM by jaikiran

    ClassCastException: WrappedResultSetJDK6 cannot be cast to OracleResultSet

    ravipatil080

      Hi All,

       

      My environment details are :

       

      JBOSS EAP 6.1.0

      oracle 11g

      ojdbc6.jar

       

      I am trying to :

       

      String sql = "SELECT query ...";
      Statement stmt = ConnMan.getConnection("MyDS1").prepareStatement(sql);
      ResultSet rs = stmt.executeQuery();
      NativeJdbcExtractor njdbcExtractor = new NativeJdbcExtractor();
      OracleResultSet ors = (OracleResultSet) njdbcExtractor.getNativeResultSet(rs);              
      XMLType xml = null;
      try {
          Integer type = rs.getInt(1);
          OPAQUE opaque = ors.getOPAQUE(2);
          xml = XMLType.createXML(opaque);
      

       

       

      OracleResultSet ors = (OracleResultSet) njdbcExtractor.getNativeResultSet(rs); 

      Highlighted line is throwing this exception. whereas the exact code works fine in weblogic.

       

      Please help!

       

      Thanks,

      Ravi