Hibernate version:
2.1.2
Name and version of the database you are using:
Oracle 8i
Mapping documents:
<hibernate-mapping>
<class
name="Complement"
table="COMPLEMENT"
>
<id
name="id"
type="long"
column="ID">
</id>
<discriminator column="code" type="java.lang.String" />
<subclass
name="ComplementSubClass"
discriminator-value="SUBCLASS"
</subclass>
<subclass
name="OtherSubClass"
discriminator-value="OTHER_SUBCLASS"
</subclass>
</class>

in database table COMPLEMENT :
ID = 1 Code = 'OTHER_SUBCLASS'
ID = 2 Code = 'SUBCLASS'


Code between sessionFactory.openSession() and session.close():
session.load(ComplementSubClass.class,1)

The generated SQL (show_sql=true):
missing where code='SUBCLASS'
got this where clause only when i call a hql query from my .hbm file

Problem :

Hibernate Session.load(ComplementSubClass.class, 1) return me a ComplementSublass but ID=1 of table COMPLEMENT is OtherSubClass not ComplementSubClass ...

anyone got an idea ?

thanks
Franck

You have been explictly asking to return a SubClass in your 'load()' call.

Try...


... and you will probably get what you want.

Thanks for your reply

in fact, i'm asking ComplementSubClass with id 1
i 'am expecting a 'not found exception' cause id 1 is not a ComplementSubclass record.

id 1 = OtherSubclass

that's why i dont understand.

This is an application error (ie. yours). Use a query if you don't know what class the id represents.

after few attempts, this is the only way i found to get it :



Object obj = session.load(Complement.class, 1)
// (Complement.class is the superClass)

ComplementSubclass subClassReturned = null;

if ( obj instanceof ComplementSubclass ) {
subClassReturnedreturned = (ComplementSubclass) obj;
}

return subClassReturned;


that work, but i really dunno if it's the right way to do it.