I don t want an option for that. Either we do or don't. I guess don't it is. On Jul 13, 2008, at 15:46, "John Griffin" <jgriffin(a)thebluezone.net&gt; 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. 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&gt; > Subject: [hibernate-dev] fullTextSession.purgeAll() > To: hibernate-dev(a)lists.jboss.org > Message-ID: <095C2590-2D16-453D-BF7A-6813612D88A6(a)hibernate.org&gt; > 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&gt; > Subject: [hibernate-dev] Hibernate join problem > To: hibernate-dev(a)lists.jboss.org > Message-ID: > <6c528ebf0807130320n4a8bf728me1a0b7ffd9a3fe92(a)mail.gmail.com&gt; > 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 >

I agree with all of you, if the user wants it he can just call it using a single line of code. So I would not do that automatically. Sanne 2008/7/14 Hardy Ferentschik <hibernate(a)ferentschik.de&gt;: