<div>
<div class="content wysiwyg-content">
this is a hibernate question.<br />
<br />
I am not able to find sample hql for doing join involving two tables.<br />
<br />
table item has a (int) userid, which refers to user table. there is a name attribute in the user table.<br />
<br />
I want to do a sorted collection query, in the ascending order of user.name.<br />
<br />
the equivalent sql would be<br />
SELECT * FROM item INNER JOIN user ON item.userid=user.userid ORDER BY user.`name`<br />
<br />
please help me with the corresponding hql.
</div>
</div>


this is a hibernate question.

I am not able to find sample hql for doing join involving two tables.

table item has a (int) userid, which refers to user table. there is a name attribute in the user table.

I want to do a sorted collection query, in the ascending order of user.name.

the equivalent sql would be
SELECT * FROM item INNER JOIN user ON item.userid=user.userid ORDER BY user.`name`

please help me with the corresponding hql.

join using hibernate hql

Java Enterprise Edition (Java EE) is a specification defining a collection of Java-based server and client technologies and how they interoperate. Java EE specifies server and client architectures and uses profiles to define technology sets targeted at specific classes of applications. All Java EE profiles share a set of common features, such as naming and resource injection, packaging rules and security requirements.