Hello,

I need construct select, when return java objects with constructor, but in constructor I want put some no-SQL variable, for example I have ViewClass:

public class ViewClass {

private Long id;
private String name;
private Timestamp date;
boolean timeout;

public ViewClass (Long id, String name, Timestamp date, long timeout) {
this.id = id;
this.name=name;
this.date=date;
if (timeout>date.getTime()) this.timeout=true;
else this.timeout=false;
}

}

and want create select what:

select new ViewClass(tab.id, tab.name, tab.date, 123456789) from MyTable tab

I have problem with last constructor parameter, Hibernate not accept this select construction. Have someone idea for solution this problem?

M. Demian

Since it is a constant, why push it into hql?
Simply set it on the java object.

More correct, this is not constant, but variable what:

long time = <exp.>;

session.createQuery("select new ViewClass(tab.id, tab.name, tab.date, " + time + ") from MyTable tab");

The same stuff.

Yes, of course,

but this select not return only one object, but list of objects. I looking for better solution when evade requirement iterate this list and call setTime for all objects.

But if no exist other solution, I must accept iterating solution :-(

Push this code into the ViewClass constructor.
Or implement your own interceptor.

or just use hibernate 3.1 where that query will work.