MyBatis查询CLOB类型数据异常处理

报错

Could not write JSON: No serializer found for class oracle.jdbc.driver.OracleClobReader and no properties discovered to create BeanSerializer

 解决方案（将Clob转String）

// Clob类型 转String
	public String ClobToString(Clob clob) throws SQLException, IOException {
		String ret = "";
		Reader read = clob.getCharacterStream();
		BufferedReader br = new BufferedReader(read);
		String s = br.readLine();
		StringBuffer sb = new StringBuffer();
		while (s != null) {
			sb.append(s);
			s = br.readLine();
		}
		ret = sb.toString();
		if (br != null) {
			br.close();
		}
		if (read != null) {
			read.close();
		}
		return ret;
	}