Hi Michael, Doing a generic EntitySorter would be great but my project is already delayed so I decided to create a specific EntitySorter for my project. I was able to create a static sorting for all my tables according to their foreign keys and now everything works :) This is information that should be highlighted on Cayenne's documentation, to help people on this area.
Regards Bruno On Fri, Nov 18, 2011 at 1:40 PM, Michael Gentry <mgen...@masslight.net>wrote: > Hi Bruno, > > The entity sorting in Cayenne is currently handled by the Ashwood > Entity Sorter. For the most part this works fine, but in some > situations (long graph cycles), it does not compute the correct > insertion order or fails to throw an exception to make it easier to > debug the problem. I had started writing my own Entity Sorter, but > have not finished it. The Ashwood version is fairly complex and hard > to debug, plus sometimes the sort order magically works out (the order > it calculates can vary from run-to-run), making it even harder to work > out. > > Any chance you can tar up your model and send it along? I won't be > able to look at it for a bit, but might have some time tonight or over > the weekend I could examine it. > > mrg > > > On Fri, Nov 18, 2011 at 8:15 AM, Bruno René Santos <brunor...@holos.pt> > wrote: > > Hi Michael, > > > > They are all AUTO INCREMENT from MySQL. But when I check the queryLogger > > this happens because Cayenne tries to insert Object A before Object B > when > > A has a foreign key to B and so B still has its OBjectId as TEMP.It seems > > to me Cayenne is failing to sort the objects for insertion correctly. Any > > way to check its insertion order or debug its algorithm? > > > > Regards > > Bruno > > > > On Fri, Nov 18, 2011 at 12:23 PM, Michael Gentry <mgen...@masslight.net > >wrote: > > > >> Hi Bruno, > >> > >> I believe that should be OK, so there must be something else going on. > >> How are you generating your PKs? > >> > >> Thanks, > >> > >> mrg > >> > >> > >> On Fri, Nov 18, 2011 at 5:15 AM, Bruno René Santos <brunor...@holos.pt> > >> wrote: > >> > Hi Michael, > >> > > >> > We dont have cyclic tables but we have some redundant paths like: > >> > > >> > A -> B -> C -> D > >> > > >> > A -> E -> C -> D > >> > > >> > Is this problematic? > >> > > >> > Regards > >> > Bruno > >> > > >> > On Thu, Nov 17, 2011 at 6:12 PM, Michael Gentry < > mgen...@masslight.net > >> >wrote: > >> > > >> >> Hi Bruno, > >> >> > >> >> The last time I saw this problem we had cyclic tables. Something > like: > >> >> > >> >> Table A -> Table B -> Table C -> Table D -> Table A > >> >> > >> >> Given this situation, Cayenne isn't able to properly do the inserts. > >> >> I *believe* this only applies to using autogenerated keys (are you > >> >> using MySQL?), though. > >> >> > >> >> mrg > >> >> > >> >> > >> >> On Thu, Nov 17, 2011 at 11:24 AM, Bruno René Santos < > brunor...@holos.pt > >> > > >> >> wrote: > >> >> > Hello all, > >> >> > > >> >> > I am getting this error on my application: > >> >> > > >> >> > org.apache.cayenne.CayenneRuntimeException: [v.3.0.1 Aug 25 2010 > >> >> 19:38:17] > >> >> > Can't extract a master key. Missing key (id), master ID > >> >> > (<ObjectId:Avaliacao, TEMP:00000C43DB4942B7>) > >> >> > > >> >> > I can see on the logs that Cayenne is trying to insert an object > that > >> >> needs > >> >> > a foreign key from another object that was not inserted yet... A > past > >> >> post > >> >> > suggested that this could be a problem on the Model Map but we > already > >> >> made > >> >> > it from scratch so we do not think that problem is there. My > >> application > >> >> > tries to clone a whole set of object into a new set objects (like > >> >> creating > >> >> > a complex structure from a template) and leaving a relationship of > >> object > >> >> > -> template between all objects that are part of the structure... > >> >> > > >> >> > Any one knows how can I check the rules on which order the objects > >> will > >> >> be > >> >> > inserted on the DB by the DataContext? Maybe somesort of check > >> function > >> >> > where I can see the current state of the Object Graph or something > >> like > >> >> > that? > >> >> > > >> >> > Regards > >> >> > Bruno Santos > >> >> > > >> >> > -- > >> >> > Bruno René Santos | brunor...@holos.pt | Gestor de Projectos | > >> Analista > >> >> | > >> >> > Programador | Investigador > >> >> > > >> >> > Holos - Soluções Avançadas em Tecnologias de Informação S.A. > >> >> > Parque de Ciência e Tecnologia de Almada/Setúbal . Edifício Madan > >> Parque > >> >> > Rua dos Inventores . Quinta da Torre . 2825 - 182 Caparica . > Portugal > >> >> > Phone: +351 210 438 686 . Fax: +351 210 438 687 . Web: > www.holos.pt > >> >> > > >> >> > This email and any files transmitted with it are confidential and > >> >> intended > >> >> > solely for the use of the individual or entity to whom they are > >> >> addressed. > >> >> > If you are not the intended recipient or the person responsible for > >> >> > delivering the email to the intended recipient, be advised that you > >> have > >> >> > received this email in error and that any use, dissemination, > >> forwarding, > >> >> > printing, or copying of this email is strictly prohibited. If you > have > >> >> > received this email in error please notify Bruno René Santos by > >> telephone > >> >> > on +351 210 438 686 > >> >> > > >> >> > >> >> > >> > > >> > > >> > -- > >> > Bruno René Santos | brunor...@holos.pt | Gestor de Projectos | > Analista > >> | > >> > Programador | Investigador > >> > > >> > Holos - Soluções Avançadas em Tecnologias de Informação S.A. > >> > Parque de Ciência e Tecnologia de Almada/Setúbal . Edifício Madan > Parque > >> > Rua dos Inventores . Quinta da Torre . 2825 - 182 Caparica . Portugal > >> > Phone: +351 210 438 686 . Fax: +351 210 438 687 . Web: www.holos.pt > >> > > >> > This email and any files transmitted with it are confidential and > >> intended > >> > solely for the use of the individual or entity to whom they are > >> addressed. > >> > If you are not the intended recipient or the person responsible for > >> > delivering the email to the intended recipient, be advised that you > have > >> > received this email in error and that any use, dissemination, > forwarding, > >> > printing, or copying of this email is strictly prohibited. If you have > >> > received this email in error please notify Bruno René Santos by > telephone > >> > on +351 210 438 686 > >> > > >> > >> > > > > > > -- > > Bruno René Santos | brunor...@holos.pt | Gestor de Projectos | Analista > | > > Programador | Investigador > > > > Holos - Soluções Avançadas em Tecnologias de Informação S.A. > > Parque de Ciência e Tecnologia de Almada/Setúbal . Edifício Madan Parque > > Rua dos Inventores . Quinta da Torre . 2825 - 182 Caparica . Portugal > > Phone: +351 210 438 686 . Fax: +351 210 438 687 . Web: www.holos.pt > > > > This email and any files transmitted with it are confidential and > intended > > solely for the use of the individual or entity to whom they are > addressed. > > If you are not the intended recipient or the person responsible for > > delivering the email to the intended recipient, be advised that you have > > received this email in error and that any use, dissemination, forwarding, > > printing, or copying of this email is strictly prohibited. If you have > > received this email in error please notify Bruno René Santos by telephone > > on +351 210 438 686 > > > > -- Bruno René Santos | brunor...@holos.pt | Gestor de Projectos | Analista | Programador | Investigador Holos - Soluções Avançadas em Tecnologias de Informação S.A. Parque de Ciência e Tecnologia de Almada/Setúbal . Edifício Madan Parque Rua dos Inventores . Quinta da Torre . 2825 - 182 Caparica . Portugal Phone: +351 210 438 686 . Fax: +351 210 438 687 . Web: www.holos.pt This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify Bruno René Santos by telephone on +351 210 438 686
