一个奇怪的问题oracle大字段操作clob.getCharacterStream()访问出现连接关闭错误

估计是你的Clob包引用有问题。

public static String getCreateTabelSQL(String tableName, String owner) throws Exception{
        final StringBuffer FIND_CREATE_TABLE_SQL = new StringBuffer();
        FIND_CREATE_TABLE_SQL.append("Select Dbms_Metadata.Get_Ddl('TABLE', '");
        FIND_CREATE_TABLE_SQL.append(tableName);
        FIND_CREATE_TABLE_SQL.append("', '");
        FIND_CREATE_TABLE_SQL.append(owner);
        FIND_CREATE_TABLE_SQL.append("') From Dual");
        ResultSet rs = null;       
        oracle.sql.CLOB clob = null; 
        java.sql.PreparedStatement pstmt = dbUtil.getConnection().prepareStatement(FIND_CREATE_TABLE_SQL.toString());    
        rs= pstmt.executeQuery();
        if(rs.next()){       
            //rs.getClob(1)中参数1指的是HCONTENT字段索引，第一个字段从1开始而不是从0。       
            //也可以用字段名来取rs.getClob("HCONTENT")       
            clob = (oracle.sql.CLOB)rs.getClob(1);       
        }       
        return ClobToString(clob);
        
    }
    
    public static String ClobToString(oracle.sql.CLOB clob) {
        String reString = "";
        StringBuffer sb;
        try {
            Reader is = clob.getCharacterStream();// 得到流
            BufferedReader br = new BufferedReader(is);
            String s = br.readLine();
            sb = new StringBuffer();
            while (s != null) {// 执行循环将字符串全部取出付值给StringBuffer由StringBuffer转成STRING
                sb.append(s);
                s = br.readLine();
            }
            reString = sb.toString();
            System.out.println(reString);
        } catch (Exception e) {
            e.printStackTrace();
        }
        return reString;
    }

这段代码可以的。亲测