Id like to configure a join between 2 tables, however the join should contain an additional where clause similar to how a bag can be configured. Is this possible?

Id like to do something like the following:

<join table="ADDRESS" where="OUTCOME_ID <> 'O'">
<key column="ADDRESS_ID"/>
</join>

Unfortunately I have no control over the database schema so cannot make changes to the table structure.

Hey Try this ..


Query query = session.createQuery("from Admin admin inner join Customer cust where cust.Name ='Niks'");
query.addEntity(Admin.class);
query.setInteger("username",'"niks');
List =query.list();

This is an native SQL query so you can run it in MySQL query browser for example. You don't use the objects that wrap the tables in the query so any column names are actual table column names and not the names used for the columns in the object. eg cust_id instead of custId. You must define the class to map result to with addEntity. You can define multiple classes as well.

This works like a charm. It is better for maintainability to define this as a named query in the hbm.xml file