You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-dev@db.apache.org by "Dima (JIRA)" <ji...@apache.org> on 2005/04/14 02:57:16 UTC
[jira] Created: (OJB-21) retrieval of collection of objects with inheritance
retrieval of collection of objects with inheritance
---------------------------------------------------
Key: OJB-21
URL: http://issues.apache.org/jira/browse/OJB-21
Project: OJB
Type: Bug
Components: PB-API
Versions: 1.0.x CVS
Environment: Linux Debian, Intel Pentium 4
Reporter: Dima
Not possible to retrieve(possible update) collections of objects with inheritance. Collection consist of derived type of object( not base). The result exception says that foreign key field not found in derived object(true, because it is in base). Tried with extensions, anonymous etc.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
[jira] Updated: (OJB-21) retrieval of collection of objects with inheritance
Posted by "Jakob Braeuchi (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OJB-21?page=all ]
Jakob Braeuchi updated OJB-21:
------------------------------
Version: 1.1 CVS
> retrieval of collection of objects with inheritance
> ---------------------------------------------------
>
> Key: OJB-21
> URL: http://issues.apache.org/jira/browse/OJB-21
> Project: OJB
> Type: Bug
> Components: PB-API
> Versions: 1.0.x CVS, 1.1 CVS
> Environment: Linux Debian, Intel Pentium 4
> Reporter: Dima
>
> Not possible to retrieve(possible update) collections of objects with inheritance. Collection consist of derived type of object( not base). The result exception says that foreign key field not found in derived object(true, because it is in base). Tried with extensions, anonymous etc.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
[jira] Reopened: (OJB-21) retrieval of collection of objects with inheritance
Posted by "armin waibel (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OJB-21?page=all ]
armin waibel reopened OJB-21:
-----------------------------
Wrote a test for this issue. The test can be found in ...broker.InheritanceMultipleTableTest#testInheritedReferences
> retrieval of collection of objects with inheritance
> ---------------------------------------------------
>
> Key: OJB-21
> URL: http://issues.apache.org/jira/browse/OJB-21
> Project: OJB
> Type: Bug
> Components: PB-API
> Versions: 1.0.x CVS
> Environment: Linux Debian, Intel Pentium 4
> Reporter: Dima
>
> Not possible to retrieve(possible update) collections of objects with inheritance. Collection consist of derived type of object( not base). The result exception says that foreign key field not found in derived object(true, because it is in base). Tried with extensions, anonymous etc.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
[jira] Commented: (OJB-21) retrieval of collection of objects with inheritance
Posted by "Martin Kalén (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OJB-21?page=comments#action_62820 ]
Martin Kalén commented on OJB-21:
---------------------------------
Please subscribe to the OJB User's mailinglist (by mailing ojb-user-subscribe@db.apache.org) and post your problem there, together with the additional information requested by Armin and Tom.
You will have a much faster turn-around time getting help and feedback from the user's list than through JIRA.
> retrieval of collection of objects with inheritance
> ---------------------------------------------------
>
> Key: OJB-21
> URL: http://issues.apache.org/jira/browse/OJB-21
> Project: OJB
> Type: Bug
> Components: PB-API
> Versions: 1.0.x CVS
> Environment: Linux Debian, Intel Pentium 4
> Reporter: Dima
>
> Not possible to retrieve(possible update) collections of objects with inheritance. Collection consist of derived type of object( not base). The result exception says that foreign key field not found in derived object(true, because it is in base). Tried with extensions, anonymous etc.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
[jira] Commented: (OJB-21) retrieval of collection of objects with inheritance
Posted by "Dima (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OJB-21?page=comments#action_62861 ]
Dima commented on OJB-21:
-------------------------
The exception:
org.apache.ojb.broker.OJBRuntimeException: Incorrect or not found field referenc
e name 'chartID' in descriptor org.apache.ojb.broker.metadata.CollectionDescript
or@d09ad3[cascade_retrieve=true,cascade_store=none,cascade_delete=object,is_lazy
=false,class_of_Items=class com.telcordia.xsl.performancereports.KeyIndicatorCon
dChart] for class-descriptor 'com.telcordia.xsl.performancereports.KeyIndicatorC
ondChart'
at org.apache.ojb.broker.metadata.ObjectReferenceDescriptor.getForeignKeyFieldD
escriptors(ObjectReferenceDescriptor.java:131)
at org.apache.ojb.broker.core.QueryReferenceBroker.getFKQuery1toN(QueryReferenc
eBroker.java:697)
at org.apache.ojb.broker.core.QueryReferenceBroker.getFKQuery(QueryReferenceBro
ker.java:630)
at org.apache.ojb.broker.core.QueryReferenceBroker.retrieveCollection(QueryRefe
renceBroker.java:561)
at org.apache.ojb.broker.core.QueryReferenceBroker.retrieveCollections(QueryRef
erenceBroker.java:748)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(PersistenceBrok
erImpl.java:1303)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.doGetObjectByIdentity(Persi
stenceBrokerImpl.java:1367)
at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByIdentity(Persist
enceBrokerImpl.java:1346)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByIdentity(D
elegatingPersistenceBroker.java:312)
at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByIdentity(D
elegatingPersistenceBroker.java:312)
at com.telcordia.xsl.test.scheduler.OJBTest.testBroker(OJBTest.java)
at com.telcordia.xsl.test.scheduler.OJBTest.main(OJBTest.java)
> retrieval of collection of objects with inheritance
> ---------------------------------------------------
>
> Key: OJB-21
> URL: http://issues.apache.org/jira/browse/OJB-21
> Project: OJB
> Type: Bug
> Components: PB-API
> Versions: 1.0.x CVS
> Environment: Linux Debian, Intel Pentium 4
> Reporter: Dima
>
> Not possible to retrieve(possible update) collections of objects with inheritance. Collection consist of derived type of object( not base). The result exception says that foreign key field not found in derived object(true, because it is in base). Tried with extensions, anonymous etc.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
[jira] Closed: (OJB-21) retrieval of collection of objects with inheritance
Posted by "Martin Kalén (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OJB-21?page=history ]
Martin Kalén closed OJB-21:
---------------------------
Resolution: Cannot Reproduce
Description is incomplete/not reproducable, directing to ojb-user mailinglist. If it is determined on the user-list that this is indeed an OJB bug, we will re-open this JIRA issue.
> retrieval of collection of objects with inheritance
> ---------------------------------------------------
>
> Key: OJB-21
> URL: http://issues.apache.org/jira/browse/OJB-21
> Project: OJB
> Type: Bug
> Components: PB-API
> Versions: 1.0.x CVS
> Environment: Linux Debian, Intel Pentium 4
> Reporter: Dima
>
> Not possible to retrieve(possible update) collections of objects with inheritance. Collection consist of derived type of object( not base). The result exception says that foreign key field not found in derived object(true, because it is in base). Tried with extensions, anonymous etc.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
Re: [jira] Commented: (OJB-21) retrieval of collection of objects
with inheritance
Posted by Martin Kalén <mk...@apache.org>.
Dima (JIRA) wrote:
> I subscribed to the mailing list , but my emails bouncing back,
> so I post it here
I have sent detailed instructions directly to Dima for how to
subscribe to OJB user's list.
Regards,
Martin
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
[jira] Commented: (OJB-21) retrieval of collection of objects with inheritance
Posted by "Dima (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OJB-21?page=comments#action_62860 ]
Dima commented on OJB-21:
-------------------------
I subscribed to the mailing list , but my emails bouncing back,
so I post it here
<class-descriptor
class="KeyIndicatorAggChart"
table="XSL_RPT_KI_AGG_CHART_T"
>
<field-descriptor
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
sequence-name="XSL_RPT_ASSOC_OBJ_ID_SEQ"
access="anonymous"
/>
<field-descriptor
name="chartID"
column="CHART_ID"
jdbc-type="INTEGER"
/>
</class-descriptor>
<!-- class -->
<class-descriptor
class="KeyIndicatorCondChart"
table="XSL_RPT_KI_COND_CHART_T"
>
<field-descriptor
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
sequence-name="XSL_RPT_ASSOC_OBJ_ID_SEQ"
access="anonymous"
/>
<reference-descriptor
name="super"
class-ref="KeyIndicatorAggChart"
auto-retrieve="true"
auto-update="true"
auto-delete="true"
>
<foreignkey field-ref="id"/>
</reference-descriptor>
</class-descriptor>
<!-- class -->
<class-descriptor
class="ObjectGroupAnalysisChart"
table="XSL_RPT_OBJ_GROUP_ANL_CHART_T"
>
<field-descriptor
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
sequence-name="XSL_ADM_SEQ"
/>
<collection-descriptor
name="keyIndicators"
element-class-ref="KeyIndicatorCondChart"
auto-retrieve="true"
auto-update="none"
auto-delete="true">
<inverse-foreignkey field-ref="chartID"/>
</collection-descriptor>
</class-descriptor>
</descriptor-repository>
> retrieval of collection of objects with inheritance
> ---------------------------------------------------
>
> Key: OJB-21
> URL: http://issues.apache.org/jira/browse/OJB-21
> Project: OJB
> Type: Bug
> Components: PB-API
> Versions: 1.0.x CVS
> Environment: Linux Debian, Intel Pentium 4
> Reporter: Dima
>
> Not possible to retrieve(possible update) collections of objects with inheritance. Collection consist of derived type of object( not base). The result exception says that foreign key field not found in derived object(true, because it is in base). Tried with extensions, anonymous etc.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
[jira] Closed: (OJB-21) retrieval of collection of objects with inheritance
Posted by "Jakob Braeuchi (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OJB-21?page=all ]
Jakob Braeuchi closed OJB-21:
-----------------------------
Resolution: Duplicate
see OJB-64
> retrieval of collection of objects with inheritance
> ---------------------------------------------------
>
> Key: OJB-21
> URL: http://issues.apache.org/jira/browse/OJB-21
> Project: OJB
> Type: Bug
> Components: PB-API
> Versions: 1.0.x CVS, 1.1 CVS
> Environment: Linux Debian, Intel Pentium 4
> Reporter: Dima
>
> Not possible to retrieve(possible update) collections of objects with inheritance. Collection consist of derived type of object( not base). The result exception says that foreign key field not found in derived object(true, because it is in base). Tried with extensions, anonymous etc.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
[jira] Commented: (OJB-21) retrieval of collection of objects with inheritance
Posted by "Martin Kalén (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OJB-21?page=comments#action_62887 ]
Martin Kalén commented on OJB-21:
---------------------------------
Issue is now on OJB users's list. See:
http://www.mail-archive.com/ojb-user%40db.apache.org/msg13391.html
> retrieval of collection of objects with inheritance
> ---------------------------------------------------
>
> Key: OJB-21
> URL: http://issues.apache.org/jira/browse/OJB-21
> Project: OJB
> Type: Bug
> Components: PB-API
> Versions: 1.0.x CVS
> Environment: Linux Debian, Intel Pentium 4
> Reporter: Dima
>
> Not possible to retrieve(possible update) collections of objects with inheritance. Collection consist of derived type of object( not base). The result exception says that foreign key field not found in derived object(true, because it is in base). Tried with extensions, anonymous etc.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
[jira] Commented: (OJB-21) retrieval of collection of objects with inheritance
Posted by "Thomas Dudziak (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OJB-21?page=comments#action_62806 ]
Thomas Dudziak commented on OJB-21:
-----------------------------------
Please add the problematic classes and the repository.xml as well as the stacktrace.
> retrieval of collection of objects with inheritance
> ---------------------------------------------------
>
> Key: OJB-21
> URL: http://issues.apache.org/jira/browse/OJB-21
> Project: OJB
> Type: Bug
> Components: PB-API
> Versions: 1.0.x CVS
> Environment: Linux Debian, Intel Pentium 4
> Reporter: Dima
>
> Not possible to retrieve(possible update) collections of objects with inheritance. Collection consist of derived type of object( not base). The result exception says that foreign key field not found in derived object(true, because it is in base). Tried with extensions, anonymous etc.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
[jira] Commented: (OJB-21) retrieval of collection of objects with inheritance
Posted by "Jakob Braeuchi (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OJB-21?page=comments#action_12331737 ]
Jakob Braeuchi commented on OJB-21:
-----------------------------------
the main issu ojb-63 has been fixed, but this one is still open
> retrieval of collection of objects with inheritance
> ---------------------------------------------------
>
> Key: OJB-21
> URL: http://issues.apache.org/jira/browse/OJB-21
> Project: OJB
> Type: Bug
> Components: PB-API
> Versions: 1.0.x CVS
> Environment: Linux Debian, Intel Pentium 4
> Reporter: Dima
>
> Not possible to retrieve(possible update) collections of objects with inheritance. Collection consist of derived type of object( not base). The result exception says that foreign key field not found in derived object(true, because it is in base). Tried with extensions, anonymous etc.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org
[jira] Commented: (OJB-21) retrieval of collection of objects with inheritance
Posted by "Jakob Braeuchi (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/OJB-21?page=comments#action_12331741 ]
Jakob Braeuchi commented on OJB-21:
-----------------------------------
testcase generates this sql:
SELECT A0.OBJ_ID,A0.NAME
FROM INHERITANCE_CONSORTIUM A0
INNER JOIN INHERITANCE_SHAREHOLDER A1 ON A0.OBJ_ID=A1.FK_CONSORTIUM
INNER JOIN INHERITANCE_MANAGER A2 ON A1.OBJ_ID=A2.OBJ_ID AND A1.OBJ_ID_2=A2.OBJ_ID_2
INNER JOIN INHERITANCE_EXECUTIVE A3 ON A2.OBJ_ID=A3.OBJ_ID AND A2.OBJ_ID_2=A3.OBJ_ID_2
INNER JOIN INHERITANCE_EMPLOYEE A4 ON A3.OBJ_ID=A4.OBJ_ID AND A3.OBJ_ID_2=A4.OBJ_ID_2
WHERE ((A0.NAME = ?) AND A1.SHARE_ = ?) AND A4.NAME = ?
SqlException : Column not found: FK_CONSORTIUM
in the correct sql the joins for MANGER / SHAREHOLDER are flipped :!
SELECT A0.OBJ_ID,A0.NAME
FROM INHERITANCE_CONSORTIUM A0
INNER JOIN INHERITANCE_MANAGER A1 ON A0.OBJ_ID=A1.FK_CONSORTIUM
INNER JOIN INHERITANCE_SHAREHOLDER A2 ON A1.OBJ_ID=A2.OBJ_ID AND A1.OBJ_ID_2=A2.OBJ_ID_2
INNER JOIN INHERITANCE_EXECUTIVE A3 ON A2.OBJ_ID=A3.OBJ_ID AND A2.OBJ_ID_2=A3.OBJ_ID_2
INNER JOIN INHERITANCE_EMPLOYEE A4 ON A3.OBJ_ID=A4.OBJ_ID AND A3.OBJ_ID_2=A4.OBJ_ID_2
WHERE ((A0.NAME = ?) AND A2.SHARE_ = ?) AND A4.NAME = ?
> retrieval of collection of objects with inheritance
> ---------------------------------------------------
>
> Key: OJB-21
> URL: http://issues.apache.org/jira/browse/OJB-21
> Project: OJB
> Type: Bug
> Components: PB-API
> Versions: 1.0.x CVS, 1.1 CVS
> Environment: Linux Debian, Intel Pentium 4
> Reporter: Dima
>
> Not possible to retrieve(possible update) collections of objects with inheritance. Collection consist of derived type of object( not base). The result exception says that foreign key field not found in derived object(true, because it is in base). Tried with extensions, anonymous etc.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-dev-help@db.apache.org