Session.Connection.CreateCommand()
On Sat, Sep 27, 2008 at 2:11 PM, Jamie Fraser <[EMAIL PROTECTED]>wrote:
>
> Okay - thanks for finding this out for me. Are there other batching
> options open to me? Essentially I just want to execute 2 named queries
> with the minimum of overhead....
>
> On Sat, Sep 27, 2008 at 5:22 AM, Ayende Rahien <[EMAIL PROTECTED]> wrote:
> > 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.
> >
> >
> > On Thu, Sep 25, 2008 at 4:01 PM, Jamie Fraser <[EMAIL PROTECTED]>
> > wrote:
> >>
> >> Damn, not having much luck.. Castle bug yesterday and this today!
> >>
> >> Test case attached - just remember and point it to any local DB via
> >> hibernate.cfg.xml (the named queries are very simple, they don't
> >> actually hit any tables so it won't matter which DB NH points to).
> >>
> >> -Jamie
> >>
> >> On Thu, Sep 25, 2008 at 1:32 PM, Ayende Rahien <[EMAIL PROTECTED]>
> wrote:
> >> > This looks like a bug, please create a stand alone test case for this.
> >> >
> >> > On Thu, Sep 25, 2008 at 3:30 PM, Jamie Fraser <[EMAIL PROTECTED]
> >
> >> > wrote:
> >> >>
> >> >> Okay, when I have 2 named queries (declared like:
> >> >>
> >> >> var fullTextSearchQuery =
> >> >> session.GetNamedQuery("FullTextSearch")
> >> >>
> >> >>
> >> >>
> .SetResultTransformer(Transformers.AliasToBean(typeof(SearchResultItem)))
> >> >> .SetString("SearchString", searchString)
> >> >> .SetInt32("PageSize", searchParams.NumberResults)
> >> >> .SetInt32("PageNumber", searchParams.PageNumber);
> >> >>
> >> >> var fullTextCountQuery =
> session.GetNamedQuery("FullTextCount")
> >> >> .SetString("SearchString", searchString)
> >> >> .SetInt32("PageSize", searchParams.NumberResults)
> >> >> .SetInt32("PageNumber", searchParams.PageNumber);
> >> >>
> >> >> They both work fine.
> >> >>
> >> >> However if I do
> >> >>
> >> >> var results = session.CreateMultiQuery()
> >> >> .AddNamedQuery("FullTextSearch")
> >> >> .AddNamedQuery("FullTextCount")
> >> >> .SetString("SearchString", searchString)
> >> >> .SetInt32("PageSize", searchParams.NumberResults)
> >> >> .SetInt32("PageNumber", searchParams.PageNumber)
> >> >> .List();
> >> >>
> >> >> I get an error saying "query must begin with SELECT or FROM"
> >> >>
> >> >> What am I doing wrong?
> >> >>
> >> >> On Thu, Sep 25, 2008 at 9:05 AM, Ayende Rahien <[EMAIL PROTECTED]>
> >> >> wrote:
> >> >> > NHibernate will not understand 2 results sets. You will have to
> deal
> >> >> > with
> >> >> > that manually.
> >> >> > You can turn that into two different queries and call them using
> >> >> > multi
> >> >> > query, however.
> >> >> >
> >> >> > On Thu, Sep 25, 2008 at 11:04 AM, Jamie Fraser
> >> >> > <[EMAIL PROTECTED]>
> >> >> > wrote:
> >> >> >>
> >> >> >> I'm trying to execute a stored procedure (I've also tried
> modifying
> >> >> >> this into a SQL statement and called it via a named query) which
> >> >> >> returns 2 result sets.
> >> >> >>
> >> >> >> First result set is the data (search results, essentially).
> >> >> >> Second result set is the count of results.
> >> >> >>
> >> >> >> I'm not sure if a Multiquery is the right thing to use - from what
> I
> >> >> >> understand a MQ will allow me to execute N queries in a batch and
> >> >> >> present single results for each one, whereas I want to execute a
> >> >> >> single query and get 2 results from it.
> >> >> >>
> >> >> >> Can anyone advise what to do?
> >> >> >>
> >> >> >>
> >> >> >
> >> >> >
> >> >> > >
> >> >> >
> >> >>
> >> >>
> >> >
> >> >
> >> > >
> >> >
> >>
> >>
> >
> >
> > >
> >
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
