Hello
I'm using informix 9.4 database and I try to make a request with a where clause like this :
Code:
"lower(electeur.nomp) like concat(lower(#{electeurcapaList.electeur.nomp}),'%')"
This doesn't work with informix but works well when I use posgresql.
The generated code is the same with either informix or postgresql.
Does anyone has an idee ?
Thanks for your help !
Adrien
Hibernate version: 3.2.5
Name and version of the database you are using:Informix 9.4
The generated SQL (show_sql=true):Code:
select
first 26 electeurca0_.robid as robid0_,
electeurca0_.version as version0_,
electeurca0_.nome as nome0_,
electeurca0_.nomp as nomp0_
from
electeurcapa electeurca0_
where
lower(electeurca0_.nomp) like (lower(?)||'%')
order by
electeurca0_.nomp asc
error
15:01:37,672 WARN [JDBCExceptionReporter] SQL Error: -201, SQLState: 42000
15:01:37,672 ERROR [JDBCExceptionReporter] A syntax error has occurred.
Login
FAQ
Search