clob oracle 连接_一个奇怪的问题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;

}

这段代码可以的。亲测