Hibernate version: 2.0

Name and version of the database you are using: MySql

Hi,

I try to get unique values from the subclass using DISTINCT but
nothing seems to work. Below is the one example I tried to execute but
it didn't work either.

Any help on this topic will be appreciated.

Thanks,

<class name="Service" lazy="true" table="Service" discriminator-value="SERVICE">
<id name="id" column="service_id" type="long" unsaved-value="null">
<generator class="identity"/>
</id>
<discriminator column="SERVICE_TYPE" type="string"/>
-----
-----

<subclass name="cas.system.app.model.Equipment" lazy="true" discriminator-value="EQUIPMENT">
<property name="currentstatus" column="equipment_currentstatus" type="string"/>
------
------
</subclass>
</class>

The generated SQL (show_sql=true):
List list = session.createSQLQuery("select{s}.EQUIPMENT_CURRENTSTATUS as {e.currentstatus} from service {s}
where SERVICE_TYPE = 'EQUIPMENT'", "e", Service.class).list();

there is no distinct keyword in what you show us

Sorry, I forgot to put DISTINCT in the statement.
It looks like this:

List list = session.createSQLQuery("select distinct{s}.EQUIPMENT_CURRENTSTATUS as {e.currentstatus} from service {s}
where SERVICE_TYPE = 'EQUIPMENT'", "e", Service.class).list();

I've also used examples from the "HIBERNATE IN ACTION" book but they don't work either.

Thank you for help.

Please read the docs, that query is totaly wrong. For example you are using an alias s you have never defined. Also, unless you use the currently quite undocumented H3 api, createSqlQueries can only return mapped entities.

Thank you for reply.

As I've said before I've used different kind of queries.
Could you please show me what would be an example of correct syntax
for retrieving unique values from current_status column from the subclass(plsease see example below).

<class name="class1" .......

<subclass name="class2" .......
<property name="status" column="current_status" .......
</subclass>

</class>


Thank you,