I have 2 columns in a table that needs to be sequence generated, I have used @Id

Navajith K over 11 years ago

I have 2 columns in a table that needs to be sequence generated, I have used @Id and @GeneratedValue and @SequenceGenerator annotations for the first column in the xsd file and its working fine, however for the second column we have @GeneratedValue and @SequenceGenerator annotations, but the value is not sequentialy generated, its putting null values in this coulumns, Any thoughts?...

Discussion posts and replies are publicly visible

Parents

0 Aleksi White
Appian Employee
over 11 years ago

From the Oracle documentation: "Defines a primary key generator that may be referenced by name when a generator element is specified for the GeneratedValue annotation. A sequence generator may be specified on the entity class or on the primary key field or property"

It looks like the @SequenceGenerator can only be used with the primary key field
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Aleksi White
Appian Employee
over 11 years ago

From the Oracle documentation: "Defines a primary key generator that may be referenced by name when a generator element is specified for the GeneratedValue annotation. A sequence generator may be specified on the entity class or on the primary key field or property"

It looks like the @SequenceGenerator can only be used with the primary key field
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data