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("Sele
估计是你的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;
}
这段代码可以的。亲测
更多推荐
所有评论(0)