weblogic下写clob的方法

答案：写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();

       }

上一个：JDBC学习笔记-jdbc性能优化
下一个：oracle之CLOB处理完整版