CLOB 问题,在线急等!
boolean bAutoCommit = conn.getAutoCommit();
conn.setAutoCommit(false);
strSQL = "SELECT content FROM news WHERE id="+ id + " FOR UPDATE";
myRS = stmt.executeQuery(strSQL);
if(myRS.next())
{
Clob myClob = myRS.getClob(1);
//下一行报错:java.lang.ClassCastException
((oracle.sql.CLOB)myClob).putString(((oracle.sql.CLOB)myClob).length()+1, strContent);
}
myRS.close();
myRS = null;
conn.setAutoCommit(bAutoCommit);
报错信息:java.lang.ClassCastException
在WINDOWS2000+RESIN+连接池是正确的,但是在REDHAT LINUX+TOMCAT4+连接池就报错。
我读写CLOB是参考ORACLE上的资料写的,地址如下:
http://www.oracle.com/technology/sample_code/tech/java/sqlj_jdbc/files/advanced/LOBSample/LOBSample.java.html