Re: [JBoss-dev] EJB 2.0 CMP

2001-09-04 Thread Dain Sundstrom
Comments below... Got it now ... but it is still not seeing eye to eye ... comments below .. Dain Sundstrom wrote: Dave, We still don't see eye-to-eye, and I think I made the problem worse with my example. I think the most common type of relationship will be something like 'a cd

Re: [JBoss-dev] EJB 2.0 CMP

2001-09-03 Thread Dave Smith
Got it now ... but it is still not seeing eye to eye ... comments below .. Dain Sundstrom wrote: Dave, We still don't see eye-to-eye, and I think I made the problem worse with my example. I think the most common type of relationship will be something like 'a cd has an artist' or 'a cd

Re: [JBoss-dev] EJB 2.0 CMP

2001-08-31 Thread Dave Smith
Dain Sundstrom wrote: Dave, After reviewing these comments I think we are making this way more complicated than it has to be. As far as I am concerned we should only need the relationship stuff in jbosscmp-jdbc.xml for relationships that use a relation table (ex. self relation

Re: [JBoss-dev] EJB 2.0 CMP

2001-08-31 Thread Dave Smith
Sorry if this is posted twice! Dain Sundstrom wrote: Dave, After reviewing these comments I think we are making this way more complicated than it has to be. As far as I am concerned we should only need the relationship stuff in jbosscmp-jdbc.xml for relationships that use a relation

RE: [JBoss-dev] EJB 2.0 CMP

2001-08-31 Thread Dain Sundstrom
Dave, We still don't see eye-to-eye, and I think I made the problem worse with my example. I think the most common type of relationship will be something like 'a cd has an artist' or 'a cd has a publisher.' In this cases, the foreign key for the artist or publisher would be just another

RE: [JBoss-dev] EJB 2.0 CMP

2001-08-31 Thread marc fleury
|I still believe there is overkill for the simple cases | |which will be the majority of cases. This is something that many hmmm I am a cretin when it comes to db stuff but anything that makes the lives of *most* people better as opposed to the lives of everyone blah is a good thing. Never

[JBoss-dev] EJB 2.0 CMP

2001-08-30 Thread Dave Smith
Dain Sundstrom wrote: I am playing with the current sources and testing a 1 to many relationship. I have the following two tables order with pk: int objectid ok and orderdetail pk: int order_oid,int line_num Does order detail have a compund key using both order_oid and

Re: [JBoss-dev] EJB 2.0 CMP

2001-08-30 Thread Dain Sundstrom
Dave, Ok, I see the misunderstanding now. I thought you were talking about the jbosscmp-jdbc.xml file and you were talking about the ejb-jar.xml file. You are correct in that a single relation can only have one cmr field on each side of the relationship. From my perspective these are object

[JBoss-dev] EJB 2.0 CMP

2001-08-29 Thread Dave Smith
I am playing with the current sources and testing a 1 to many relationship. I have the following two tables order with pk: int objectid and orderdetail pk: int order_oid,int line_num The link.. order_oid=objectid There is a 1 to many relationship between Order and orderdetail. When you go

Re: [JBoss-dev] EJB 2.0 CMP

2001-08-29 Thread Dain Sundstrom
I am playing with the current sources and testing a 1 to many relationship. I have the following two tables order with pk: int objectid ok and orderdetail pk: int order_oid,int line_num Does order detail have a compund key using both order_oid and line_num? The link..