用的JDBC是 ojdbc14.jar 这个包...奇怪了,我原先一样的代码,都可以跑的,不过原来用的是class12.zip
//convert CLOB into String
oracle.jdbc.driver.OracleResultSet ors = (oracle.jdbc.driver.OracleResultSet)rs;
oracle.sql.CLOB clobtmp = (oracle.sql.CLOB) ors.getClob("content");
if(clobtmp==null || clobtmp.length()==0)
{
System.out.println("Clob Object is null!");
contents="";
}else
{
//contents = clobtmp.getSubString((long)1,(int)clobtmp.length());
java.io.Reader is = clobtmp.getCharacterStream();
java.io.BufferedReader br = new java.io.BufferedReader(is);
try{
String s = br.readLine();
while (s != null) {
contents += s;
s = br.readLine();
}
}catch(Exception ex){
System.out.println(ex.toString());
}
}
//convert CLOB into String
oracle.jdbc.driver.OracleResultSet ors = (oracle.jdbc.driver.OracleResultSet)rs;
oracle.sql.CLOB clobtmp = (oracle.sql.CLOB) ors.getClob("content");
if(clobtmp==null || clobtmp.length()==0)
{
System.out.println("Clob Object is null!");
contents="";
}else
{
//contents = clobtmp.getSubString((long)1,(int)clobtmp.length());
java.io.Reader is = clobtmp.getCharacterStream();
java.io.BufferedReader br = new java.io.BufferedReader(is);
try{
String s = br.readLine();
while (s != null) {
contents += s;
s = br.readLine();
}
}catch(Exception ex){
System.out.println(ex.toString());
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货