Hibernate and boolean mapping from sql query

Question

i have a native sql query to transform (aliasToBean) to a bean with a boolean value.

My query can be something like this:

select val IS NOT NULL as boolValue , ...

or this:

select 1=0 as boolValue, ...

I can not understand how to let Hibernate knows that my bean.boolValue is a Boolan because I get errors in type conversion, in the first case I get a java.math.BigInteger in the second a java.lang.Integer.

Thank you.

JB Nizet · Accepted Answer · 2012-05-28 10:25:31Z

2

You need to tell Hibernate that this column is a boolean, with the SQLQuery.addScalar() method.

answered May 28, 2012 at 10:25

JB Nizet

694k94 gold badges1.3k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tobia Over a year ago

Thank you but how to tell if I have a namedQuery instead of a runtime query?

JB Nizet Over a year ago

There are corresponding return-scalar XML elements, as the javadoc I linked to indicates.

Collectives™ on Stack Overflow

Hibernate and boolean mapping from sql query

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related