Search code examples
oraclespring-bootspring-mybatis

Mybatis, retrieve oracle field stored as CLOB spring boot

I have a user stored in oracle DB and one of the fields is stored as a CLOB(a simple Json {"profile": "man"}). I am using Mybatis and i try to retrieve the value. So i am having:

 <resultMap id=userResults>
   <property="details" column="DETAILS" jdbcType="CLOB" 
    javaType="String" 
    typeHandler="org.apache.ibatis.type.ClobTypeHandler"
 </resultMap>

and in the POJO: the field details as a String with getter and setter.

class User{
private String name;
private String surname;
private String details;

//getters + setters
}

But nothing mapped in the end, even though the row exists in the DB. The query is:

 Select * FROM USER Where USER.id = #{id}

Any recommendations?

Solution

  • After some conversation on comments it turns out that the problem was the Oracle JDBC Driver after suggesting it and OP upgrading it He was able to make it work.