Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3

Mapping documents:
<hibernate-mapping>
<class name="entity.Program"
table="program"
dynamic-update="false"
dynamic-insert="false"
>

<id
name="programId"
column="program_id"
type="java.lang.Integer"
>
<joined-subclass
name="entity.Seminar"
table="seminar"
>
<key
column="seminar_id"
/>
......./>

My question is if I want to retreive the Seminar entity using a SQL Query what will the query look like? How will I set the SQLQuery.addEntity and do I need to set SQLQuery.addJoin and how?

Thank you in advance.

Imran

Since nobody is replying I felt necessary to explain the scenario further.

I have a Class called Seminar and Seminar extends Program. I guess HBM file specifies that.

Now when I write SQL for example:

select {seminar.*} from seminar as {seminar}

and from DAO layer I do the following

SQLQuery query = session.createSQLQuery
("select {seminar.*} from seminar as {seminar}");
query.addEntity("seminar", Seminar.class);

hibernate generates the sql with all the property of Seminar and Program where as Program in not in the query it self. So I modified the query to

select {seminar.*}, {program.*} from seminar as {seminar} inner join program as {program} on seminar.id = program.id

Then I hade to add to the query either another entity or join. My understanding is that it should be addJoin but what would be the path, thats simply what I could not figure.
SQLQuery query = session.createSQLQuery
("select {seminar.*} from seminar as {seminar}");
query.addEntity("seminar", Seminar.class);
query.addJoin("program", "path_required_here");


The only possible thing I could guess is that path could be "this". Did not get the time to try but will soon.

Anyways, someone please help its urgent.

Thank you in advance.