<query name="IRI.GetAccounts"> Mean HQL<sql-query name="IRI.GetAccounts"> Mean SQL
The validation at startup is only an option, you can turnoff it trough session-factory configuration properties. 2009/3/23 Eric <[email protected]> > > I know this is not HQL, it is straight SQL. In our code, the string > query is read in from .hbm.xml mapping file, via > IQuery query = this.Session.GetNamedQuery > ("IRI.GetAccounts"); > > and then the text of the named query is fed into a SQL Command: > SqlCommand command.CommandText = query.QueryString.Replace > (":accountType", "'" + accountType + "'"); > > In NHibernate 2.0, I assume the queries are now validated > automatically and that is why they are failing during initialization > time because they must be HQL?. I can't seem to find any documentation > on how to disable validation of the named queries. > > Thanks > > On Mar 21, 9:05 am, Fabio Maulo <[email protected]> wrote: > > 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 > > > -- 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 -~----------~----~----~----~------~----~------~--~---
