Vincent Massol wrote: I'm using PostgreSQL as backend, could that be the source of the problem? How actually searching works? Using database functions? If you give me a hint where is it done (in code) I can investigate the problem. It was not clear to me does it replace regular search, thanks for the answer. I will add search box integration to JIRA for future reference, and I think that this should be stated on plugin page, because description is a bit misleading: "It can be used in place of the default search implementation..."

Vincent: search area This is very timely for me, as I was next looking into how to do this, so I am grateful. But it's very puzzling to me that I can't find the actual plugin; I had thought for all this time that it was in the distribution I have (0.9.840), but it isn't. I had been hearing about it for over a year and assumed, like someone earlier in this thread, that it was just an option that needed to be turned on. Furthermore, I haven't been able to download it from the SVN site because (apparently) of firewall issues here - I can see the code, and could probably download it all via the web interface, but that's incredibly tedious, and we also have the 1.0b5 code, so I can get it from there - if indeed it is there - or have I made another incorrect assumption? brain[sic]

Hmm, my origional reply got rejected/did not send for some reason.. Problem is that MySQL is default case-insensitive; so LIKE is working fine for MySQL queries. eg: select doc.name from XWikiDocument doc where doc.fullName like '%thistest' above will be case-insensitive on MySQL. 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. eg: select doc.name from XWikiDocument doc where doc.fullName ilike '%thistest' above (should, far as I can recall) be case-insensitive on PostgreSQL, but again may not work with MySQL. I would have thought Hibernate fixes this kind of discrepency though? ________________________________ From: Sergiu Dumitriu [mailto:sergiu.dumitriu@gmail.com] Sent: 27 March 2007 08:50 To: xwiki-users(a)objectweb.org Subject: Re: [xwiki-users] Re: Case insensitive search On 3/27/07, Zeljko Trogrlic <zeljko_t(a)post.htnet.hr> wrote: I search for "Available." then it this issue I'm using PostgreSQL as backend, could that be the source of the problem? How actually searching works? Using database functions? If you give me a hint where is it done (in code) I can investigate the problem. Check the code for Main.WebSearch , its a series of hibernate hql queries. The string is searched with "where field LIKE '$keyword'", so if LIKE is not case insensitive, this is the cause. I turn on search a search Code area It was not clear to me does it replace regular search, thanks for the answer. I will add search box integration to JIRA for future reference, and I think that this should be stated on plugin page, because description is a bit misleading: "It can be used in place of the default search implementation..." Sergiu -- http://purl.org/net/sergiu

On Mar 27, 2007, at 4:19 PM, Zeljko Trogrlic wrote: 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 http://www.hibernate.org/ hib_docs/v3/api/org/hibernate/criterion/Restrictions.html? Does anyone know how to use this Expression class in Hibernate? Thanks -Vincent

On Mar 27, 2007, at 9:33 PM, Zeljko Trogrlic wrote: I don't think it should be done in Velocity at all. We could do it in Java, in the search implementations. Again, I don't know how this works (or doesn't work) in Hibernate. I'm just making sure we've covered all angles before deciding. Thanks -Vincent

On Mar 28, 2007, at 10:52 AM, Esbach, Brandon wrote: 3.1.2 (check your WEB-INF/lib :-)) Exactly my point. We should investigate this first rather than trying to implement it ourselves and only if it doesn't work then we should think of alternative solutions. Isn't this one purpose of Hibernate (to isolate yourself from the DB)? Thanks -Vincent

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: http://www.hibernate.org/hib_docs/v3/api/org/hibernate/criterion/Restriction s.html? 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.

In case anyone has this problem, we fixed it using a level 3 JDBC driver for postgres and the proper version of the driver (in our case we were using a 7.3 driver with a 7.4 pg server). Aparently xwiki could not populate the initial schemmas and everything went broke from then on. After we changed the driver we could populate a XAR file just like you mention. Thankyou for your help!! On 3/28/07, Zeljko Trogrlic <zeljko_t(a)post.htnet.hr> wrote: -- Mauricio Hernández Durán PBX 6233606/17 ext 106 Kra 14 # 90-31oficina 403 http://www.ingenian.com

Vincent Massol wrote: No, it works fine. I checked it to clarify is problem on my side or in general. I will play with it first. It seems to me that search panel just calls search page. If I put Lucene code there, it should be executed for every search, even from panel.