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

[Ebersole, S. <ste...@vi...>]

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
>