I'm pretty new to Hibernate and am building a search function in a table.
To filter my results, I would have to join on one or more tables that are not mapped to Java objects (since I don't need them anyway in my program).

Is there any way I could do this or must I really create objects an map them?
Or also: Is this possible with HQL without using createSQLQuery?

Thanks

Yes. Use HQL and try a theta-style join. (T1.ID=T2.FOREIGN_ID)

I don't know if i got you right or not but i will assume a situation that might be clse to what you want

Table1 Address
column1 -- > ID (INT)
column2 -- > Street (VarChar)
column3 -- > State_ID (INT)

Table2 State
column1 -- > State_ID (INT)
column1 -- > State_Name (VarChar)

Table2 is the one you don't want
you want your class to look like this

class Address{

private int ID;
private String street;
private string state_name;

}

you can do this by doing a join in the mapping xml file
<class name="Adress" table="Address">
.....
<join table="State">
<key column="State_ID"/>
<property name="state_name" column="State_Name"/>
</join>
.....
</class>
This way you will join the classes without making an objects to them

Hi,

In theta style join can we use left outer join ? In my tables there are no constraints (primarykey,foreign key). I need to use left outer join with two tables that don't have any constraints. Is there some way to do this?
I am using Hibernate 3.2.


thanks,
Tinu

This is the same issue that I already asked for help here. I am still looking for solution.