 | Mailing List | | Home | | Forum Home | | JBoss - Java Application Server | | Tomcat - JSP/Servlet container | | Struts - A MVC web framework | | iText - An open source PDF Java Library | | JDOM - JDOM XML Parser | | JSP - A mailing list about Java Server Pages specification and reference | | J2EE - A mailing list for Java(tm) 2 Platform, Enterprise Edition | | J2EE Pattern - An interest list for Sun Java Center J2EE Pattern Catalog | | Servlet - A mailing list for discussion about Sun Microsystem's Java Servlet API Technology | |
Struts & Hibernate
|
|
|
| | | - Foreign key error | - Foreign key error 2007-08-13 - By neisann
Back
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:
| @(protected)
| @(protected)(name = "PERSON_SEQ", sequenceName = "PERSON_SEQ")
|
| @(protected)
| @(protected)(strategy=GenerationType.AUTO, generator = "PERSON_SEQ")
| public int getId() {
| return id;
| }
|
| @(protected)(cascade=CascadeType.ALL)
| @(protected)(name="addressId", referencedColumnName="id")
| public Address getAddress() {
| return address;
| }
|
In the Address ejb I have:
| @(protected)
| @(protected)(name = "ADDRESS_SEQ", sequenceName = "ADDRESS_SEQ")
|
| @(protected)
| @(protected)(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 (See http://ORA-02291.ora-code.com): 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
__ ____ ____ ____ ____ ____ ____ ____ ____ ____
jboss-user mailing list
jboss-user@(protected)
https://lists.jboss.org/mailman/listinfo/jboss-user
|
|
|
