Re: howto query this

2006-01-19 Thread Thomas Franke
Hans Novak wrote: Can you give me a hint howto realize that ? I'll take a closer look to your statements and tables and try it. Did you publish all your terms so that I can find them into the previous mails? Regards, Thomas -

Re: bad sql on n-m relation to subclassed object

2006-01-19 Thread Jakob Braeuchi
hi nicolas, you say A links to A. how is this done ? shouldn't there be a idreftoA in A as well ? jakob DELAHAYE Nicolas schrieb: hi Jakob Braeuchi I have this model : A link to A B, C, and D that inherit of A when i would like retreive a object A by findObjectByIdentity, the left out

Re: howto query this

2006-01-19 Thread Hans Novak
Hello Thomas (and Jakob) Thomas Franke schrieb: I'll take a closer look to your statements and tables and try it. Did you publish all your terms so that I can find them into the previous mails? I'm not shure. So her are my classes and the repository: I hope, thats what you need. Hans

Re: Writing to database question.

2006-01-19 Thread Armin Waibel
Hi Aleksandar, Milisic Aleksandar wrote: Armin, after your request to post to the user group, I am doing that, even though I thought last time that if I clicked the reply at the bottom it would automatically be posted to the newsgroup. Silly me. :) Anyway, here is my original question and with

Re: Writing to database question.

2006-01-19 Thread Milisic Aleksandar
Thanks, Armin, that was a lot of help. I can see clearly now. :)) Do you Yahoo!? Listen to over 20 online radio stations and watch the latest music videos on Yahoo! Music. http://au.launch.yahoo.com

Re: bad sql on n-m relation to subclassed object

2006-01-19 Thread DELAHAYE Nicolas
Hi Jakob Braeuchi, The link A - A is made by an other field (linktoSelf) But i have try also without this link (A to A) and the part of query that made the left out join, link by : A.id = A.idreftoA. DB like : A [id, linktoSelft] ID is PK B [idreftoA, fielB ] idreftA is PK and FK C