This week's book giveaway is in the Mac OS forum. We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line! See this thread for details.
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 ]
Joined: Mar 20, 2000
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
John Carnell<br />Principal Architect<br /> <br />Netchange, LLC<br />1161 HillCrest Heights<br />Green Bay, WI 54313<br /> <br />email@example.com<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>