|
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
|
Login
FAQ
Search