Hi
I have not understand why you tell that you have 3 tables. HQL is based on
core model (mapping files) not on SQL tables.
You must write the query in hql and you must use objects in your core model
not id :
select dm.id, dm.drug_name, sum(cds.qty_available)
from drug_master dm
sum(cds.qty_available)
from drug_master dm
left join cds_drugstore.drug_master cds
and cds.cds_id = 1
and cds.source_id = 'sourceName'
and cds.source_type = 'c'
group by dm.id
-- next part --
An HTML attachment was scru
#x27;sourceName'
and cds.source_type = 'c'
group by dm.id
-- next part ------
An HTML attachment was scrubbed...
URL:
http://lists.jboss.org/pipermail/hibernate-dev/attachments/20080713/bc5c5c6c
/attachment-0001.html
---
On Sun, 13 Jul 2008 21:46:05 +0200, John Griffin
<[EMAIL PROTECTED]> wrote:
I would not force it, but I would allow it to happen probably by a config
option. As you know optimize causes a rewrite of the Lucene document
numbers
and the user may not want to do that until THEY decide to do it.
