a JIRA for this issue ?thanks.
2008/9/27 Ayende Rahien <[EMAIL PROTECTED]>
> 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?
>> >> >> >>
>> >> >> >>
>> >> >> >
>> >> >> >
>> >> >> > >
>> >> >> >
>> >> >>
>> >> >>
>> >> >
>> >> >
>> >> > >
>> >> >
>> >>
>> >>
>> >
>> >
>> > >
>> >
>>
>>
>>
>
> >
>
--
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
-~----------~----~----~----~------~----~------~--~---
