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/314b525198c09f3d/3611b0b8b134fa46?lnk=gst&q=multiquery#3611b0b8b134fa46 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 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
