COOL! I modified the URL in pom.xml and it works!
mraible wrote: > > You can fix this by modifying (or appending to) the JDBC URL that DbUnit > uses: > > http://raibledesigns.com/rd/entry/dbunit_tip_turn_off_foreign > > Matt > > On 3/30/07, wnqq <[EMAIL PROTECTED]> wrote: >> >> Environment: Appfuse v2.0M4 + Hibernate + MySQL >> >> I encountered the following error while executing "mvn integration-test": >> >> =================================================== >> >> [INFO] [dbunit:operation {execution: test}] >> [INFO] >> ------------------------------------------------------------------------ >> [ERROR] BUILD ERROR >> [INFO] >> ------------------------------------------------------------------------ >> [INFO] Error executing database operation: CLEAN_INSERT >> >> Embedded error: >> com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: >> Cannot >> delete or update a parent row: a foreign key constraint fails >> (`myproject/tree`, CONSTRAINT `FK276B9E18FFF134` FOREIGN KEY >> (`PARENT_TREE_ID`) REFERENCES `tree` (`id`)) >> >> =================================================== >> >> During the integration-test: >> * first, it recreates the tables >> * second, it load the data from sample-data.xml, and then do some tests >> successfully >> * thirdly, it tries to load the data and the above error occurs. >> >> The following are extract of my code and sample data: >> >> Tree.java: >> =================================================== >> // Note: this Tree is actually a Node >> public class Tree extends BaseObject implements Serializable { >> >> private Long id; >> private String name; >> private Long parentTreeId; >> private Tree parentTree; >> private List <Tree> childTreeList; >> >> @Id >> @GeneratedValue(strategy = GenerationType.AUTO) >> public Long getId() { >> return this.id; >> } >> >> @Column(name = "PARENT_TREE_ID") >> public Long getParentTreeId() { >> return parentTreeId; >> } >> >> @ManyToOne >> @JoinColumn(name="PARENT_TREE_ID", nullable=true, updatable=false, >> insertable=false) >> public Tree getParentTree() { >> return parentTree; >> } >> >> @OneToMany(cascade=CascadeType.ALL) >> @LazyCollection(LazyCollectionOption.TRUE) >> @JoinColumn(name="PARENT_TREE_ID") >> public List <Tree> getChildTreeList() { >> return childTreeList; >> } >> =================================================== >> >> sample-data.xml: >> =================================================== >> <table name='tree'> >> <column>id</column> >> <column>name</column> >> <column>parent_tree_id</column> >> <row> >> <value>1</value> >> <value>Tree 1</value> >> <null/> >> </row> >> <row> >> <value>2</value> >> <value>Tree 2</value> >> <null/> >> </row> >> <row> >> <value>3</value> >> <value>Tree 1-1</value> >> <value>1</value> >> </row> >> <row> >> <value>4</value> >> <value>Tree 1-2</value> >> <value>1</value> >> </row> >> <row> >> <value>5</value> >> <value>Tree 1-1-1</value> >> <value>3</value> >> </row> >> <row> >> <value>6</value> >> <value>Tree 1-1-2</value> >> <value>3</value> >> </row> >> </table> >> =================================================== >> >> So my question is: how to avoid the FK constraint violation? >> * by modifying pom.xml ??? >> * by modifying annotation in Tree.java ??? >> * or by whatever ??? >> >> TIA >> -- >> View this message in context: >> http://www.nabble.com/How-to-avoid-FK-constraint-violation-during-integration-test--tf3491427s2369.html#a9750783 >> Sent from the AppFuse - User mailing list archive at Nabble.com. >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > > > -- > http://raibledesigns.com > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/How-to-avoid-FK-constraint-violation-during-integration-test--tf3491427s2369.html#a9757919 Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
