Hi Guys,

Can anybody tell me what could be the best way of storing hibernate queries efficiently ? As of now we are storing it in the class as Public Static final String ..but could there be any better way of doing it. We want to access the same Hql Query from differnt lcoations in our project.

Any help would be greatly appreciated.

I think better to configure all hibernate Queries into hbm file.
If u configure in java file we need to compile that java file for each change .

Thanks,

shekhar.

Hi thanks for the response. But I couldn't understand on how to configure queries on hbm files. Can you point out any example or related links ?

eg: OneStop.hbm.xml

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>
<class name="com.meijer.foodlab.model.domain.OneStop" table="fl_onestop">
<id name="id" type="java.lang.Integer">
<column name="onestop_id" />
<generator class="native" />
</id>

<!-- provide property mapping here --->

</class>

<query name="findByPromotionId">
select onestop FROM OneStop onestop inner join onestop.promotions promotion where promotion.promotionId = :pPromotionId
</query>
</hibernate-mapping>


now get the query string in your dao and execute the query using the following code

Session s = HibernateSupport.currentSession();
Query q = s.getNamedQuery("findByPromotionId");
List lList=q.list();


thanks,

shekhar.