Grails/GORM lazy loading of CLOB field

Question

I am trying to make one field of my Grails domain class to be lazily-loaded. In fact this is a CLOB column in DB, but it mapped to String field in Grails domain class. So I've created following hibernate mapping for this class:

<hibernate-mapping>
<class name="MyClass" table="my_table">
    <id name="id" column="id">
        <generator  class="native"/>
    </id>       
    <property name="clobCol" type="materialized_clob" lazy="true"/>
    <property name="someOtherField" type="string"/>
</class>
</hibernate-mapping>

My domain class looks like following:

class MyClass {

    String someOtherField

    String clobCol

    static constraints = {
        clobCol(nullable: true)
    }
}

I am expecting that clobCol should be lazy when I am querying DB using DetachedCriteria. But in fact it is being eagerly-loaded. Is it possible to make field lazy in this way? If yes so what am I doing wrong? If no so what is the best way to make clobCol be lazy without lots of refactoring classes and existing queries?

Answer 1

I believe you can achieve this by declaring a property named fetchMode in your domain class that contains a map of property/fetch types

class MyClass {

    static fetchMode = [clobCol: 'lazy']

    ...
}