报错:Serialized class oracle.jdbc.driver.T4CConnection must implement java.io.Serializable 将NCLOB类型转为字符串

报错如下:

返回的数据如下:businessScope=oracle.sql.NCLOB@7f40c46, 

原因:数据库中字段BUSINESS_SCOPE类型为NCLOB。

解决办法:通过系统的dbms_lob.substr(字段,长度,起始位置)方法将clob转换为varchar2类型

select dbms_lob.substr(a.BUSINESS_SCOPE) as "businessScope" from t_entity a
原文地址:https://www.cnblogs.com/zwh0910/p/15543786.html