Oracle中json转CLOB
·
项目开发中将mysql开发的系统转成oracle开发时，出现CLOB转型的错误
抛出的异常
[org.springframework.web.servlet.mvc.method.annotation.ExceptionHandlerExceptionResolver] - Resolving exception from handler [public com.waysoft.common.ResponseData com.waysoft.modules.common.query.controller.CommonController.getPageList(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)]: org.springframework.http.converter.HttpMessageNotWritableException: Could not write JSON: No serializer found for class oracle.jdbc.driver.OracleClobReader and no properties discovered to create BeanSerializer (to avoid exception, disable SerializationFeature.FAIL_ON_EMPTY_BEANS) ) (through reference chain: com.waysoft.common.ResponseData["data"]->com.waysoft.common.mybitis.page.Page["list"]->java.util.ArrayList[0]->java.util.HashMap["operate_url_params_"]->com.alibaba.druid.proxy.jdbc.ClobProxyImpl["characterStream"]); nested exception is com.fasterxml.jackson.databind.JsonMappingException: No serializer found for class oracle.jdbc.driver.OracleClobReader and no properties discovered to create BeanSerializer (to avoid exception, disable SerializationFeature.FAIL_ON_EMPTY_BEANS) ) (through reference chain: com.waysoft.common.ResponseData["data"]->com.waysoft.common.mybitis.page.Page["list"]->java.util.ArrayList[0]->java.util.HashMap["operate_url_params_"]->com.alibaba.druid.proxy.jdbc.ClobProxyImpl["characterStream"])
解决方案
public Page getPageList(String sqlId,Page page,Map<String,Object> map) throws SQLException {
map.put("page", page);
List<Map<String,Object>> list=getSqlSession().selectList(sqlId, map);
for(Map<String,Object> data:list){
for (String key : data.keySet()) {
if (data.get(key) instanceof Clob){
Clob clob = (Clob) data.get(key);
data.put(key, clob.getSubString((long)1,(int)clob.length()));
}
}
}
page.setList(list);
return page;
}
有喜欢的朋友可以关注下头条号《老徐聊技术》
AtomGit 是由开放原子开源基金会联合 CSDN 等生态伙伴共同推出的新一代开源与人工智能协作平台。平台坚持“开放、中立、公益”的理念，把代码托管、模型共享、数据集托管、智能体开发体验和算力服务整合在一起，为开发者提供从开发、训练到部署的一站式体验。
更多推荐
1
0- 0
已为社区贡献3条内容
所有评论(0)