Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Help with updating CLOB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Help with updating CLOB" Watch "Help with updating CLOB" New topic
Author

Help with updating CLOB

Vladan Radovanovic
Ranch Hand

Joined: Mar 20, 2000
Posts: 216
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
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

Joined: Sep 27, 2002
Posts: 71
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


John Carnell<br />Principal Architect<br /> <br />Netchange, LLC<br />1161 HillCrest Heights<br />Green Bay, WI 54313<br /> <br />john.carnell@netchange.us<br /> <br /> <br />Author of <a href="http://www.amazon.com/exec/obidos/ASIN/159059228X/ref=jranch-20" target="_blank" rel="nofollow">Pro Jakarta Struts, Second Edition</a>
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Help with updating CLOB
 
Similar Threads
Use two connections individually for a clob selection and updating statment.
an example to insert data into Oracle Clob
Question on update CLOB column when the column value is null
BLOB
Problem in inserting large file in CLOB in Oracle