I have such sql:

SELECT * FROM Alpha INNER JOIN (SELECT MAX(created) AS pcreated FROM Alpha GROUP BY id) ids ON created = ids.pcreated WHERE id = '100' ORDER BY created DESC

How could I pass this to session in order to retrive data from db?

ERROR: , expected in SELECT

Thanks.

session.createSQLQuery(...);

see: http://www.hibernate.org/hib_docs/v3/reference/en/html/querysql.html#querysql-creating

By(te)!!!

-

Please don't forget to credit ,-)

Thank ypu for reply.

But could you please give me a link to Hibernate 2.0 (that I'm currently use) API to resolve this problem. In 2.0 release there is no createSQLQuery method in Session.

Thanks.

[url]http://www.hibernate.org/hib_docs/api/net/sf/hibernate/Session.html#createSQLQuery(java.lang.String,%20java.lang.String[],%20java.lang.Class[])[/url]

Is this what do you want?

Hi

-

Please don't forget to credit ,-)

Thanks again.

I've noticed that Session.createSQLQuery is available since 2.1 version...
So, is there any workaround to do it WITHOUT createSQLQuery method? :)

Thanks!

session.getConnection()

Then use the usual JDBC way of passing a query and getting a resultset.

Well, but I need to retrieve list of object entities...

Is there any reason why you can't use HQL?

Yes :)

When I try to do createQuery with:

SELECT * FROM Alpha INNER JOIN (SELECT MAX(created) AS pcreated FROM Alpha GROUP BY id) ids ON created = ids.pcreated WHERE id = '100' ORDER BY created DESC

I have exception: , expected in SELECT

Ah ha.

The * threw me as it's not valid HQL afaik. You're querying objects not values. Without mapping I couldn't hazard a gues at how to write a valid HQL query for what you want.