28 Mar
2007
28 Mar
'07
1:51 a.m.
Guys:
The docs have a problem when installing on postgres, since the manual says
to use the xwiki Xar AFTER a configured Postgres DB, but no script to create
the DB in postgres is given.
Is this an error in the doc or have I not understood properly.
Regards,
Mauricio Hernández Durán
Director de Proyectos
Ingenian Software LTDA.
PBX + 57 (1) 6233606/17 ext 106
Kra 14 #90-31 Ofi 403
Bogotá
-----Mensaje original-----
De: news [mailto:news@sea.gmane.org] En nombre de Zeljko Trogrlic
Enviado el: Martes, 27 de Marzo de 2007 02:33 p.m.
Para: xwiki-users(a)objectweb.org
Asunto: [xwiki-users] Re: Case insensitive search
Vincent Massol wrote:
On Mar 27, 2007, at 4:19 PM, Zeljko Trogrlic wrote:
http://www.hibernate.org/hib_docs/v3/api/org/hibernate/criterion/Restriction
s.html?
Esbach, Brandon <Esbachb@...> writes:
Are you sure there isn't any hibernate-specific solution to the problem?
(which IMO might be better)
What about using something like the ilike in
PostgreSQL treats LIKE queries as case-sensitive;
so to make it
case-insensitive you would have to use ilike (extra i in front of
like) to make it case-insensitive.
ILIKE is PostgreSQL specific. Two UPPERCASE will work on any database. Does anyone know how to use this Expression class in
Hibernate?
Thanks
-Vincent
ILIKE is not in HQL reference. Can somebody running something else than
PostgreSQL test is it working on his system?
If ILIKE doesn't work on other databases, I'll rather keep UPPERs because
fiddling with Hibernate API in Velocity is both impossible and, to my
standards, over-engineered.