java读取db2的clob字段为什么是0条数据

Class.forName("COM.ibm.db2.jdbc.app.DB2Driver").newInstance();
String url = "jdbc:db2:sample";
Connection connection = DriverManager.getConnection(url, user, password);

connection.setAutoCommit(false);
PreparedStatement preparedStatement=connection.prepareStatement(sql);
ResultSet rs=preparedStatement.executeQuery();
Clob clob=rs.getClob(colName);
if(clob!=null)
{
Reader reader=((oracle.sql.CLOB)clob).getCharacterStream();
BufferedReader br=new BufferedReader(reader);
String value="";
String line="";
while((line=br.readLine())!=null)
{
value+=line+" ";
}

}

rs.close();
preparedStatement.close();

value就是java读取clob的值。

温馨提示：答案为网友推荐，仅供参考

当前网址：https://verywind.cn/ee/vvvy2vv2xr2e3y2rrjx.html