Hi,
I am having a problem with getting Referenced Object from the Database.
article_relation is a table, that contains a foreign key for articles.
k_article_relation is a second table, that contains all columns for the


The Article Mapping contains a map for KArticleRelation with the key article_id.

The problem now is, that hibernate tries to select the article_id field in the subclass-Table k_article_relation. But this field is only situated in the super-Table article_relation

ERROR:
java.sql.SQLException: ERROR: column krelations0_.article_id does not exist

Hehe, this is true. But I want hibernate to access krelations0_1_.article_id anyway because thats the place where it exists.

Is there any way to change hibernates behavior?

Hibernate version:3.1.3

Mapping documents:




The generated SQL (show_sql=true):
select
krelations0_.article_id as article8_4_,
krelations0_.relation_id as relation1_4_,
krelations0_.relation_id as relation1_2_3_,
krelations0_1_.price as price2_3_,
krelations0_1_.partner_article_number as partner3_2_3_,
krelations0_1_.partner_article_description as partner4_2_3_,
krelations0_1_.article_id as article5_2_3_,
krelations0_1_.account_id as account6_2_3_,
krelations0_.discount as discount3_3_,
krelations0_.min_amount as min3_3_3_,
krelations0_.delivery_costs as delivery4_3_3_,
krelations0_.delivery_time as delivery5_3_3_,
krelations0_.package_costs as package6_3_3_,
krelations0_.package_amount as package7_3_3_,
article1_.article_id as article1_0_0_,
article1_.Articlenumber as Articlen3_0_0_,
article1_.Description1 as Descript4_0_0_,
article1_.Description2 as Descript5_0_0_,
article1_.Sign as Sign0_0_,
article1_.chapter as chapter0_0_,
article1_.unit as unit0_0_,
article1_.volume as volume0_0_,
article1_.weight as weight0_0_,
article1_.Specs as Specs0_0_,
article1_.Brand as Brand0_0_,
chapter2_.chapter_id as chapter1_16_1_,
chapter2_.chapter as chapter16_1_,
chapter2_.description as descript3_16_1_,
unit3_.unit_id as unit1_15_2_,
unit3_.name as name15_2_

from k_article_relations krelations0_
inner join article_relations krelations0_1_ on krelations0_.relation_id=krelations0_1_.relation_id
left outer join article article1_ on krelations0_1_.article_id=article1_.article_id
left outer join chapter chapter2_ on article1_.chapter=chapter2_.chapter_id
left outer join unit unit3_ on article1_.unit=unit3_.unit_id
where krelations0_.article_id=?

Hello Friend:

After readed your post, i guess your can replace the line:

[code] <joined-subclass name="de.datentraum.allrounder.BaseClasses.KArticleRelation" table="k_article_relations">
[/code]

to

<subclass [u]discriminator-value="KKKK" [/u]name="e.datentraum.allrounder.BaseClasses.KArticleRelation">
property name="discount" column="discount" type="int"/>
<property name="minAmount" column="min_amount" type="int"/>
<property name="deliveryCosts" column="delivery_costs" type="double"/>
<property name="deliveryTime" column="delivery_time" type="int"/>
<property name="packageCosts" column="package_costs" type="double"/>
<property name="packageAmount" column="package_amount" type="int"/>
</subclass>


I guess that will solve your problem.

Ohh... the tag joined-subclass is used when you have "table inherited". So, when you have one table, and you want to specific their inherence, you can use "subclass" (Table "Person", may have two object with some operacion different: teacher, student, ando so on);

when you have more than one table that had [u]a some logic[/u], you can use joined-sublcass tag (example: the table Techer, Student, and so on)

Regards.

Hi,

Thx for your reply.
The <subclass> Tag will not work, because I have the fields, that would come additionaly for the subclass in a second table.
So I did use the <joined-subclass>. And thats the situation i am in with the Problem described above.

greetings,
Alexander