Convert SQL to HQL

[Chris Boldon]

How would I convert this query to HQL?

select PMO.PROJECT.PROJECT_ORGANIZATION, count(PROJECT_ORGANIZATION) from PMO.PROJECT group by PROJECT_ORGANIZATION 

This is my mapping:

<hibernate-mapping>
<class name="com.x.pmo.vo.ProjectImpl" table="PROJECT" schema="PMO">
<id name="projectId" type="string">
<column name="project_id" length="15" />
<generator class="assigned" />
</id>
<property name="projectName" type="string">
<column name="project_name" length="45" />
</property>
<property name="projectOrganization" type="string">
<column name="project_organization" length="45" />
</property>
</class>
</hibernate-mapping>

[Scott Johnson]

Except for the table and column names, the SQL and HQL will look identical in this case.

See section 14.6 of the Hibernate manual.
[ November 02, 2006: Message edited by: Scott Johnson ]

[William Eichele]

How about that?

SELECT statistic.* FROM statistic INNER JOIN (SELECT MAX(st_id) AS id FROM statistic WHERE status = 'N' GROUP BY bc_id)  ids ON statistic.st_id = ids.id ORDER BY bussinessprocessID;

Greetings
Will

[William Eichele]

does nobody have an answer? please i need it for the work :>

[Paul Sturrock]

What is the question? I though Chris already had his answer?

[William Eichele]

my problem is that i have to convert this sql query

SELECT statistic.* FROM statistic INNER JOIN (SELECT MAX(st_id) AS id FROM statistic WHERE status = 'N' GROUP BY bc_id)  ids ON statistic.st_id = ids.id ORDER BY bussinessprocessID;

into HQL. I don't need or want , to learn HQL in generally. So i asked if, someone could please help my with that.

[William Eichele]

hello?

[Paul Sturrock]

No one can convert your SQL to HQL without knowing what your mapped objects are called and how they are associated (hence, I'm guessing, the deafening silence).

This should explain how it works.