union allis not HQL 2009/3/21 Fabio Maulo <[email protected]>
> Activate the log WARN and take a look therefor example > (select Id from IRINames where Type = :accountType) > this part is not HQL. > > 2009/3/20 Eric <[email protected]> > > >> Hi- >> We are investigating upgrading from NH 1.2 to 2.0. After fixing all of >> the namespace changes, I am getting an error with the named queries. >> In 1.2 they worked fine, now I get a runtime error with the following >> message: >> >> Errors in named queries: {IRI.GetAccounts}.... for all of the named >> queries. Below is the first named query: >> <query name="IRI.GetAccounts"> >> >> select r.RetailerId as Id, r.Name, b.BannerId, b.Name as >> BannerName, >> map.AccountId, 'Banner' as 'Type', names.IsMviActive as IsMviActive >> from IRIMapping map >> join IRINames names >> on names.Id = map.AccountId >> join Retailer r >> on r.RetailerId = map.RetailerId >> join Banner b >> on b.BannerId = map.BannerId >> where map.RetailerId is not null and map.BannerId is not >> null >> and map.AccountId in (select Id from IRINames where Type >> = :accountType) >> union all >> select r.RetailerId as Id, r.Name, '0' as BannerId, '0' as >> BannerName, map.AccountId, 'Retailer' as 'Type', names.IsMviActive as >> IsMviActive >> from IRIMapping map >> join IRINames names >> on names.Id = map.AccountId >> join Retailer r >> on r.RetailerId = map.RetailerId >> where map.RetailerId is not null and map.BannerId is null >> and map.AccountId in (select Id from IRINames where Type >> = :accountType) >> union all >> select f.FormatId as Id, f.Name, '0' as BannerId, '0' as >> BannerName, >> map.AccountId, 'Format' as 'Type', names.IsMviActive as IsMviActive >> from IRIMapping map >> join IRINames names >> on names.Id = map.AccountId >> join Format f >> on f.FormatId = map.FormatId >> where map.AccountId in (select Id from IRINames where Type >> = :accountType) >> union all >> select ch.ChannelId as Id, ch.Name, '0' as BannerId, '0' as >> BannerName, map.AccountId, 'Channel' as 'Type', names.IsMviActive as >> IsMviActive >> from IRIMapping map >> join IRINames names >> on names.Id = map.AccountId >> join Channel ch >> on ch.ChannelId = map.ChannelId >> where map.AccountId in (select Id from IRINames where Type >> = :accountType) >> order by Name, BannerName >> >> </query> >> >> >> This query runs fine in SQL 2005 Management stuido. the :accountType >> variables are actually done through a string replacement before >> running they query. >> >> Some of the queries, however do not have any variables at all, and >> those are still listed in the error. >> >> what changed between 1.2 and 2.0 that would cause the named queries to >> not work? I can't seem to find any documentation on it. >> >> Thanks >> >> Eric >> >> >> >> > > > -- > Fabio Maulo > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
