Hi,
I am new to hibanate,Stuts and Tile. Now I want  to get selected
specified columns. I have mention the code below. It is not working.

List<SelelctItemList> list = new ArrayList<SelelctItemList>();
Query query = (Query) session.createQuery("select
s.item_id,s.name,s.unit_price_sel,s.unit_price_buy,su.quantity
from service_uses as su INNER JOIN stocks as s ON     su.item_id=s.item_id
where service_id="+ serviceId);
list = ((org.hibernate.Query) query).list();

cheers,
Gayan
_______________________________________________
hibernate-dev mailing list
hibernate-dev@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/hibernate-dev

Reply via email to