7 Replies Latest reply on Apr 26, 2007 10:24 AM by Steve Harris

    seam-gen and mutiple foreign keys

    Niels Hoogeveen Newbie

      I have generated a project with seam-gen based on generate-entities. All works fine, except for the generation of the home interfaces. In one of my tables I have two foreign keys to the same table. In the home interface two references are created to the appropriate object, but with the same name (which of course doesn't compile).

      Here is a simplified example:
      Table 1

      CREATE TABLE test
      (
       id int4 NOT NULL DEFAULT nextval('test_id_seq'::regclass),
       name varchar,
       id_test2_1 int4,
       id_test2_2 int4,
       CONSTRAINT test_pkey PRIMARY KEY (id),
       CONSTRAINT test_id_test2_1_fkey FOREIGN KEY (id_test2_1)
       REFERENCES test2 (id) MATCH SIMPLE
       ON UPDATE NO ACTION ON DELETE NO ACTION,
       CONSTRAINT test_id_test2_2_fkey FOREIGN KEY (id_test2_2)
       REFERENCES test2 (id) MATCH SIMPLE
       ON UPDATE NO ACTION ON DELETE NO ACTION
      )
      

      Table2
      CREATE TABLE test2
      (
       id int4 NOT NULL DEFAULT nextval('test2_id_seq'::regclass),
       name varchar,
       CONSTRAINT test2_pkey PRIMARY KEY (id)
      )
      


      First Entity
      @Entity
      @Table(name = "test", schema = "public")
      public class Test implements java.io.Serializable {
      
       private int id;
       private Test2 test2ByIdTest22;
       private Test2 test2ByIdTest21;
       private String name;
      
       public Test() {
       }
      
       public Test(int id) {
       this.id = id;
       }
       public Test(int id, Test2 test2ByIdTest22, Test2 test2ByIdTest21,
       String name) {
       this.id = id;
       this.test2ByIdTest22 = test2ByIdTest22;
       this.test2ByIdTest21 = test2ByIdTest21;
       this.name = name;
       }
      
       @Id
       @Column(name = "id", unique = true, nullable = false)
       @NotNull
       public int getId() {
       return this.id;
       }
      
       public void setId(int id) {
       this.id = id;
       }
       @ManyToOne(fetch = FetchType.LAZY)
       @JoinColumn(name = "id_test2_2")
       public Test2 getTest2ByIdTest22() {
       return this.test2ByIdTest22;
       }
      
       public void setTest2ByIdTest22(Test2 test2ByIdTest22) {
       this.test2ByIdTest22 = test2ByIdTest22;
       }
       @ManyToOne(fetch = FetchType.LAZY)
       @JoinColumn(name = "id_test2_1")
       public Test2 getTest2ByIdTest21() {
       return this.test2ByIdTest21;
       }
      
       public void setTest2ByIdTest21(Test2 test2ByIdTest21) {
       this.test2ByIdTest21 = test2ByIdTest21;
       }
      
       @Column(name = "name", length = 0)
       @Length(max = 0)
       public String getName() {
       return this.name;
       }
      
       public void setName(String name) {
       this.name = name;
       }
      
      }
      


      second entity

      @Entity
      @Table(name = "test2", schema = "public")
      public class Test2 implements java.io.Serializable {
      
       private int id;
       private String name;
       private Set<Test> testsForIdTest21 = new HashSet<Test>(0);
       private Set<Test> testsForIdTest22 = new HashSet<Test>(0);
      
       public Test2() {
       }
      
       public Test2(int id) {
       this.id = id;
       }
       public Test2(int id, String name, Set<Test> testsForIdTest21,
       Set<Test> testsForIdTest22) {
       this.id = id;
       this.name = name;
       this.testsForIdTest21 = testsForIdTest21;
       this.testsForIdTest22 = testsForIdTest22;
       }
      
       @Id
       @Column(name = "id", unique = true, nullable = false)
       @NotNull
       public int getId() {
       return this.id;
       }
      
       public void setId(int id) {
       this.id = id;
       }
      
       @Column(name = "name", length = 0)
       @Length(max = 0)
       public String getName() {
       return this.name;
       }
      
       public void setName(String name) {
       this.name = name;
       }
       @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY, mappedBy = "test2ByIdTest21")
       public Set<Test> getTestsForIdTest21() {
       return this.testsForIdTest21;
       }
      
       public void setTestsForIdTest21(Set<Test> testsForIdTest21) {
       this.testsForIdTest21 = testsForIdTest21;
       }
       @OneToMany(cascade = CascadeType.ALL, fetch = FetchType.LAZY, mappedBy = "test2ByIdTest22")
       public Set<Test> getTestsForIdTest22() {
       return this.testsForIdTest22;
       }
      
       public void setTestsForIdTest22(Set<Test> testsForIdTest22) {
       this.testsForIdTest22 = testsForIdTest22;
       }
      
      }
      


      Home interface of first entity. Here we have two Test2Home references, both with the name test2Home.

      @Name("testHome")
      public class TestHome extends EntityHome<Test> {
      
       @In(create = true)
       Test2Home test2Home;
       @In(create = true)
       Test2Home test2Home;
      
       public void setTestId(Integer id) {
       setId(id);
       }
      
       public Integer getTestId() {
       return (Integer) getId();
       }
      
       @Override
       protected Test createInstance() {
       Test test = new Test();
       return test;
       }
      
       public void wire() {
       Test2 test2ByIdTest22 = test2Home.getDefinedInstance();
       if (test2ByIdTest22 != null) {
       getInstance().setTest2ByIdTest22(test2ByIdTest22);
       }
       Test2 test2ByIdTest21 = test2Home.getDefinedInstance();
       if (test2ByIdTest21 != null) {
       getInstance().setTest2ByIdTest21(test2ByIdTest21);
       }
       }
      
       public boolean isWired() {
       return true;
       }
      
       public Test getDefinedInstance() {
       return isIdDefined() ? getInstance() : null;
       }
      
      }
      



      BTW. I used the latest seam version from CVS.