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: : 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
and my Hibernate version is
How can I solve the problem?
It could be a bug in Hibernate Framework?