extent with inheritence using JOIN on multiple tables. bug?

Tue, 29 Jul 2003 12:58:07 -0700

Hello

I am trying to use the inheritence implementation with joining multiple tables. It seems to work fine except when I add the "<extent-class class-ref=../>" into the repository.xml for the base class. After adding the extent tag, the original find using the subclass no longer return values for inherited attributes. Furthermore, query by base class returns 2 copies of the data but without being a subclass object. Please look at SimpleWithList, any help would be great!

Thanks
Ka-Wai

<!-- Please keep user defined mappings in this file only
    to avoid mixing user defined and system mappings. -->
<!-- Mapping of User defined classes starts here -->

<!-- The mappings for the tutorial classes are placed here to make it
    easier to find them for OJB newbies.
    Please remove them if you don't need them in your environment. -->

<!-- Definitions for org.apache.ojb.tutorial1.Product -->
<class-descriptor
class="net.codebasis.ormapping.entity.Simple"
table="Simple"
>
<field-descriptor
name="id"
column="id"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
conversion="org.apache.ojb.broker.accesslayer.conversions.Int2IntegerFieldConversion"
/>
<field-descriptor
name="name"
column="NAME"
jdbc-type="VARCHAR"
/>
<field-descriptor
name="value"
column="value"
jdbc-type="VARCHAR"
/>
<field-descriptor
name="lastModifiedUser"
column="lmu"
jdbc-type="VARCHAR"
/>
<field-descriptor
name="lastModifiedDate"
column="lmd"
jdbc-type="DATE"
conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFieldConversion"
/>
<extent-class class-ref="net.codebasis.ormapping.entity.SimpleWithList" />
<extent-class class-ref="net.codebasis.ormapping.entity.SimpleWithComponent" />
</class-descriptor>

<class-descriptor
class="net.codebasis.ormapping.entity.Component"
table="Component"
>
<field-descriptor
name="id"
column="id"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
conversion="org.apache.ojb.broker.accesslayer.conversions.Int2IntegerFieldConversion"
/>
<field-descriptor
name="value"
column="value"
jdbc-type="VARCHAR"
/>
</class-descriptor>

<class-descriptor
class="net.codebasis.ormapping.entity.SimpleWithComponent"
table="SimpleWithComponent"
>
<field-descriptor
name="id"
column="id"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
conversion="org.apache.ojb.broker.accesslayer.conversions.Int2IntegerFieldConversion"
/>
<field-descriptor
name="componentId"
column="componentId"
jdbc-type="INTEGER"
conversion="org.apache.ojb.broker.accesslayer.conversions.Int2IntegerFieldConversion"
/>

<field-descriptor
name="name"
column="NAME"
jdbc-type="VARCHAR"
/>
<field-descriptor
name="value"
column="value"
jdbc-type="VARCHAR"
/>
<field-descriptor
name="lastModifiedUser"
column="lmu"
jdbc-type="VARCHAR"
/>
<field-descriptor
name="lastModifiedDate"
column="lmd"
jdbc-type="DATE"
conversion="org.apache.ojb.broker.accesslayer.conversions.JavaDate2SqlDateFieldConversion"
/>
<reference-descriptor
name="component"
class-ref="net.codebasis.ormapping.entity.Component"
auto-retrieve="true"
auto-update="true"
auto-delete="true"
>
<foreignkey field-ref="componentId"/>
</reference-descriptor>
</class-descriptor>


<class-descriptor
class="net.codebasis.ormapping.entity.Item"
table="Item"
>
<field-descriptor
name="id"
column="id"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
conversion="org.apache.ojb.broker.accesslayer.conversions.Int2IntegerFieldConversion"
/>
<field-descriptor
name="simpleId"
column="simpleId"
jdbc-type="INTEGER"
conversion="org.apache.ojb.broker.accesslayer.conversions.Int2IntegerFieldConversion"
/>
<field-descriptor
name="value"
column="value"
jdbc-type="VARCHAR"
/>
</class-descriptor>

<class-descriptor
class="net.codebasis.ormapping.entity.SimpleWithList"
table="SimpleWithList"
>
<field-descriptor
name="id"
column="id"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
conversion="org.apache.ojb.broker.accesslayer.conversions.Int2IntegerFieldConversion"
/>

 <collection-descriptor
   name="itemList"
   element-class-ref="net.codebasis.ormapping.entity.Item"
   orderby="value"
   sort="DESC"
   auto-retrieve="true"
   auto-update="true"
   auto-delete="true"
   >
   <inverse-foreignkey field-ref="simpleId"/>
 </collection-descriptor>

 <reference-descriptor name="super"
   class-ref="net.codebasis.ormapping.entity.Simple">
   <foreignkey field-ref="id"/>
 </reference-descriptor>
</class-descriptor>

<!-- Mapping of User defined classes ends here-->



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to