Re: [hibernate-dev] Forcing an optimize call after a purgeAll

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 <[EMAIL PROTECTED]>: > On Sun, 13 Jul 2008 21:46:05 +0200, John Griffin <[EMAIL PROTECTED]> > wrote: > >> I would not force it, bu

[hibernate-dev] Case...When..then... problem

Hi, I've a query in MySQL which includes CASE WHEN... THEN...THENEND type, which i working fine. select cds.id, case when cds.source_type = 'c' then (select cm.company_name from esi_companymaster cm where cm.company_code = cds.source_id) when cds.source_type = 'd' then (select dm.dea