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