Grails: Setting the length of a NUMBER column?

Question

I'm trying to tell Grails to create columns of a specific length. This works great for strings, however, for columns of NUMBER type, no matter what I try it keeps creating the default NUMBER(10,0) size. I've tried:

static mapping {
  field(precision: 2)
}

I've also tried:

static mapping {
  field(size: 2)
}

Am I missing something? Is this possible?

Try using the `max` and `min` constraints instead. Something like `field(min: 0, max: 99)`. — grantmcconnaughey, Mar 14 '14 at 20:38

score 0 · Answer 1 · answered Mar 14 '14 at 19:19

0

static mapping = {
  field length: 2
}

You should have tried one last time with length. :-) Refer docs for details.

answered Mar 14 '14 at 19:19

dmahapatro

49,365
7
88
117

Unfortunately that doesn't work either (I probably tried it too, just forgot :)). It's still creating a NUMBER(10,0) column. – Harry Muscle Mar 14 '14 at 20:33
How are you testing it? – dmahapatro Mar 14 '14 at 20:40

score 0 · Answer 2 · answered Mar 15 '14 at 10:03

0

Try to use constraints in Grails. Example :

class User {
    static constraints = {
        age min: 18, max: 60
    }
}

Check out the official Grails document about constraints : http://grails.org/doc/latest/guide/single.html#constraints

answered Mar 15 '14 at 10:03

Phat H. VU

2,350
1
21
30

score 0 · Answer 3 · answered Jun 04 '18 at 10:45

0

  static mapping = {
       field column: 'field',sqlType: 'NUMBER(14,0)'
     }

Works when dealing with Oracle database.

Though the post is late it might be useful for future reference.

answered Jun 04 '18 at 10:45

sandeshg

1
3

Grails: Setting the length of a NUMBER column?

3 Answers3