Created query is not supported by my DB

Question

I created an application using seam-gen. The created operation to search the DB ends with and exception (syntax error). The query has a where clause like this:

lower(barcode0_.barcode_ean) like lower((?||'%')) limit ?

Does hibnerate or seam create the where clause which my DB can't understand?

Or is there a workaround for SQL statement related issues in seam?

Answer 1

I'm not an expert of Seam but this looks like the problem mentioned in this thread (see also JBSEAM-3297). The suggested solution is use lower(concat instead of concat(lower in seam-gen/src/EntityList.java.ftl.