weblogic下写clob的方法-JSP教程,数据库相关

写clob的代码片段：

string sqlstr = "update textinfo set content=empty_clob() where textinfokey=" + integer.tostring(textinfokey);

myconn.setautocommit(false);

java.sql.preparedstatement pstmt = myconn.preparestatement(sqlstr);

pstmt.executeupdate();

sqlstr = "select content from textinfo where textinfokey=" + integer.tostring(textinfokey) + " for update";

java.sql.statement st = myconn.createstatement();

java.sql.resultset rs = st.executequery(sqlstr);

java.sql.clob clob ;

if (rs.next()) {

clob = rs.getclob("content");

weblogic.jdbc.rmi.serialoracleclob cast1 =(weblogic.jdbc.rmi.serialoracleclob)clob;

weblogic.jdbc.rmi.internal.oracletclobimpl cast2 =(weblogic.jdbc.rmi.internal.oracletclobimpl)cast1.gettherealclob();

clob myclob = (oracle.sql.clob)cast2.gettherealclob();

java.io.writer out=myclob.getcharacteroutputstream();

out.write(content);

out.flush();

out.close();

}