Hello

I am fairly new to Hibernate . I would like to execute the following query and I am constructing a HSQL statement for it.

Select
value1 as X1,
null as X2
from
TEST_TABLE

I have the TEST_TABLE mapped to a TEST_OBJECT. The following HSQL statement fails

select
new TEST_OBJECT (
value1Obj,
null
) from
TEST_OBJECT

This fails with an exception Invalid alias null for Query.Could someone help me with this.


Thanks

Why don't you create a constructor that doesn't take the 2nd argument and sets the field to NULL for you ?

And BTW: TEST_OBJECT, while valid, is not a very good name for a Java Class based on generally accepted practices.

Thank you very much for the quick response.

The select statement was just an example. I have the class name different in my application.

Wondering if there is any aggregate function to set null for columns selected forcibly.


Regards