Help with updating CLOB

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); ) :

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
Ranch Hand

Joined: Mar 20, 2000
Posts: 216

posted Sep 28, 2002 12:21:00

0

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

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