Hi,

I'm new to Hibernate. I developed a search functionality in JDBC. Now I need to convert it in hibernate. For this I'm using Hibernate SQLQuery because I need to join 3 tables.

But I'm facing a difficulty. I've a query like this :

select LOCATION, count(*) from Location_Table location left join st_sensor_table sensor on location.LOCATION = sensor.ST_SENSOR_ID where "+columnName+" like \"%"+ searchText + "%\" group by location.BM_BADGE_AT;

Now for every LOCATION I need count(*). I'm not getting the way out.
Please guide me how to do it.

Thanks in advance.

Wrong forum. This forum is about Hibernate Search - the combination of Lucene and Hibernate to achieve fulltext search. It seems you are asking for plain SQL queries in Hibernate. That's a question for the Hibernate Users forum.