Hibernate HQL query with boolean attibute in SAP HANA DB

Hibernate ORM
1

Goodmoring
I have the following situation.
I have a model with a boolean attribute

@Column(name = "ELIMINATO") 
private Boolean eliminato;

and the following HQL query on it

Query q =  session.createQuery("from Sottoscrittore where eliminato = false");

Hibernate generates the following SQL query

select
    ... all fields ...
from
    SOTTOSCRITTORE modulounic0_ 
where
    modulounic0_.ELIMINATO=0

When I run this query the following error is returned

SAP DBTech JDBC: [266]: inconsistent datatype: INT type is not comparable with BOOLEAN type.

The problem is that in SAP HANA DB the correct query is the following

select
    ... all fields ...
from
    SOTTOSCRITTORE 
where
    ELIMINATO=FALSE;

I’m using the following dialect

org.hibernate.dialect.HANAColumnStoreDialect

and my Hibernate version is

4.3.5.Final

How can I solve the problem?
It could be a bug in Hibernate Framework?
Thanks
Regards

2

First of all, Hibernate 4.3 is very old and not supported anymore, so you should definitely upgrade. I bet this was solved in a newer version already. You could subclass the dialect though and override the method toBooleanValueString to return true/false instead of 1/0.

3

Good morning
Unfortunatelly I cannot upgrade my version.
I will override the method toBooleanValueString as you advise me.
Thanks for your answer