Dirk Robbes [https://community.jboss.org/people/underflyer] created the discussion
"EJB & PostgreSQL FK?" To view the discussion, visit: https://community.jboss.org/message/745268#745268 -------------------------------------------------------------- Hi everyone, im trying to deploy my EJB.jar on my new JBOSS 7.1.1. Well the deploy of the EJB-Container works like a charm. All Tables have been created, correctly. But I am unable to insert any Data in any Table where @ManyToOne Annotations are declared. Example: Unidirectional ManyToOne public class A { private Integer id; @Id @GeneratedValue(stretegy=Generation.TYPE=Auto) public Integer getId(){ return id;} public void setId(Integer id){ this.id=id;} } public class B { private Integer id; @Id @GeneratedValue(stretegy=Generation.TYPE=Auto) public Integer getId(){ return id;} public void setId(Integer id){ this.id=id;} private A a; @ManyToOne @JoinColumn(name="a_id", nullable=false) public A getA() {return a;} public void setA(A a){ this.a=a;} } this code, creates in PostgresSQL two Tables with (a, b) with the corresponding Columns (a = id) (b = id, a_id) Additional there are "two" (not one) ForeignKey Constraints defined, in Table "b": - fk.... foreign key (a_id) references a (id) - fk.... foreign key (id) references a(id) the second FK-Constraint makes trouble: INSERT A (id=1) = OK! INSERT B (id=1, a_id=1) = OK! INSERT B (id=2, a_id=1) = ERROR !!!!!! DETAIL key (id) = 2 is not present in table "a" where is my fault? Thanks for Advice -------------------------------------------------------------- Reply to this message by going to Community [https://community.jboss.org/message/745268#745268] Start a new discussion in EJB3 at Community [https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2029]
_______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
