You could also disable foreign keys while DbUnit is inserting data. Just add "sessionVariables=FOREIGN_KEY_CHECKS=0" to your JDBC URL.
http://raibledesigns.com/rd/entry/dbunit_tip_turn_off_foreign Matt On 10/29/07, mschipperheyn <[EMAIL PROTECTED]> wrote: > > Right, ok. Hmm, getting a > Caused by: org.dbunit.DatabaseUnitException: > com.mysql.jdbc.exceptions.MySQLInte > grityConstraintViolationException: Cannot add or update a child row: a > foreign k > ey constraint fails (`compraventa/barrios`, CONSTRAINT `FK4F5D3CCEB9857FF2` > FORE > IGN KEY (`FK_CityId`) REFERENCES `cities` (`cityId`)) > > That's prob caused by the sample data -1 being inserted while there isn't a > City created yet. I'll try to appfuse:gen all those POJOs first to have some > coherent sample data. > > Cheers, > > Marc > > > > > > mraible wrote: > > > > In the core directory, you should run "mvn install", not "mvn > > appfuse:install". > > > > Matt > > > > On 10/29/07, mschipperheyn <[EMAIL PROTECTED]> wrote: > >> > >> Yes, completed without fail. However, I dont see any code generated in > >> the > >> core dir (I guess dont need that with universal stuff). Did see the > >> entries > >> in applicationContext.xml added. > >> > >> Marc > >> > >> D:\Java\Projects\CompraVenta\core>mvn appfuse:gen > >> [INFO] Scanning for projects... > >> [INFO] Searching repository for plugin with prefix: 'appfuse'. > >> [INFO] > >> ------------------------------------------------------------------------- > >> --- > >> [INFO] Building AppFuse Modular Application - Core > >> [INFO] task-segment: [appfuse:gen] > >> [INFO] > >> ------------------------------------------------------------------------- > >> --- > >> [INFO] Preparing appfuse:gen > >> [INFO] [aspectj:compile {execution: default}] > >> [INFO] [resources:resources] > >> [INFO] Using default encoding to copy filtered resources. > >> [INFO] [compiler:compile] > >> [INFO] Nothing to compile - all classes are up to date > >> [WARNING] POM for 'org.hibernate:jtidy:pom:r8-20060801:runtime' is > >> invalid. > >> It w > >> ill be ignored for artifact resolution. Reason: Parse error reading POM. > >> Reason: > >> TEXT must be immediately followed by END_TAG and not START_TAG > >> (position: > >> START > >> _TAG seen ...<licenses>\n\t\t\t<license>... @12:13) > >> [INFO] [appfuse:gen] > >> What is the name of your pojo (i.e. Person)?: Barrio > >> [INFO] Configuration XML file loaded: > >> D:\Java\Projects\CompraVenta\core\src\main > >> \resources\hibernate.cfg.xml > >> [INFO] Configuration XML file loaded: > >> D:\Java\Projects\CompraVenta\core\src\main > >> \resources\hibernate.cfg.xml > >> [INFO] src/main/resources/database.properties not found within the > >> project. > >> Tryi > >> ng absolute path. > >> [INFO] No hibernate properties file loaded. > >> [info] [AppFuse] Installing generated files (pattern: **/*.java)... > >> [info] [AppFuse] Installing sample data for DbUnit... > >> [info] [AppFuse] Installing Spring bean definitions... > >> [INFO] > >> ------------------------------------------------------------------------ > >> [INFO] BUILD SUCCESSFUL > >> [INFO] > >> ------------------------------------------------------------------------ > >> [INFO] Total time: 7 seconds > >> [INFO] Finished at: Mon Oct 29 17:09:08 CET 2007 > >> [INFO] Final Memory: 13M/23M > >> [INFO] > >> ------------------------------------------------------------------------ > >> > >> D:\Java\Projects\CompraVenta\core>mvn appfuse:install > >> [INFO] Scanning for projects... > >> [INFO] Searching repository for plugin with prefix: 'appfuse'. > >> [INFO] > >> ------------------------------------------------------------------------- > >> --- > >> [INFO] Building AppFuse Modular Application - Core > >> [INFO] task-segment: [appfuse:install] > >> [INFO] > >> ------------------------------------------------------------------------- > >> --- > >> [INFO] Preparing appfuse:install > >> [INFO] [aspectj:compile {execution: default}] > >> [INFO] [resources:resources] > >> [INFO] Using default encoding to copy filtered resources. > >> [INFO] [compiler:compile] > >> [INFO] Nothing to compile - all classes are up to date > >> [WARNING] POM for 'org.hibernate:jtidy:pom:r8-20060801:runtime' is > >> invalid. > >> It w > >> ill be ignored for artifact resolution. Reason: Parse error reading POM. > >> Reason: > >> TEXT must be immediately followed by END_TAG and not START_TAG > >> (position: > >> START > >> _TAG seen ...<licenses>\n\t\t\t<license>... @12:13) > >> [INFO] [appfuse:install] > >> What is the name of your pojo (i.e. Person)?: Barrio > >> [info] [AppFuse] Installing generated files (pattern: **/*.java)... > >> [info] [AppFuse] Installing sample data for DbUnit... > >> [info] [AppFuse] Installing Spring bean definitions... > >> [INFO] > >> ------------------------------------------------------------------------ > >> [INFO] BUILD SUCCESSFUL > >> [INFO] > >> ------------------------------------------------------------------------ > >> [INFO] Total time: 5 seconds > >> [INFO] Finished at: Mon Oct 29 17:09:27 CET 2007 > >> [INFO] Final Memory: 11M/23M > >> [INFO] > >> ------------------------------------------------------------------------ > >> -- > >> View this message in context: > >> http://www.nabble.com/app%3Agen--Unable-to-load-class-declared-as-mapping-class%3D%22xyz%22-in-the-configuration-tf4700458s2369.html#a13471891 > >> 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/app%3Agen--Unable-to-load-class-declared-as-mapping-class%3D%22xyz%22-in-the-configuration-tf4700458s2369.html#a13473471 > 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]
