There is a bug. I found in NHIbernate source code and changed
Loader.cs GetFirstLimitParameterCount method text like this:
private int GetFirstLimitParameterCount(Dialect.Dialect dialect,
bool useLimit, bool hasFirstRow, bool useOffset)
{
if (!useLimit) return 0;
if (!dialect.BindLimitParametersFirst) return 0;
if (!dialect.SupportsVariableLimit) return
0; //BUG
return (hasFirstRow && useOffset) ? 2 : 1;
}
now i can use my own dll :)
I hope developers will notice my post and fix this.
On Nov 17, 10:59 am, Erik <[email protected]> wrote:
> Sorry,
>
> I use the ifxdriver and the InformixDialect1000 see below
>
> FluentConfiguration config = Fluently.Configure()
> .Database(
>
> IfxSQLIConfiguration.Informix1000
> .ConnectionString(cnn)
> .Driver<IfxDriver>()
> .ProxyFactoryFactory<ProxyFactoryFactory>()
> //.ShowSql()
> .QuerySubstitutions("true 1, false 0, yes 'Y', no
> 'N'")
> )
>
> Erik
>
> On 16 nov, 13:02, Diego Mijelshon <[email protected]> wrote:
>
> > Again: what dialect and driver are you using?
>
> > Diego
>
> > On Tue, Nov 16, 2010 at 05:51, Erik <[email protected]> wrote:
> > > In my current stack where I use NH 2.1.2 and the contrib linq
> > > provider (and fluent) it works fine in this situation. I am in the
> > > process of upgrading to NH3 with the included Linq provider and faced
> > > this problem.
>
> > > my query is:
>
> > > return Storage.Context<Dossier>()
> > > .Where(x => x.TaakCode == aktieCode &&
> > > (x.TimestampLaatsteWijziging >=
> > > obsoleteFrom) &&
> > > (x.DatumLaatsteBetaling >= obsoleteFrom))
> > > .OrderBy(x => x.AgendaDatum)
> > > .Take(count)
> > > .ToList()
> > > .Cast<IDossier>();
>
> > > I use the list to force the execution.
>
> > > the sql generated is like: select first 33 from tdossiers dossier0_
> > > where dossier0_.taakkode1=? and dossier0_.lts_wijzig>=? and
> > > dossier0_.ltsdatum>=? order by dossier0_.agenda asc
>
> > > I observed here that there are only 3 parameters and the take 33 is
> > > part of the sql with a logical outofrange exception when trying to get
> > > index 3 (see below)
>
> > > The exception is: NHibernate.Exceptions.GenericADOException: could not
> > > execute query
> > > Stacktrace
> > > IBM.Data.Informix.IfxParameterCollection.RangeCheck(Int32 index)
> > > IBM.Data.Informix.IfxParameterCollection.GetParameter(Int32 index)
>
> > > System.Data.Common.DbParameterCollection.System.Collections.IList.get_Item(
> > > Int32
> > > index)
> > > NHibernate.Driver.DriverBase.ExpandQueryParameters(IDbCommand cmd,
> > > SqlString sqlString) in d:\CSharp\NH\nhibernate\src\NHibernate\Driver
> > > \DriverBase.cs: line 222
> > > NHibernate.AdoNet.AbstractBatcher.ExpandQueryParameters(IDbCommand
> > > cmd, SqlString sqlString) in d:\CSharp\NH\nhibernate\src\NHibernate
> > > \AdoNet\AbstractBatcher.cs: line 227
> > > NHibernate.Loader.Loader.PrepareQueryCommand(QueryParameters
> > > queryParameters, Boolean scroll, ISessionImplementor session) in d:
> > > \CSharp\NH\nhibernate\src\NHibernate\Loader\Loader.cs: line 1185
> > > NHibernate.Loader.Loader.DoQuery(ISessionImplementor session,
> > > QueryParameters queryParameters, Boolean returnProxies) in d:\CSharp\NH
> > > \nhibernate\src\NHibernate\Loader\Loader.cs: line 399
>
> > > NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImp
> > > lementor
> > > session, QueryParameters queryParameters, Boolean returnProxies) in d:
> > > \CSharp\NH\nhibernate\src\NHibernate\Loader\Loader.cs: line 236
> > > NHibernate.Loader.Loader.DoList(ISessionImplementor session,
> > > QueryParameters queryParameters) in d:\CSharp\NH\nhibernate\src
> > > \NHibernate\Loader\Loader.cs: line 1665
> > > NHibernate.Loader.Loader.DoList(ISessionImplementor session,
> > > QueryParameters queryParameters) in d:\CSharp\NH\nhibernate\src
> > > \NHibernate\Loader\Loader.cs: line 1674
> > > NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor
> > > session, QueryParameters queryParameters) in d:\CSharp\NH\nhibernate
> > > \src\NHibernate\Loader\Loader.cs: line 1589
> > > NHibernate.Loader.Loader.List(ISessionImplementor session,
> > > QueryParameters queryParameters, ISet`1 querySpaces, IType[]
> > > resultTypes) in d:\CSharp\NH\nhibernate\src\NHibernate\Loader
> > > \Loader.cs: line 1583
> > > NHibernate.Hql.Ast.ANTLR.Loader.QueryLoader.List(ISessionImplementor
> > > session, QueryParameters queryParameters) in d:\CSharp\NH\nhibernate
> > > \src\NHibernate\Hql\Ast\ANTLR\Loader\QueryLoader.cs: line 298
> > > NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.List(ISessionImplementor
> > > session, QueryParameters queryParameters) in d:\CSharp\NH\nhibernate
> > > \src\NHibernate\Hql\Ast\ANTLR\QueryTranslatorImpl.cs: line 110
> > > NHibernate.Engine.Query.HQLQueryPlan.PerformList(QueryParameters
> > > queryParameters, ISessionImplementor session, IList results) in d:
> > > \CSharp\NH\nhibernate\src\NHibernate\Engine\Query\HQLQueryPlan.cs:
> > > line 105
> > > NHibernate.Impl.SessionImpl.List(IQueryExpression queryExpression,
> > > QueryParameters queryParameters, IList results) in d:\CSharp\NH
> > > \nhibernate\src\NHibernate\Impl\SessionImpl.cs: line 658
> > > NHibernate.Impl.SessionImpl.List(IQueryExpression queryExpression,
> > > QueryParameters parameters) in d:\CSharp\NH\nhibernate\src\NHibernate
> > > \Impl\SessionImpl.cs: line 634
> > > NHibernate.Impl.ExpressionQueryImpl.List() in d:\CSharp\NH\nhibernate
> > > \src\NHibernate\Impl\ExpressionQueryImpl.cs: line 63
> > > NHibernate.Linq.NhQueryProvider.ExecuteQuery(NhLinqExpression
> > > nhLinqExpression, IQuery query, NhLinqExpression nhQuery) in d:\CSharp
> > > \NH\nhibernate\src\NHibernate\Linq\NhQueryProvider.cs: line 78
> > > NHibernate.Linq.NhQueryProvider.Execute(Expression expression) in d:
> > > \CSharp\NH\nhibernate\src\NHibernate\Linq\NhQueryProvider.cs: line 27
> > > NHibernate.Linq.NhQueryProvider.Execute[TResult](Expression
> > > expression) in d:\CSharp\NH\nhibernate\src\NHibernate\Linq
> > > \NhQueryProvider.cs: line 102
> > > GetEnumerator()
> > > ctor(IEnumerable`1 collection)
> > > System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
>
> > > logging
> > > System.IndexOutOfRangeException: Invalid index 3 for this
> > > IfxParameterCollection with Count=3.
> > > at IBM.Data.Informix.IfxParameterCollection.RangeCheck(Int32 index)
> > > at IBM.Data.Informix.IfxParameterCollection.GetParameter(Int32
> > > index)
> > > at
>
> > > System.Data.Common.DbParameterCollection.System.Collections.IList.get_Item(
> > > Int32
> > > index)
> > > at NHibernate.Driver.DriverBase.ExpandQueryParameters(IDbCommand
> > > cmd, SqlString sqlString) in d:\CSharp\NH\nhibernate\src\NHibernate
> > > \Driver\DriverBase.cs:line 222
> > > at
> > > NHibernate.AdoNet.AbstractBatcher.ExpandQueryParameters(IDbCommand
> > > cmd, SqlString sqlString) in d:\CSharp\NH\nhibernate\src\NHibernate
> > > \AdoNet\AbstractBatcher.cs:line 227
> > > at NHibernate.Loader.Loader.PrepareQueryCommand(QueryParameters
> > > queryParameters, Boolean scroll, ISessionImplementor session) in d:
> > > \CSharp\NH\nhibernate\src\NHibernate\Loader\Loader.cs:line 1185
> > > at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session,
> > > QueryParameters queryParameters, Boolean returnProxies) in d:\CSharp\NH
> > > \nhibernate\src\NHibernate\Loader\Loader.cs:line 399
> > > at
>
> > > NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImp
> > > lementor
> > > session, QueryParameters queryParameters, Boolean returnProxies) in d:
> > > \CSharp\NH\nhibernate\src\NHibernate\Loader\Loader.cs:line 236
> > > at NHibernate.Loader.Loader.DoList(ISessionImplementor session,
> > > QueryParameters queryParameters) in d:\CSharp\NH\nhibernate\src
> > > \NHibernate\Loader\Loader.cs:line 1665
> > > 3013 [Agent: adapter run thread for test 'TestGetDossiersOpAktieCode'
> > > with id '27f9d1cc-00ec-4692-a778-640c7bf90d28'] WARN
> > > NHibernate.Util.ADOExceptionReporter (null) -
> > > System.IndexOutOfRangeException: Invalid index 3 for this
> > > IfxParameterCollection with Count=3.
> > > at IBM.Data.Informix.IfxParameterCollection.RangeCheck(Int32 index)
> > > at IBM.Data.Informix.IfxParameterCollection.GetParameter(Int32
> > > index)
> > > at
>
> > > System.Data.Common.DbParameterCollection.System.Collections.IList.get_Item(
> > > Int32
> > > index)
> > > at NHibernate.Driver.DriverBase.ExpandQueryParameters(IDbCommand
> > > cmd, SqlString sqlString) in d:\CSharp\NH\nhibernate\src\NHibernate
> > > \Driver\DriverBase.cs:line 222
> > > at
> > > NHibernate.AdoNet.AbstractBatcher.ExpandQueryParameters(IDbCommand
> > > cmd, SqlString sqlString) in d:\CSharp\NH\nhibernate\src\NHibernate
> > > \AdoNet\AbstractBatcher.cs:line 227
> > > at NHibernate.Loader.Loader.PrepareQueryCommand(QueryParameters
> > > queryParameters, Boolean scroll, ISessionImplementor session) in d:
> > > \CSharp\NH\nhibernate\src\NHibernate\Loader\Loader.cs:line 1185
> > > at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session,
> > > QueryParameters queryParameters, Boolean returnProxies) in d:\CSharp\NH
> > > \nhibernate\src\NHibernate\Loader\Loader.cs:line 399
> > > at
>
> > > NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImp
> > > lementor
> > > session, QueryParameters queryParameters, Boolean returnProxies) in d:
> > > \CSharp\NH\nhibernate\src\NHibernate\Loader\Loader.cs:line 236
> > > at NHibernate.Loader.Loader.DoList(ISessionImplementor session,
> > > QueryParameters queryParameters) in d:\CSharp\NH\nhibernate\src
> > > \NHibernate\Loader\Loader.cs:line 1665
> > > 3014 [Agent: adapter run thread for test 'TestGetDossiersOpAktieCode'
> > > with id '27f9d1cc-00ec-4692-a778-640c7bf90d28'] ERROR
> > > NHibernate.Util.ADOExceptionReporter (null) - Invalid index 3 for this
> > > IfxParameterCollection with Count=3.
> > > 3015 [Agent: adapter run thread for test 'TestGetDossiersOpAktieCode'
> > > with id '27f9d1cc-00ec-4692-a778-640c7bf90d28'] DEBUG
> > > NHibernate.Util.ADOExceptionReporter (null) - could not execute query
>
> > > On 14 nov, 14:28, Diego Mijelshon <[email protected]> wrote:
> > > > I'm using NH 2.1.2 withInformixand the contrib Linq provider; Take
> > > works
> > > > fine for me.
> > > > What version,
>
> ...
>
> read more »
--
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.
