Hi,

I have tow tables
tabel1 and tabel2

Query


The following statment needs to be executed.
I have gone through the number of Hybernate tutorials but nothing is providing me with correct answer.

I dont want to use HQL for this simple query.

Can you let me know how can we execute this using hibernate.

Hi

Try this.

You must have a property in Table1 class which related to Table2

extract of mapping file

<hibernate-mapping
>
<class
name="lk.wts.test.Table1"
table="Table1"
>

<!-- more -->
<many-to-one
name="table"
class="lk.wts.test.Table2"
cascade="none"
update="false"
insert="false"
lazy="false"
column="id"
/>

</hibernate-mapping>

If it is ok then try this

Criteria crit = sess.createCriteria(Table1.class, "t1")
.add(Restrictions.eqProperty("t1.id","t2.id"))
.createAlias("t1.table", "t2") ;


Amila

(Don't forget to rate)