Column type in grails not working

Question

This is my model.

class Review {
String review
Date date
int numberOfComments
String status
static belongsTo = [game:Game, user:User]
static hasMany=[comment:Comment]
static mapping ={
    numberOfComments    defaultValue: "0"
    review type: 'text'
}

static constraints = {

}

when I inputted 400 character text it generated this error

I don't know why the review type: 'text' is not working. can someone help?

score 0 · Answer 1 · answered Dec 11 '15 at 10:23

0

Maybe you can use an sqlType instead like

class Email {

    String body

    static mapping = {
        body sqlType: "longtext"
    }

answered Dec 11 '15 at 10:23

Ricardo Umpierrez

768
2
11
24

score 0 · Answer 2 · answered Dec 11 '15 at 10:24

0

you can make it a blob type

static mapping = {
    review (type:’blob’)
}

Note type is default properties for Grails 2.0, if you use newer version of grails you should use sqlType.

Check it here: http://grails.github.io/grails-doc/latest/ref/Database%20Mapping/column.html

answered Dec 11 '15 at 10:24

Frederic Henri

51,761
10
113
139

It says Message: java.lang.String cannot be cast to java.sql.Blob – Red Viper Dec 11 '15 at 14:45

score 0 · Accepted Answer · edited May 23 '17 at 12:15

0

In fact grails GORM sometimes have problems with updating column types, especially if they contain any data. Try to delete selected column/table in database and restart application.

Ensure also that you have changed in conf/DataSource.groovy

dbCreate = "update"

to

dbCreate = "create-drop"

Edited: Firstly I didn't notice that you are using h2 db. Please check out this answer for text type in h2 database.

edited May 23 '17 at 12:15

Community

1
1

answered Dec 11 '15 at 13:08

Michal_Szulc

4,097
6
32
59

Do I really need to change it to create-drop? I don't wanna lose all I have in my database, What's the difference anyways? – Red Viper Dec 11 '15 at 15:21
in dev I use 'create-drop', in production I use 'update'. that's the easiest way to ensure that columns/fields have the type you want. – Michal_Szulc Dec 11 '15 at 15:29
so i change to create-drop then static mapping = { review type : 'clob' }? – Red Viper Dec 11 '15 at 15:31
first change to create-drop and don't change mapping. it's possible that h2 created this field as a regular varchar. if after restart it still dosn't work change mapping to clob. – Michal_Szulc Dec 11 '15 at 15:33
do you use h2 in production too ? you might get an issue if you use clob type when moving to your other env – Frederic Henri Dec 12 '15 at 20:43
what do you mean production? im stil on development – Red Viper Dec 13 '15 at 15:54
your code works... please look for differences between my and your project: https://github.com/majkelo/ReviewTest – Michal_Szulc Dec 18 '15 at 14:40

Column type in grails not working

3 Answers3

Linked