ROO: how to create composit primary key in Entity

[pxp123]

Hi,

What can I do if I need to create entity for
a table in production DB (Oracle 10g) with composite primary key.

For example:

CREATE TABLE TACCOUNT
(
  BRANCHID     NUMBER(3)                        NOT NULL,
  ACC          VARCHAR2(18 BYTE)                NOT NULL,
  DATE_OPEN    DATE                             NOT NULL,
  DATE_CLOSE   DATE,
  NOTE         VARCHAR2(38 BYTE)
);
CREATE UNIQUE INDEX PK_TACCOUNT ON TACCOUNT
(BRANCHID, ACC);

I don't want to change the structure of this table.

Is it possible to create an "id" field using roo commands?

I use Spring Roo 1.0.2.RELEASE [rev 638]

Paul

[Nils Schmidt]

Hi,

there seem to be no support for composite primary keys in Roo 1.0.x.

As you can see in Roo-505 there is some development going on to support composite keys in the future.

I have created the following example script for the current development build of Roo (not the release version):

// Spring Roo ENGINEERING BUILD [rev unknown] log opened at 2010-05-07 14:48:41
project --topLevelPackage de.schmidtsoftware.rooquickhacks
persistence setup --provider HIBERNATE --database MYSQL 
entity --class de.schmidtsoftware.rooquickhacks.domain.Node --testAutomatically
field string --fieldName color --notNull 
entity --class de.schmidtsoftware.rooquickhacks.domain.Edge --identifierType EdgeId --testAutomatically
field string --fieldName color --notNull
field reference --fieldName fromNode --type de.schmidtsoftware.rooquickhacks.domain.Node --class de.schmidtsoftware.rooquickhacks.domain.EdgeId
field reference --fieldName toNode --type de.schmidtsoftware.rooquickhacks.domain.Node --class de.schmidtsoftware.rooquickhacks.domain.EdgeId
// [failed] controller all --package de.schmidtsoftware.rooquickhacks.web
perform eclipse

The script will create a node class (with color field and id field) and an edge class (with color field and composite id field [fromNode, toNode]). This works fine for me, Java and ITD files look good. The tables as well, as you can see in the screenshot.



Nevertheless there seem to be some problems with the generated integration tests. Furthermore, I was not able to create the web controllers for this project. I guess either you, me or somebody else need to have a closer look on that, but it should be a good starting point for you.

[lifang]

Anyone has resolved this issue in Roo 1.1.4 i am using roo for a big project where there is a lot of primary keys and foreign one involved .?
any commands that can be used for that ? I have tried the @Id it doesn't work .

[Alan Stewart]

Composite keys are supported in 1.1.x. Use for example:

entity --class ~.domain.Foo --identifierType ~.domain.FooPK

Then add fields to the composite key class using the field command as normal

[lifang]

thanks for your help

[asajm]

about fields in composite key class, they have to be NOT NULL ?
or fields just only refer to other class without any specifications ?

[Alan Stewart]

From a data modelling perspective, a composite key would always be not null. This is from 15 years of Oracle and DB2 experience

[Karina]

I'm using key composite too and DBRE, everything works fine but when I put the option "show example" I get the following error:

"No Example found with this id."

and the row exists with this id.

[Karina]

Really do not understand the problem.

I need help. please.