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;