I have run into this problem and the ordering the data in sample-data.xml definitely works on the insert. My problem is that the tables can't be truncated or deleted because you can't control the order when CLEAN_INSERT runs. So I usually write a script that truncates/deletes the table data and then have it run right before the CLEAN_INSERT.
Rob Hills wrote: > > Hi Thomas, > > On 1 Oct 2007 at 9:54, Thomas Ramapuram wrote: > >> You usually have a problem with CLEAN_INSERT if you have some kind of >> recursive model. (ie. a table which has a relationship with itself). >> I havent found any workaround this. What I do is do not add this data >> to the sample data. The error I get is foreignKeyConstrain error. > > The other way to fix this is to re-order your sample data. AFAICT, the > data > is inserted in the database in the order it appears in sample-data.xml. > If you > make sure that parent table data is inserted before the data in its > related > children, your CLEAN_INSERT should run smoothly. > > The only downside to this approach is that you need to recheck sample- > data.xml any time you run an appfuse:gen task as I've found that it > usually > deletes the data for the associated DB table in sample-data.xml and adds > it > again to the end of that file, hence potentially breaking foreign key > constraints. > > HTH, > Rob Hills > Waikiki, Western Australia > Mobile +61 (412) 904-357 > Fax: +61 (8) 9529-2137 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > -- View this message in context: http://www.nabble.com/Problem-with-CLEAN_INSERT-tf4540004s2369.html#a12981713 Sent from the AppFuse - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
