• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Help with updating CLOB

 
Vladan Radovanovic
Ranch Hand
Posts: 216
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 216
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Author
Ranch Hand
Posts: 71
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic