Call to store procedure with error, plese help.
Hibernate version 1.2:
Mapping documents:
<?xml version="1.0" encoding="utf-8" ?> <hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"> <sql-query name="GetByName"> <return-scalar column="Description" type="String" /> <return-scalar column="Lat" type="Single" /> <return-scalar column="Lon" type="Single" /> <return-scalar column="Name" type="String" /> <return-scalar column="Type" type="String" /> <return-scalar column="Icon" type="String" /> <return-scalar column="Link" type="String" /> <return-scalar column="Image01" type="String" /> <return-scalar column="Image02" type="String" /> <return-scalar column="Image03" type="String" /> <return-scalar column="Image04" type="String" /> <return-scalar column="Image05" type="String" /> exec Bubo.SPFind_RestaurantByName2 :@Lat, :@Lon, :@Radio, :@Name </sql-query> </hibernate-mapping>
Code between sessionFactory.openSession() and session.close():
IQuery query = NHibernateSession.GetNamedQuery("GetByName") .SetSingle("Lat", center.Latitude) .SetSingle("Lon", center.Longitude) .SetSingle("Radio", radio) .SetString("Name", name) .SetResultTransformer( new NHibernate.Transform.AliasToBeanConstructorResultTransformer( typeof(Places).GetConstructors()[0]));
return query.List<Places>() as List<Places>;
Full stack trace of any exception that occurs: QueryException: Named parameter does not appear in Query: Name [exec Bubo.SPFind_RestaurantByName2 ?, ?, ?, ?]] NHibernate.Loader.Custom.CustomLoader.GetNamedParameterLocs(String name) +162 NHibernate.Loader.Loader.GetParameterTypes(QueryParameters parameters, Boolean addLimit, Boolean addOffset) +543 NHibernate.Loader.Loader.PrepareQueryCommand(QueryParameters parameters, Boolean scroll, ISessionImplementor session) +407 NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +257 NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +83 NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +77 NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +46 NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet querySpaces, IType[] resultTypes) +152 NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) +44 NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) +154 NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) +126 NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) +112 NHibernate.Impl.SqlQueryImpl.List() +214 Nizkua.BuboMaps.Data.PlaceDao.GetByName(Center center, Single radio, String name) in E:\Personal\VS2005\Nizkua\NizkuaOne\Nizkua.BuboMaps.Data\PlaceDao.cs:30 _Default.Page_Load(Object sender, EventArgs e) in e:\Personal\VS2005\Nizkua\NizkuaOne\www.bubomaps.com\Pruebas\Default.aspx.cs:33 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34 System.Web.UI.Control.OnLoad(EventArgs e) +99 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061
Name and version of the database you are using: SQL Server 2005 Professional
|