Help with updating CLOB

[Vladan Radovanovic]

Hi everyone. Maybe someone can help me. The issue here is that I am getting class cast exception when trying to update a clob. This code was working perfectly with OC4J but we have just switched to OC4J Release 2 and it's suddenly failing. The exception is:java.lang.ClassCastException: com.evermind.sql.OrclResultSet and it happens when I select the CLOB for update and try to cast ResultSet to Oracle Result Set (oracle.sql.CLOB clob = ((OracleResultSet)rset).getCLOB(1); ) :

StringBuffer clobQuery2 = new StringBuffer("select project from ");
            clobQuery2.append(TableConstant.TAB_FG_NARRATIVE_STA);
            clobQuery2.append(" where sys_app_id = " + sysAppId + " FOR UPDATE ");
rset = stmt.executeQuery(clobQuery2.toString());
            
if (rset.next()) {
oracle.sql.CLOB clob = ((OracleResultSet)rset).getCLOB(1);
if (clob != null) {
Writer outstream = clob.getCharacterOutputStream();
                    try{
                        outstream.write (projectDescription);
                        outstream.close();
                    } catch (IOException io){
                        io.printStackTrace();
                        throw new FEMAException(io.getMessage());
                    }
}
}

I will look for the solution but any pointer in the meantime is appreciated!
Thanks
[ September 27, 2002: Message edited by: Vladan Radovanovic ]

[Vladan Radovanovic]

Thanks to anyone that looked into this topic
Still don't know why is that line giving me trouble. Anyway, changed it to:
oracle.sql.CLOB clob = (oracle.sql.CLOB)rset.getObject (1);
and it works now

[John Carnell]

Hi Vladan,
The problem is not you. Oracle has never properly implemented the CLOB APIs for the Standard JDBC API. We ran into a similar problem at a client site and they only way we worked around it was to Oracle Classes (like you did) instead of the standard JDBC inteface.
Thanks,
John