You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by Steve Clark <sc...@euler.cr.usgs.gov> on 2004/03/24 22:42:16 UTC
Are collection-descriptors inherited or not?
I am having problems with a M:N collection which is defined in a
superclass and inherited by a subclass. I am using RC5.
Here is my (pseudo-)repository:
<class-descriptor class="Super">
<extent-class class-ref="Sub" />
<field-descriptor name="superKey" column="SUPER_KEY" primarykey="true" />
<collection-descriptor name="collect"
element-class-ref="Element"
indirection-table="INDIRECTION_TABLE">
<fk-pointing-to-this-class column="SUPER_KEY"/>
<fk-pointing-to-element-class column="ELEMENT_KEY"/>
</collection-descriptor>
</class-descriptor>
<class-descriptor class="Sub">
<field-descriptor name="superKey" column="SUPER_KEY" primarykey="true" />
<collection-descriptor name="collect"
element-class-ref="Element"
indirection-table="INDIRECTION_TABLE">
<fk-pointing-to-this-class column="SUPER_KEY"/>
<fk-pointing-to-element-class column="ELEMENT_KEY"/>
</collection-descriptor>
</class-descriptor>
<class-descriptor class="Element">
<field-descriptor name="elementKey" column="ELEMENT_KEY" primarykey="true" />
</class-descriptor>
When I try to materialize an instance of Sub, I get
ArrayIndexOutOfBoundsException:
java.lang.ArrayIndexOutOfBoundsException: 2
at org.apache.ojb.broker.core.QueryReferenceBroker.getFKQueryMtoN(QueryReferenceBroker.java:626)
at org.apache.ojb.broker.core.QueryReferenceBroker.getFKQuery(QueryReferenceBroker.java:574)
at org.apache.ojb.broker.core.QueryReferenceBroker.retrieveCollection(QueryReferenceBroker.java:509)
at org.apache.ojb.broker.core.QueryReferenceBroker.retrieveCollections(QueryReferenceBroker.java:696)
at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIterator.java:492)
at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:284)
at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:147)
at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:244)
at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:263)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:997)
at org.apache.ojb.broker.accesslayer.BasePrefetcher.prefetchRelationship(BasePrefetcher.java:153)
at org.apache.ojb.broker.core.QueryReferenceBroker$PBPrefetchingListener.prefetch(QueryReferenceBroker.java:835)
at org.apache.ojb.broker.core.QueryReferenceBroker$PBMaterializationListener.beforeMaterialization(QueryReferenceBroker.java:772)
at org.apache.ojb.broker.accesslayer.IndirectionHandler.beforeMaterialization(IndirectionHandler.java:146)
at org.apache.ojb.broker.accesslayer.IndirectionHandler.materializeSubject(IndirectionHandler.java:332)
at org.apache.ojb.broker.accesslayer.IndirectionHandler.getRealSubject(IndirectionHandler.java:309)
at org.apache.ojb.broker.accesslayer.IndirectionHandler.invoke(IndirectionHandler.java:284)
at $Proxy15.getAccompKey(Unknown Source)
...
Looking at the offending line in QueryReferenceBroker, it appears that
itemClassFks has (at least) two entries, while refCld.getPkFields()
has only one. So it appears that the collection descriptor believes
that it has multiple key fields pointing at Element, while Element
itself has only a single key. I assume this has to do with the
repeated <fk-pointing-to-element-class> in both Super and Sub. Is
this true?
Can somebody post a summary of the correct way to deal with inherited
collections and relationships in OJB?
thanks,
-steve
--
Steve Clark
Technology Applications Team
Natural Resources Research Center/USGS
sclark@detox.cr.usgs.gov
(970)226-9291
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: Are collection-descriptors inherited or not?
Posted by Armin Waibel <ar...@apache.org>.
Hi Steve,
seems to be the same problem as described in thread
"MtoNCollectionPrefetcher.buildPrefetchCriteriaMultipleKeys(MtoNCollectionPrefetcher.java:338)"
Sounds like a bug in Prefetcher classes. Will try to fix this before the
next upcoming release.
regards,
Armin
Steve Clark wrote:
> I am having problems with a M:N collection which is defined in a
> superclass and inherited by a subclass. I am using RC5.
>
> Here is my (pseudo-)repository:
>
> <class-descriptor class="Super">
> <extent-class class-ref="Sub" />
>
> <field-descriptor name="superKey" column="SUPER_KEY" primarykey="true" />
>
> <collection-descriptor name="collect"
> element-class-ref="Element"
> indirection-table="INDIRECTION_TABLE">
> <fk-pointing-to-this-class column="SUPER_KEY"/>
> <fk-pointing-to-element-class column="ELEMENT_KEY"/>
> </collection-descriptor>
> </class-descriptor>
>
> <class-descriptor class="Sub">
> <field-descriptor name="superKey" column="SUPER_KEY" primarykey="true" />
>
> <collection-descriptor name="collect"
> element-class-ref="Element"
> indirection-table="INDIRECTION_TABLE">
> <fk-pointing-to-this-class column="SUPER_KEY"/>
> <fk-pointing-to-element-class column="ELEMENT_KEY"/>
> </collection-descriptor>
> </class-descriptor>
>
> <class-descriptor class="Element">
> <field-descriptor name="elementKey" column="ELEMENT_KEY" primarykey="true" />
> </class-descriptor>
>
> When I try to materialize an instance of Sub, I get
> ArrayIndexOutOfBoundsException:
>
> java.lang.ArrayIndexOutOfBoundsException: 2
> at org.apache.ojb.broker.core.QueryReferenceBroker.getFKQueryMtoN(QueryReferenceBroker.java:626)
> at org.apache.ojb.broker.core.QueryReferenceBroker.getFKQuery(QueryReferenceBroker.java:574)
> at org.apache.ojb.broker.core.QueryReferenceBroker.retrieveCollection(QueryReferenceBroker.java:509)
> at org.apache.ojb.broker.core.QueryReferenceBroker.retrieveCollections(QueryReferenceBroker.java:696)
> at org.apache.ojb.broker.accesslayer.RsIterator.getObjectFromResultSet(RsIterator.java:492)
> at org.apache.ojb.broker.accesslayer.RsIterator.next(RsIterator.java:284)
> at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:147)
> at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:244)
> at org.apache.ojb.broker.core.QueryReferenceBroker.getCollectionByQuery(QueryReferenceBroker.java:263)
> at org.apache.ojb.broker.core.PersistenceBrokerImpl.getCollectionByQuery(PersistenceBrokerImpl.java:997)
> at org.apache.ojb.broker.accesslayer.BasePrefetcher.prefetchRelationship(BasePrefetcher.java:153)
> at org.apache.ojb.broker.core.QueryReferenceBroker$PBPrefetchingListener.prefetch(QueryReferenceBroker.java:835)
> at org.apache.ojb.broker.core.QueryReferenceBroker$PBMaterializationListener.beforeMaterialization(QueryReferenceBroker.java:772)
> at org.apache.ojb.broker.accesslayer.IndirectionHandler.beforeMaterialization(IndirectionHandler.java:146)
> at org.apache.ojb.broker.accesslayer.IndirectionHandler.materializeSubject(IndirectionHandler.java:332)
> at org.apache.ojb.broker.accesslayer.IndirectionHandler.getRealSubject(IndirectionHandler.java:309)
> at org.apache.ojb.broker.accesslayer.IndirectionHandler.invoke(IndirectionHandler.java:284)
> at $Proxy15.getAccompKey(Unknown Source)
> ...
>
> Looking at the offending line in QueryReferenceBroker, it appears that
> itemClassFks has (at least) two entries, while refCld.getPkFields()
> has only one. So it appears that the collection descriptor believes
> that it has multiple key fields pointing at Element, while Element
> itself has only a single key. I assume this has to do with the
> repeated <fk-pointing-to-element-class> in both Super and Sub. Is
> this true?
>
> Can somebody post a summary of the correct way to deal with inherited
> collections and relationships in OJB?
>
> thanks,
> -steve
>
> --
> Steve Clark
> Technology Applications Team
> Natural Resources Research Center/USGS
> sclark@detox.cr.usgs.gov
> (970)226-9291
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org