How to combine two non-decomposed m:n mappings in one collection?

Hi, I have the following problem: I have a table keywords which has two non-decomposed m:n mappings to the tables document and file. The latter two both implement the interface SupportItem. In my Keyword class i would like to have a collection of all SupportItems for this keyword. Is it

Re: How to combine two non-decomposed m:n mappings in one collection?

Coup, Robert Muir wrote: Hi, Did you see my response to your other post? Please reply to the list. No I didn't, sorry! I somehow gave up on this post... Idea #2: How about: class-descriptor class=SupportItemI extent-class class-ref=Document/ extent-class class-ref=Download/

Re: How to combine two non-decomposed m:n mappings in one collection?

Coup, Robert Muir wrote: Well, I would call it t_pal_model_supportitemI, and its a replacement for t_pal_model_document AND t_pal_model_download I guess that's what I wanted to say :-) Tell us how you get on. To remove any potential for misunderstanding (and since I'm a visual person :-)) I

Re: How to combine two non-decomposed m:n mappings in one collection?

As you can see on the picture i adopted your t_ prefix for tables :-) It makes the repository.xml a lot easier to read! I hope you don't have a copyright on it ;-) I will let you know how I get along. Thanks again! Patrick -

Re: How to combine two non-decomposed m:n mappings in one collection?

Coup, Robert Muir wrote: Hmmm... now I'm confused again. :) Ah, you snuck in some other changes - keyword now relates to pal_model? Or maybe not... *** Assuming you want keyword and pal_model separate *** The scenario is this: a PalModel should have a collection of SupportItemsI and a Keyword

Re: How to combine two non-decomposed m:n mappings in one collection?

... and now for something completely different: do i even have define foreign key constraints in my database??? I'm having the impression that OJB is handling all the joins. Is it enough to have some loose tables in my DB ??? Patrick

Re: How to combine two non-decomposed m:n mappings in one collection?

Thank you very much for your time and effort Robert! I'm trying to get your solution to work now (keep your fingers crossed! :-) ) Since this is all for my thesis paper you will get an honorable mention in the acknowledgment section :-) Thanks again and I'll let you know If it works! Take

Re: Desperately need help with my repository

Luis Cruz wrote: Is it possible for you to post the snip of code that does the query? My guess is that you're doing something like this: Here's one of my DAO methods in which the Exception is thrown: public Collection findAllCategories() throws DataAccessException { PersistenceBroker

Desperately need help with my repository

Hi everyone, I'm loosing my mind I just can't figure out what i'm doing wrong. Can some of you please take a look at my code / config and tell me what i'm doing wrong? I know it's a long posting and I would really appreciate it very much if somebody could help me out. I have 7 value

Mapping Question

Hi, Please see the attached image of my data model for reference (I'm sorry for the attachment but it's kind of complicated to describe the scenario otherwise. A picture says more than a thousand words :-) ). How do I map the relationship between pal_model - download and pal_model - document?

Re: Mapping Question

ooops, I guess attachments are not allowed in this mailing list. here's a link to the picture: http://homepage.hispeed.ch/tabalooga/datamodel.jpg the same problem of course also exists for the keyword table. Thank you, Patrick

Vector not found in OJB Repository

Hello OJB Group, I wrote a test case to check if my OJB configuration works properly but everytime I run it I get the following exception: org.apache.ojb.broker.metadata.ClassNotPersistenceCapableException: java.util.Vector not found in OJB Repository Here's the repository_user.xml

Newbie needs help

Hello everybody, I just got started with OJB and i'm experiencing some problems. Here's the scenario that i'm trying to get to work: A DOCUMENT belongs to 1..n CATEGORY. A DOCUMENT is relevant to 0..n PRODUCT_MODELs. A DOCUMENT is written by 1..1 AUTHOR. D DOCUMENT is described by 1..n KEYWORDs.

RE: Newbie needs help

-Original Message- your repository_xml says: indirection-table=document_keyword. typo? (missing 's'); This is not a typo. The table is called document_keyword. handle join tables needed by many-to-many in OJB? see .../db-ojb/src/test/org/apache/ojb/repository_junit.xml usage

RE: Vector not found in OJB Repository

Fixed it. Changed nothing though. Still the same problem -Original Message- From: Anish [mailto:[EMAIL PROTECTED] Sent: Donnerstag, 11. Dezember 2003 09:45 To: [EMAIL PROTECTED] Subject: Re: Vector not found in OJB Repository hi, the foreignkey field-id-ref=9/ is wrong.

Newbie needs help

Hello everybody, I just got started with OJB and i'm experiencing some problems. Here's the scenario that i'm trying to get to work: A DOCUMENT belongs to 1..n CATEGORY. A DOCUMENT is relevant to 0..n PRODUCT_MODELs. A DOCUMENT is written by 1..1 AUTHOR. D DOCUMENT is described by 1..n KEYWORDs.