Customize the column name for embedded fields

Question

I have a Foo domain class with an embedded Bar field:

class Foo {
  Bar bar

  static embedded=['bar']
}

class Bar {
  String ham
}

Which gives me a foo table with a bar_ham column.

The problem is that my Foo.bar and Bar.ham have much longer names in reality, so the column ends up having more than 30 characters in length, which Oracle doesn't like.

So how can I customize the name of the embedded column?

I've tried something like the following, but it didn't work:

class Foo {
  Bar bar

  static embedded=['bar']

  static mapping={
    bar column:'b'
  }
}

OverZealous · Accepted Answer · 2012-01-01 21:23:37Z

1

Specify the customized column name on the Bar class, like so:

class Foo {
  Bar bar

  static embedded=['bar']

}


class Bar {
    String bazIsReallyLong

    static mapping = {
        bazIsReallyLong column:'baz'
    }
}

Tested on Grails 2.0, this created a Foo table with column names ID, VERSION, and BAZ.

This will affect all tables containing Baz, however.

Updates based on comment

Another options is to change the name of the mapped class to something shorter, like this:

class Foo {
  Bar b

  static embedded=['b']

}


class Bar {
    String bazIsReallyLong
}

This creates the column B_BAZ_IS_REALLY_LONG, which at least helps.

I don't see any options for explicitly renaming embedded columns otherwise.

edited Jan 1, 2012 at 21:23

answered Dec 31, 2011 at 18:30

OverZealous

39.6k15 gold badges100 silver badges101 bronze badges

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

3 Comments

Sebastien Over a year ago

Yes, I know this but I only want to customize the column name for the embedding domain class. Plus, what happens if the embedded class is embedded twice?

OverZealous Over a year ago

Well, I think you are SOL. The only solution I can come up with is to map bar to a shorter name on Foo. See updates above.

OverZealous Over a year ago

Also, I agree about the issue with embedding the column twice. I would consider that a bug - the column really should map to table_customname.

Dhananjay · Accepted Answer · 2011-12-29 15:34:55Z

0

Please have a look @

@AttributeOverride

section 2.2.2.4.

answered Dec 29, 2011 at 15:34

Dhananjay

4,0052 gold badges33 silver badges45 bronze badges

1 Comment

Sebastien Over a year ago

I just tried but I'm using GORM, not JPA annotations so I suspected it wouldn't work.

Collectives™ on Stack Overflow

Customize the column name for embedded fields

2 Answers 2

Updates based on comment

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Updates based on comment

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related