读取clob时报错,求救
我用下面的方法读取clob时报错,
sql = "select big from web_test where id=1";
pstmt = conn.prepareStatement(sql);
rs = pstmt.executeQuery();
if(rs.next()){
Reader clob=((oracle.sql.CLOB)rs.getClob(1)).getCharacterStream();
//
BufferedReader in = new BufferedReader(clob);
StringBuffer sb = new StringBuffer();
String read = in.readLine();
while (!read.equals("")){
sb.append(read);
read=in.readLine();
}
in.close();
System.out.println(sb.toString());
java.io.IOException: 类型长度大于最大值
at oracle.jdbc.dbaccess.DBError.SQLToIOException(DBError.java:716)
at oracle.jdbc.driver.OracleClobReader.needChars(OracleClobReader.java:222)
at oracle.jdbc.driver.OracleClobReader.read(OracleClobReader.java:163)
at java.io.BufferedReader.fill(BufferedReader.java:136)
at java.io.BufferedReader.readLine(BufferedReader.java:299)
at java.io.BufferedReader.readLine(BufferedReader.java:362)
at miscellaneous.ClobTest.readClob(ClobTest.java:64)
at miscellaneous.ClobTest.main(ClobTest.java:87)
我搜索了一下论坛,已经有不少帖子问过类似的问题但都没有答案,现在我也遇到了,请高人解决以下。谢谢。