Re: [Hibernate] Postgres, Tsearch2 and Hibernate ? HQL or stick with SQL ?

2009-01-05 Thread Mohamed
Ok, i have now :). Another question I have on my mind. If one performs an SQL query. Will I be able to return the domain object as HQL or GORM would have? select domain from domain where ... Will I be able to use the returned value just like HQL would have returned it, as a domain object? On Mon,

Re: [Hibernate] Postgres, Tsearch2 and Hibernate ? HQL or stick with SQL ?

2009-01-05 Thread Mohamed
Thank you Emmanuel. Can you tell me more about it ? I have spent so much time back and forth deciding on how and what should handle my search. I must say, I remember that his was a possibility now early in my development but none in the grails community have mentioned it as an option when I have br

Re: [Hibernate] Postgres, Tsearch2 and Hibernate ? HQL or stick with SQL ?

2009-01-05 Thread Emmanuel Bernard
It is not possible. But I encourage you to look at Hibernate Search for your full text needs. It does not rely on your database capabilities and works as expected in Grails. Also, please ask your questions at http://forum.hibernate.org Emmanuel On Jan 5, 2009, at 13:30, Mohamed wrote: Hi,

[Hibernate] Postgres, Tsearch2 and Hibernate ? HQL or stick with SQL ?

2009-01-05 Thread Mohamed
Hi, I am new to this list. I have been using Hibernate through Grails and Gorm for a while now and I just switched my DB to Postgres from MySql to take advantage of the fulltext support in PostgresSql. I was wondering if it is possible and if so, how to write HQL queries that involves the TSearch2.