RE: [ojb-users] proxied collections and non-decomposed m:n relati onships

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Was the fix to add in the indirection table?

Do you know as of what project version that was done?

********************************************
Steve Ebersole
IT Integration Engineer
Vignette Corporation 
512.741.4195

Visit http://www.vignette.com

********************************************

-----Original Message-----
From: Jakob Braeuchi [mailto:jbr...@ho...]
Sent: Friday, May 31, 2002 8:51 AM
To: Ebersole, Steven; obj...@li...
Subject: Re: [ojb-users] proxied collections and non-decomposed m:n
relati onships

hi steven,

i remeber i fixed a problem in SqlGenerator in the count(*) when dealing
with m:n.
yes, here it is:

Revision 1.3 / (view) - annotate - [select for diffs] , Wed Apr 24 06:53:11
2002 UTC (5 weeks, 2 days ago) by brj
Branch: MAIN
Changes since 1.2: +11 -3 lines
Diff to previous 1.2
fix for count-statement with M:N Criteria
jakob
----- Original Message -----
From: "Ebersole, Steven" <ste...@vi...>
To: "'Jakob Braeuchi'" <jbr...@ho...>;
<obj...@li...>
Sent: Friday, May 31, 2002 3:19 PM
Subject: RE: [ojb-users] proxied collections and non-decomposed m:n relati
onships

> With proxy:
>
> SELECT COUNT(*)
> FROM   ADDR_TYPE_LU
> WHERE (ADDR_ID= ? )
>   AND  ADDR_ADDR_TYPE_JT.ADDR_TYPE_ID=ADDR_TYPE_LU.ADDR_TYPE_ID
>
>
> Without proxy:
>
> SELECT ADDR_TYPE_LU.ADDR_TYPE_ID,
>        ADDR_TYPE_LU.ACTIVE_FLG,
>        ADDR_TYPE_LU.CRTD_BY,
>        ADDR_TYPE_LU.CRTD_DT,
>        ADDR_TYPE_LU.CHGD_BY,
>        ADDR_TYPE_LU.CHGD_DT,
>        ADDR_TYPE_LU.NAME,
>        ADDR_TYPE_LU.OPT_ORDER
> FROM   ADDR_TYPE_LU,
>        ADDR_ADDR_TYPE_JT
> WHERE (ADDR_ID= ? )
>   AND  ADDR_ADDR_TYPE_JT.ADDR_TYPE_ID=ADDR_TYPE_LU.ADDR_TYPE_ID
>
>
> Mapping:
>
>         <CollectionDescriptor id="1">
>             <cdfield.name>addressTypes</cdfield.name>
> <!--
>             <proxyCollection>true</proxyCollection>
> -->
>
> <items.class>com.vignette.it.apps.dbapi.domain.AddressTypeDO</items.class>
>             <indirection_table>ADDR_ADDR_TYPE_JT</indirection_table>
>
<fks_pointing_to_this_class>ADDR_ID</fks_pointing_to_this_class>
>
> <fks_pointing_to_items_class>ADDR_TYPE_ID</fks_pointing_to_items_class>
>         </CollectionDescriptor>
>
>
> So basically, when I specify a collection proxy, the code is not grabbing
> the indirection table from the mapping to add into the SQL FROM clause.
>
> I am using 0.8.375 version of OJB, so maybe this is something which has
> since been taken care of.
>
>
>
> ********************************************
> Steve Ebersole
> IT Integration Engineer
> Vignette Corporation
> 512.741.4195
>
> Visit http://www.vignette.com
>
> ********************************************
>
>
> -----Original Message-----
> From: Jakob Braeuchi [mailto:jbr...@ho...]
> Sent: Friday, May 31, 2002 7:49 AM
> To: Thomas Mahler; Ebersole, Steven
> Cc: obj...@li...
> Subject: Re: [ojb-users] proxied collections and non-decomposed m:n
> relationships
>
>
> hi steven,
>
> can you please provide the generated sql with and without proxy ?
>
> jakob
>
>
> ----- Original Message -----
> From: "Thomas Mahler" <tho...@ho...>
> To: "Ebersole, Steven" <ste...@vi...>
> Cc: <obj...@li...>
> Sent: Friday, May 31, 2002 2:21 PM
> Subject: Re: [ojb-users] proxied collections and non-decomposed m:n
> relationships
>
>
> > Hi Steven,
> >
> > Ebersole, Steven wrote:
> >
> > > Is it possible to utilize a proxy collection on "non-decomposed m:n
> > > mappings" (where an indirection_table is explicitly defined in the
> mapping)?
> > >
> > > I keep getting "ORA-00904: invalid column name" errors when attempting
> this
> > > even though it works when the collection is non-proxied?
> > >
> >
> >
> > Mhh, I don't think that this is implemented yet.
> > We should as Jakob Braeuchli, who implemented this feature...
> >
> >
> > >
> > >
> > > As an aside, I would like to be able to use java.util.List for the
> > > collections in the mapped objects whether or not they are proxied.  I
> just
> > > wondered whether anyone has started work on a proxy handling the List
> > > interface.  If not, I will do it, and was just wondering if this would
> be
> > > something of general interest.
> >
> >
> > Sure, this is a must, as The List interface is supported everywhere
> > else. implementing this won't be too difficult.
> >
> >
> > >
> > > Also, I know some work has been started on JTA integration.  This is
> > > something in which I would be extremely interested.  If any help is
> needed
> > > on this effort, I would be glad to volunteer any time I can.  However,
I
> am
> > > not sure who is leading this effort.  Just let me know.
> > >
> >
> >
> > AFAIK JTA and JCA stuff are completed. But it would be good to have more
> > Examplecode and documentation on these feature
> >
> > Thanks for your offer to help!
> >
> > cheers,
> >
> > Thomas
> >
> >
> > >
> > >
> > >
> > > ********************************************
> > > Steve Ebersole
> > > IT Integration Engineer
> > > Vignette Corporation
> > > 512.741.4195
> > >
> > > Visit http://www.vignette.com
> > >
> > > ********************************************
> > >
> > > _______________________________________________________________
> > >
> > > Don't miss the 2002 Sprint PCS Application Developer's Conference
> > > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
> > >
> > > _______________________________________________
> > > Objectbridge-users mailing list
> > > Obj...@li...
> > > https://lists.sourceforge.net/lists/listinfo/objectbridge-users
> > >
> > >
> > >
> > >
> >
> >
> >
> > _______________________________________________________________
> >
> > Don't miss the 2002 Sprint PCS Application Developer's Conference
> > August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
> >
> > _______________________________________________
> > Objectbridge-users mailing list
> > Obj...@li...
> > https://lists.sourceforge.net/lists/listinfo/objectbridge-users
> >
>
> _______________________________________________________________
>
> Don't miss the 2002 Sprint PCS Application Developer's Conference
> August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
>
> _______________________________________________
> Objectbridge-users mailing list
> Obj...@li...
> https://lists.sourceforge.net/lists/listinfo/objectbridge-users
>