http://jira.nhibernate.org/browse/NH-1508
(I don't think anyone else added it so I did).
On Sat, Sep 27, 2008 at 1:23 PM, Fabio Maulo <[EMAIL PROTECTED]> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
