[hibernate-dev] Forcing an optimize call after a purgeAll
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. My 2 cents.
John G.
-----Original Message-----
From: hibernate-dev-bounces(a)lists.jboss.org
[mailto:hibernate-dev-bounces@lists.jboss.org] On Behalf Of
hibernate-dev-request(a)lists.jboss.org
Sent: Sunday, July 13, 2008 10:00 AM
To: hibernate-dev(a)lists.jboss.org
Subject: hibernate-dev Digest, Vol 25, Issue 13
Send hibernate-dev mailing list submissions to
hibernate-dev(a)lists.jboss.org
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.jboss.org/mailman/listinfo/hibernate-dev
or, via email, send a message with subject or body 'help' to
hibernate-dev-request(a)lists.jboss.org
You can reach the person managing the list at
hibernate-dev-owner(a)lists.jboss.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of hibernate-dev digest..."
Today's Topics:
1. fullTextSession.purgeAll() (Emmanuel Bernard)
2. Hibernate join problem (sylvain mouquet)
----------------------------------------------------------------------
Message: 1
Date: Sat, 12 Jul 2008 15:57:18 -0400
From: Emmanuel Bernard <emmanuel(a)hibernate.org>
Subject: [hibernate-dev] fullTextSession.purgeAll()
To: hibernate-dev(a)lists.jboss.org
Message-ID: <095C2590-2D16-453D-BF7A-6813612D88A6(a)hibernate.org>
Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
Should we force an optimize call after a purgeAll operation? This
sounds sensible as it will reclaim unused space. OTOH it will likely
break opened readers.
--
Emmanuel Bernard
http://in.relation.to/Bloggers/Emmanuel | http://blog.emmanuelbernard.com
| http://twitter.com/emmanuelbernard
Hibernate Search in Action (http://is.gd/Dl1)
------------------------------
Message: 2
Date: Sun, 13 Jul 2008 12:20:36 +0200
From: "sylvain mouquet" <flashman22(a)gmail.com>
Subject: [hibernate-dev] Hibernate join problem
To: hibernate-dev(a)lists.jboss.org
Message-ID:
<6c528ebf0807130320n4a8bf728me1a0b7ffd9a3fe92(a)mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
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
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