Hi,

I'm trying to get this query back:

Query q = aSession.createQuery("select ma.affiliate from ModuleAffiliate ma left join fetch ma.affiliate where ma.module.id = 10");

But for some reason the generated sql puts in a weird comma:

select affiliate1_.id as id0_, (a lotta fields...), affiliate1_.z_updt as z6_11_1_ from module_affiliate moduleaffi0_, left outer join affiliate affiliate1_ on moduleaffi0_.affiliateId=affiliate1_.id where moduleaffi0_.moduleId=10

Just removing the comma at the end of "from module_affiliate moduleaffi0_, " in the statement makes the query work OK in MySQL Query Browser. Am I making a mistake in my HQL that is causing the comma to show up? Thanks for any answers and/or just reading this far!:),

Jim

Hi,

Why don't u do this instead:


Regards,
Edward

What version are you using? There have been a few bugs of that kind fixed in recent versions.

3.1.2

I have seen this when you specify a "fetch" join in HQL and the association (in the mapping) is already a "fetch". As a work-around, remove the key word "FETCH" from HQL.

Curtis ...

Thank you -- removing the fetch and making it a simple join worked out !