Hibernate version: 3

Mapping documents: hbm files

Name and version of the database you are using: DB2 version 7 on os/390

I am trying to execute the following query


When I try to run this in a session.createQuery I get


I read that I probably need to do a stored procedure execution here http://www.hibernate.org/hib_docs/v3/re ... /#sp_query

But this sqlQuery returns a class and I need a timestamp returned which is basically the timestamp from the database I am operating with.

How can I get this done? Any clues?

Thanks.

T.

When selecting from an unmapped table, you must use sql-query, not query. Equivalently, use Session.createSQLQuery, not Session.createQuery. You'll also need to specify the type of the returned scalar. Both the reference doc and the javadocs are helpful for this.

This is what worked. Thanks for pointing in the right direction