[nhibernate-issues] [JIRA] Commented: (NH-741) Invalid parameter handling when using functions

[NHibernate J. <mik...@us...>]

     [ http://jira.nhibernate.org/browse/NH-741?page=comments#action_14179 ]
     
Fabio Maulo commented on NH-741:
--------------------------------

Comment for who have a problem for this issue:
The patch not work if the RDBMS don't accept parameter for every thing else <where expression>.

> Invalid parameter handling when using functions
> -----------------------------------------------
>
>          Key: NH-741
>          URL: http://jira.nhibernate.org/browse/NH-741
>      Project: NHibernate
>         Type: Bug
>   Components: Core
>     Versions: 1.0.2
>     Reporter: Bentzy Lupu
>     Priority: Trivial
>      Fix For: 1.2.0.Beta2

>
> The following query fails because no parameter was defined.
> select category from Category category 
> order by dbo.Localize(category.ResourceKey, :LanguageId, category.Name)
> On SQL Server, the error is:
> NHibernate.ADOException: Could not execute query 
> ---> System.IndexOutOfRangeException: Invalid index 0 for this SqlParameterCollection with Count=0.
>    at System.Data.SqlClient.SqlParameterCollection.RangeCheck(Int32 index)
>    at System.Data.SqlClient.SqlParameterCollection.GetParameter(Int32 index)
>    at System.Data.Common.DbParameterCollection.System.Collections.IList.get_Item(Int32 index)
>    at NHibernate.Type.Int32Type.Set(IDbCommand cmd, Object value, Int32 index)
>    at NHibernate.Type.NullableType.NullSafeSet(IDbCommand cmd, Object value, Int32 index)
>    at NHibernate.Type.NullableType.NullSafeSet(IDbCommand st, Object value, Int32 index, ISessionImplementor session)
>    at NHibernate.Hql.QueryTranslator.BindNamedParameters(IDbCommand ps, IDictionary namedParams, Int32 start, ISessionImplementor session)
>    at NHibernate.Loader.Loader.PrepareQueryCommand(SqlString sqlString, QueryParameters parameters, Boolean scroll, ISessionImplementor session)
>    at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Object optionalObject, Object optionalId, Object[] optionalCollectionKeys, Boolean returnProxies)
>    at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Object optionalObject, Object optionalId, Object[] optionalCollectionKeys, Boolean returnProxies)
>    at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes)
>    at NHibernate.Hql.QueryTranslator.List(ISessionImplementor session, QueryParameters queryParameters)
>    at NHibernate.Impl.SessionImpl.Find(String query, QueryParameters parameters)
>    --- End of inner exception stack trace ---
>    at NHibernate.Impl.SessionImpl.Find(String query, QueryParameters parameters)
>    at NHibernate.Impl.QueryImpl.List()
>    at Lib.NHRepository.FindAll[T](String hql, KeyValuePair`2[] parameters) in D:\Proj\Test\Lib\NHRepository.cs:line 34
> This query, however, pass successfully:
> select category from Category category where :LanguageId = :LanguageId
> order by dbo.Localize(ResourceKey, @p0, Name)
> The expected result should be either an error for not recognizing the function, or successfully handling this.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.nhibernate.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira