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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
