开发者

Created query is not supported by my DB

开发者 https://www.devze.com 2022-12-31 06:10 出处:网络
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:

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 statem开发者_如何学JAVAent related issues in seam?


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.

0

精彩评论

暂无评论...
验证码 换一张
取 消