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 Andreas Bayer <An...@gillardon.de> on 2003/04/15 13:43:59 UTC

[OJB] Issue #OJB156 - queries over two extend hierarchies doesn't work

You can view the issue detail at the following URL:
<http://scarab.werken.com/scarab/issues/id/OJB156>

Type :        Defect
Issue Id :    OJB156
Reported by: Andreas Bayer
             bayera - (Andreas.Bayer@gillardon.de)

Details:

Platform: All
Operating system: windows 2000
Summary: queries over two extend hierarchies doesn't work
Description: Example:

Classes A, B, C, X.
C extends B and B extends A.
X has a member A (base class)

I stored a X with C as member.
If I query for X with the member.id = C.id the generated
SQL Query only searches in the table of A and B, not in C.

After some changes in SQLQueryStatement (see attachment) the example works for me. It's tested with Oracle and DB2.
Status: New
Priority: High
Vote: High
Severity: Major


Re: [OJB] Issue #OJB156 - queries over two extend hierarchies doesn't work

Posted by Jakob Braeuchi <jb...@gmx.ch>.
hi andreas,

have you tried it with the latest from repository?
i have made some changes to getConcreteSubclasses.

jakob

Andreas Bayer wrote:

>You can view the issue detail at the following URL:
><http://scarab.werken.com/scarab/issues/id/OJB156>
>
>Type :        Defect
>Issue Id :    OJB156
>Reported by: Andreas Bayer
>             bayera - (Andreas.Bayer@gillardon.de)
>
>Details:
>
>Platform: All
>Operating system: windows 2000
>Summary: queries over two extend hierarchies doesn't work
>Description: Example:
>
>Classes A, B, C, X.
>C extends B and B extends A.
>X has a member A (base class)
>
>I stored a X with C as member.
>If I query for X with the member.id = C.id the generated
>SQL Query only searches in the table of A and B, not in C.
>
>After some changes in SQLQueryStatement (see attachment) the example works for me. It's tested with Oracle and DB2.
>Status: New
>Priority: High
>Vote: High
>Severity: Major
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: ojb-dev-unsubscribe@db.apache.org
>For additional commands, e-mail: ojb-dev-help@db.apache.org
>
>
>  
>