Hi all,
I am getting the following error, while executing the procedure.
Please can any one help in this issue.
Error:
Inner Exception:
"FirstBus4_42_0_"
Stack Trace:
" at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) in \NHibernate\\Loader\\Loader.cs:line 1812\r\n at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) in \NHibernate\\Loader\\Loader.cs:line 1718\r\n at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) in \NHibernate\\Loader\\Loader.cs:line 1712\r\n at NHibernate.Loader.Custom.CustomLoader.List(ISessionImplementor session, QueryParameters queryParameters) in \NHibernate\\Loader\\Custom\\CustomLoader.cs:line 288\r\n at NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) in \NHibernate\\Impl\\SessionImpl.cs:line 1714\r\n at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) in \NHibernate\\Impl\\SessionImpl.cs:line 1700\r\n at NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) in \NHibernate\\Impl\\SessionImpl.cs:line 1682\r\n at NHibernate.Impl.SqlQueryImpl.List() in \NHibernate\\Impl\\SqlQueryImpl.cs:line 127\r\n at NHibernate.Persister.Entity.NamedQueryLoader.Load(Object id, Object optionalObject, ISessionImplementor session) in \NHibernate\\Persister\\Entity\\NamedQueryLoader.cs:line 44\r\n at NHibernate.Persister.Entity.AbstractEntityPersister.Load(Object id, Object optionalObject, LockMode lockMode, ISessionImplementor session) in \NHibernate\\Persister\\Entity\\AbstractEntityPersister.cs:line 3356\r\n at NHibernate.Event.Default.DefaultLoadEventListener.LoadFromDatasource(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) in \NHibernate\\Event\\Default\\DefaultLoadEventListener.cs:line 331\r\n at NHibernate.Event.Default.DefaultLoadEventListener.DoLoad(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) in \NHibernate\\Event\\Default\\DefaultLoadEventListener.cs:line 317\r\n at NHibernate.Event.Default.DefaultLoadEventListener.Load(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) in \NHibernate\\Event\\Default\\DefaultLoadEventListener.cs:line 102\r\n at NHibernate.Event.Default.DefaultLoadEventListener.ProxyOrLoad(LoadEvent event, IEntityPersister persister, EntityKey keyToLoad, LoadType options) in \NHibernate\\Event\\Default\\DefaultLoadEventListener.cs:line 158\r\n at NHibernate.Event.Default.DefaultLoadEventListener.OnLoad(LoadEvent event, LoadType loadType) in \NHibernate\\Event\\Default\\DefaultLoadEventListener.cs:line 85\r\n at NHibernate.Impl.SessionImpl.FireLoad(LoadEvent event, LoadType loadType) in \NHibernate\\Impl\\SessionImpl.cs:line 2055\r\n at NHibernate.Impl.SessionImpl.Get(String entityName, Object id) in \NHibernate\\Impl\\SessionImpl.cs:line 1030\r\n at NHibernate.Impl.SessionImpl.Get(Type entityClass, Object id) in \NHibernate\\Impl\\SessionImpl.cs:line 1021\r\n at Mbci.Business.Data.NHibernate.Common.CalendarDefinition.FiscalCalendarDefinition.Manager.NhibProcSampleManager.GetFiscalMonthsByFiscalYearIdProcedure(Int64 fiscalYearId, String& errorCode) in \Mbci.Business.Data.NHibernate\\Common\\CalendarDefinition\\FiscalCalendarDefinition\\Manager\\NhibProcSampleManager.cs:line 74\r\n at Mbci.Business.Presenter.Common.CalendarDefinition.FiscalCalendarDefinition.NhibProcSamplePresenter.InitMonthViewWithSP(Int64 fiscalYearId, String& errorCode) in D:\\F\\Hemanth\\D$\\MBCI\\Latest_MBCI.BTF\\Mbci.Business.Presenter\\Common\\CalendarDefinition\\FiscalCalendarDefinition\\NhibProcSamplePresenter.cs:line 36\r\n at Mbci.Test.RateLoader.CommissionCalculator.CommissionCalculator_Load(Object sender, EventArgs e) in D:\\F\\Hemanth\\D$\\MBCI\\Latest_MBCI.BTF\\Mbci.Test.RateLoader\\CommissionCalculator.cs:line 450\r\n at System.Windows.Forms.Form.OnLoad(EventArgs e)\r\n at System.Windows.Forms.Form.OnCreateControl()\r\n at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)\r\n at System.Windows.Forms.Control.CreateControl()\r\n at System.Windows.Forms.Control.WmShowWindow(Message& m)\r\n at System.Windows.Forms.Control.WndProc(Message& m)\r\n at System.Windows.Forms.ScrollableControl.WndProc(Message& m)\r\n at System.Windows.Forms.ContainerControl.WndProc(Message& m)\r\n at System.Windows.Forms.Form.WmShowWindow(Message& m)\r\n at System.Windows.Forms.Form.WndProc(Message& m)\r\n at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)\r\n at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)\r\n at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)\r\n at System.Windows.Forms.SafeNativeMethods.ShowWindow(HandleRef hWnd, Int32 nCmdShow)\r\n at System.Windows.Forms.Control.SetVisibleCore(Boolean value)\r\n at System.Windows.Forms.Form.SetVisibleCore(Boolean value)\r\n at System.Windows.Forms.Control.set_Visible(Boolean value)\r\n at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)\r\n at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)\r\n at System.Windows.Forms.Application.Run(Form mainForm)\r\n at Mbci.Test.RateLoader.Program.Main() in D:\\F\\Hemanth\\D$\\MBCI\\Latest_MBCI.BTF\\Mbci.Test.RateLoader\\Program.cs:line 18\r\n at System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)\r\n at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)\r\n at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()\r\n at System.Threading.ThreadHelper.ThreadStart_Context(Object state)\r\n at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)\r\n at System.Threading.ThreadHelper.ThreadStart()"
Hbm Configuration
----------------------
<?xml version="1.0" encoding="utf-8" ?>
<!-- Generated by MoreGen 28-Apr-2008 11:27:28 -->
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2"
namespace="Business.Common.CalendarDefinition.FiscalCalendarDefinition"
assembly="Business">
<class name="NhibProcSample" table="Cld_Fcld_FiscalMonths" lazy="true">
<id name="Id" column="FiscalMonthID">
<generator class="native" />
</id>
<property name="StartDate" column="StartDate" />
<property name="EndDate" column="EndDate" />
<property name="FirstBusinessDayofMonth" column="FirstBusinessDayofMonth" />
<property name="NumberofDaysinMonth" column="NumberofDaysinMonth" />
<loader query-ref="NHIB_TEST_PROC"/>
</class>
<sql-query name="NHIB_TEST_PROC" >
<return alias="NHIB_TEST_PROC" class="NhibProcSample">
<return-property name="StartDate" column="StartDate"/>
<return-property name="EndDate" column="EndDate"/>
<return-property name="NumberofDaysinMonth" column="NumberofDaysinMonth"/>
<return-property name="Id" column="FiscalMonthId"/>
</return>
exec NHIB_TEST_PROC ?
</sql-query>
</hibernate-mapping>
C# Code
----------
NhibProcSample nhib = null;
nhib = (NhibProcSample)Session.Get(typeof(NhibProcSample), fiscalYearId);
Login
FAQ
Search