xmlagg( ).getclobval() 返回值 clob,程序中将clob转为string
否则会报错:
Could not write content: 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: java.util.ArrayList[0]->java.util.HashMap[
解决方法:
List<Map<String, Object>> ListMap = new ArrayList<Map<String, Object>>();
ListMap= bsMapper.selectxxxxByxxxk();
for(Map<String, Object> data:ListMap){
for(String key:data.keySet()){
if(data.get(key) instanceof Clob){
Clob clob = (Clob) data.get(key);
try {
data.put(key, clob.getSubString((long)1,(int)clob.length()));
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
}
return ListMap;