Mapping Clob type in grails domain class with postgresql text type

Question

I am using the code is working for Derby, MySQL, Oracle but it's throwing error while using with PostgreSQL I'm getting error org.hibernet.exception.DataException could not execute the query.

I'm getting a solution to map text with String. But nowhere solution is for map text with Clob in domain class.

class Ticket {
    String id
    String name
    String customerId
    int severity
    Clob description
    String component
    Clob screenshot

    static mapping = {
        version false
        table 'MY_TICKET'
        id generator: 'assigned'
        columns {
            id column: 'TICKET_ID'
            customerId column: 'CUSTOMER_ID'
        }
    }

    static constraints = {
        id bindable: true
    }   
}

I followed the approach stackoverflow.com/questions/13420081/… so I'm able to see data. One place i'm making a call Ticket.get(id) which internally calling hibernate reflection for get calls and i'm getting the error saying org.springframework.orm.hibernate5.HibernateSystemException: Could not set Could not set field value [DESCRIPTION] value by reflection class Ticket.description. — Ajay Kumar Jaiswal
– Ajay Kumar Jaiswal, Commented Jan 5, 2019 at 9:08

Omsairam · Accepted Answer · 2019-01-09 16:08:38Z

1

You need to change the Clob type to String Type

class Ticket {
    String id
    String name
    String customerId
    int severity
    String description
    String component
    String screenshot

    static mapping = {
        version false
        table 'MY_TICKET'
        id generator: 'assigned'
        columns {
            id column: 'TICKET_ID'
            customerId column: 'CUSTOMER_ID'
        }
    }

    static constraints = {
        id bindable: true
    }  

     component sqltype:'text'
     screenshot sqltype:'text'
}

When we need to use a clob type in our mapping we always model it as a String with mapping type: 'text'.

answered Jan 9, 2019 at 16:08

Omsairam

3701 gold badge7 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ajay Kumar Jaiswal Over a year ago

Thanks, @Ajay it works for me. I saw sqltype and type what actually difference between these.

Collectives™ on Stack Overflow

Mapping Clob type in grails domain class with postgresql text type

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related