[jboss-user] [EJB 3.0] - Foreign key error

[neisann]

Hi,

Thank you genman with the help with the sequence. I'm now with another error.

I need an sequence for each table so I changed my code according to your information and worked with the sequence but now I'm getting an error with the foreign key. I have two entity beans Person and Address both of them with the key being generated by two different sequences: person_seq and address_seq. Person has an foreign key that references the field "id" of the Address table.
In the Person ejb I have:


  | @Entity
  | @SequenceGenerator(name = "PERSON_SEQ", sequenceName = "PERSON_SEQ")
  | 
  | @Id
  | @GeneratedValue(strategy=GenerationType.AUTO, generator = "PERSON_SEQ")	
  |   public int getId() {
  |     return id;
  |   }
  | 
  | @ManyToOne(cascade=CascadeType.ALL)
  | @JoinColumn(name="addressId", referencedColumnName="id")
  |   public Address getAddress() {
  |     return address;
  |   }
  | 

In the Address ejb I have:


  | @Entity
  | @SequenceGenerator(name = "ADDRESS_SEQ", sequenceName = "ADDRESS_SEQ")
  | 
  | @Id
  | @GeneratedValue(strategy=GenerationType.AUTO, generator = "ADDRESS_SEQ")
  |   public int getId() {
  |     return id;
  |   }
  | 

Both tables are empty and I'm trying to add an register in the table Person and Address but I'm getting the following error:

ORA-02291: integrity constraint (ADM.FK_ADDRESS) violated - parent key not found

I'm getting some warns when I start JBOSS:

"14:32:28,570 WARN  [Ejb3Configuration] Persistence provider caller does not implements the EJB3 spec correctly. PersistenceUnitInfo.getNewTempClassLoader() is null."

"14:32:28,898 WARN  [AnnotationBinder] Hibernate does not support SequenceGenerator.initialValue()"

Do you think these warns have to do with the error message? I'm using Oracle as database.

Thank you.

Nei

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4073675#4073675

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4073675