Right, but if you have named queries that are EXECing stored procedures, and you create a MutliQuery, and add multiple named queries that are using stored procedures, it won't work.
On Jan 30, 9:49 am, Fabio Maulo <[email protected]> wrote: > NamedQueries is not the problem... the problem is inside the MultiQuery > implementation; MultiQuery only accept HQL. > > 2009/1/30 MAMMON <[email protected]> > > > > > > > I thought that ISession.CreateMutliQuery() and > > ISession.CreateMutliCriteria() only worked with HQL queries. Problem > > illustrated in this previous post: > > >http://groups.google.com/group/nhusers/browse_thread/thread/314b52519... > > > Which resulted in this JIRA case: > > >http://jira.nhibernate.org/browse/NH-1508 > > > (From Ayende on the previous nhusers post): > > > "Okay, I found out what was going on. The issue is with multi query > > implementation. It assumes that the query that you pass it is always > > an HQL > > query. > > From a short review of the code, it looks like it would be possible to > > change that, but I don't currently have the time to dedicate to this. > > " > > > I guess this might be different, since you are calling > > IMultiQuery.AddSqlQuery(), not IMultiQuery.AddNamedQuery(). Maybe > > it's only the named queries that only support HQL. I'd like to > > know.... Time to get to work! > > > On Jan 29, 1:44 pm, Ayende Rahien <[email protected]> wrote: > > > You don't need to. > > > > CreateMutliQuery(). > > > .AddSqlQuery("") > > > .AddSqlQuery("exec ReturnsTwoResultSet") > > > > On Thu, Jan 29, 2009 at 3:28 PM, Bill Pierce <[email protected]> wrote: > > > > > In other words, send me a patch for this :) > > > > > On Jan 29, 12:25 pm, Ayende Rahien <[email protected]> wrote: > > > > > yes, that would work. > > > > > My comment was regarding multiple result set from one SP > > > > > > On Thu, Jan 29, 2009 at 3:21 PM, Bill Pierce <[email protected]> > > wrote: > > > > > > > I presumed Ken meant to submit this as single MultiQuery with three > > > > > > Queries. > > > > > > > On Thu, Jan 29, 2009 at 12:17 PM, Ayende Rahien <[email protected] > > > > > wrote: > > > > > > > It wouldn't work. > > > > > > > You would need to hack it with an empty multi query. > > > > > > > > 2009/1/29 Bill Pierce <[email protected]> > > > > > > > >> I haven't, but I have no reason to believe it wouldn't work. > > > > > > > >> I would still consider the above a bug because what happens if I > > > > > > >> execute a single sproc that returns multiple result sets? > > > > > > > >> On Thu, Jan 29, 2009 at 11:56 AM, Ken Egozi <[email protected]> > > > > wrote: > > > > > > >> > have you tried this with multi-query? > > > > > > > >> > On Thu, Jan 29, 2009 at 8:30 PM, Bill Pierce < > > [email protected]> > > > > > > wrote: > > > > > > > >> >> NH 2.1.0.1001 > > > > > > > >> >> session.CreateSQLQuery("EXEC Sproc1; EXEC Sproc2; EXEC > > > > > > >> >> Sproc3;").List().Count == 1 > > > > > > > >> >> Only the results of Sproc1 are returned. > > > > > > > >> >> Is this a bug or am I doing something incorrectly? > > > > > > > >> >> Thanks, > > > > > > >> >> -Bill > > > > > > > >> > -- > > > > > > >> > Ken Egozi. > > > > > > >> >http://www.kenegozi.com/blog > > > > > > >> >http://www.delver.com > > > > > > >> >http://www.musicglue.com > > > > > > >> >http://www.castleproject.org > > > > > > >> >http://www.gotfriends.co.il > > -- > 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 -~----------~----~----~----~------~----~------~--~---
