-
1. Re: seam works with informix db
lcsuarezl Mar 3, 2011 5:24 PM (in response to serginho)Sergio maybe you got the answer?
could you help me?I hope!
thx
-
2. Re: seam works with informix db
lcsuarezl Mar 16, 2011 6:28 PM (in response to serginho)How to get Seam working propertly with INFORMIX 9.4
I've tried with so many ORM like Hibernate, OpenJPA, EclipseLink
and none works, the main problem was when I try to do a query with like '%substring%', so I decide change my Restrictions from:"lower(item.id.codigo) like lower(concat('%',concat(#{item.codigo}),'%'))"
and I got my Hibernate query like: like lower(('%'(?)'%'))To
"lower(item.id.codigo) like lower(#{item.codigo})"by this way I got the rendered query like: like lower(?)
but in my input text, the user could use %10% by this way he can
do queries like %10% which was the goal.I've also tried to do some Native Queries, but when Hibernate try to map to the asigned entity crashes..
by the other hand, the em.persist works ok, so I think I'll get success with this project.