Re: Problem with inheritance

2011-12-20 Thread Mathias Clerc
Hi Michael, I won't have time to make a reduced test case before early January. In the mean time I found a workaround so I can continue using Cayenne. Thanks for you time 2011/12/15 Michael Gentry : > Hi Mathias, > > I think we might need to see more of your model to understand what is > going o

Re: Problem with inheritance

2011-12-15 Thread Michael Gentry
Hi Mathias, I think we might need to see more of your model to understand what is going on. In the query you gave: SELECT t0.ID, t0.DESCRIPTION, t0.NAME, t0.TYPE, t1.PATH, t2.PASSWORD, t3.VALUE FROM ELEMENT t0 JOIN FILE t1 ON (t0.ID = t1.ID) JOIN PRINCIPAL t2 ON (t0.ID = t2.ID) JOIN PERMISSION t

Re: Problem with inheritance

2011-12-12 Thread Mathias Clerc
2011/12/13 Mathias Clerc : > Hi Michael, > > Hello > > Actually I am trying to use Cayenne vertical inheritance. Some more > details on what I did : > > I have followed the guide here : > http://cayenne.apache.org/doc30/modeling-vertical-inheritance.html > and with a lot of trial and error, I final

Re: Problem with inheritance

2011-12-12 Thread Mathias Clerc
Hi Michael, Hello Actually I am trying to use Cayenne vertical inheritance. Some more details on what I did : I have followed the guide here : http://cayenne.apache.org/doc30/modeling-vertical-inheritance.html and with a lot of trial and error, I finally got it to insert data. Unfortunately I c

Re: Problem with inheritance

2011-12-12 Thread Michael Gentry
Hi Mathias, I believe you are trying to use a currently unimplemented inheritance mechanism. Cayenne does not currently support horizontal (multiple-table) inheritance: http://cayenne.apache.org/doc/inheritance-overview.html There are tricks you can do to make working with multiple related tabl

Problem with inheritance

2011-12-09 Thread Mathias Clerc
Hello, It seems like I have missed something in inheritance in Cayenne. I have one main table called "Element" with fields id (PK), name and description Another table "File" inherits from "Element" with fields ID(PK, FK on Element.id) and path. When I do a context.performIteratedQuery(new Select