-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 
Author Message
 Post subject: NHibernate.MappingException
PostPosted: Mon May 15, 2006 1:28 pm 
Newbie

Joined: Sun May 14, 2006 11:10 pm
Posts: 2
Hibernate version:
1.0.2
Mapping documents:
<?xml version="1.0" encoding="utf-8"?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.0">
<class name="bms.db.MenuModel,bms" table="menu">
<id name="MenuId" type="System.Int64">
<column name="menuID" />
<generator class="identity" />
</id>
<property name="Menucd" column="menuCd" type="string" />
<property name="Menuname" column="menuName" type="string" />
<property name="Menutext" column="menuText" type="string" not-null="true" />
<property name="Menulevel" column="menuLevel" type="Int16" not-null="true" />
<property name="Parent" column="parent" type="string" />
<property name="pos" column="pos" type="Int16" />
<property name="Url" column="url" type="string" />
<property name="Leaf" column="leaf" type="Int16" />
</class>
</hibernate-mapping>
Code between sessionFactory.openSession() and session.close():

ICriteria ic = session.CreateCriteria(typeof(MenuModel));
ic.Add(Expression.In("MenuId",Ids));
ic.Add(Expression.IsNull("Parent"));
ic.AddOrder(new Order("pos",true));

IList queryMenu = ic.List();
Full stack trace of any exception that occurs:
> bms.dll!bms.db.MenuModel.set_Menuname(string value = "系统管理") 行49 C#
kj1sphes!NHibernate.Persister.GetSetHelper_bms_db_MenuModel.SetPropertyValues(System.Object obj = {bms.db.MenuModel}, System.Object[] values = {Length=8}) + 0xe8 字节
nhibernate.dll!NHibernate.Persister.AbstractEntityPersister.SetPropertyValues(System.Object obj, System.Object[] values) + 0x72 字节
nhibernate.dll!NHibernate.Impl.SessionImpl.InitializeEntity(System.Object obj) + 0x158 字节
nhibernate.dll!NHibernate.Loader.Loader.InitializeEntitiesAndCollections(System.Collections.IList hydratedObjects, System.Object resultSetId, NHibernate.Engine.ISessionImplementor session) + 0xdf 字节
nhibernate.dll!NHibernate.Loader.Loader.DoQuery(NHibernate.Engine.ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters, System.Object optionalObject, System.Object optionalId, System.Object[] optionalCollectionKeys, bool returnProxies) + 0x2d0 字节
nhibernate.dll!NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(NHibernate.Engine.ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters, System.Object optionalObject, System.Object optionalId, System.Object[] optionalCollectionKeys, bool returnProxies) + 0x4c 字节
nhibernate.dll!NHibernate.Loader.Loader.List(NHibernate.Engine.ISessionImplementor session, NHibernate.Engine.QueryParameters queryParameters, Iesi.Collections.ISet querySpaces, NHibernate.Type.IType[] resultTypes) + 0x113 字节
nhibernate.dll!NHibernate.Loader.CriteriaLoader.List(NHibernate.Engine.ISessionImplementor session) + 0x286 字节
nhibernate.dll!NHibernate.Impl.SessionImpl.Find(NHibernate.Impl.CriteriaImpl criteria) + 0x17c 字节
nhibernate.dll!NHibernate.Impl.CriteriaImpl.List() + 0xd 字节
bms.dll!bms.Sys.DAO.MenuDao.QueryHeaderMenu(long[] Ids = {Length=2}) 行90 + 0x10 字节 C#
bms.dll!bms.Sys.Business.MenuBusiness.QueryHeaderMenu(long[] Ids = {Length=2}) 行94 + 0x1f 字节 C#
bms.dll!bms.Sys.Business.UserBusiness.LogSession(System.Collections.IList userList = {Count=1}) 行149 + 0x1f 字节 C#
bms.dll!bms.Sys.Business.UserBusiness.SearchUserLogin(string loginUserId = "admin", string password = "123") 行69 C#
bms.dll!bms.Sys.login.btnLogin_Click(System.Object sender = {Text="登录"}, System.EventArgs e = {System.EventArgs}) 行96 + 0x22 字节 C#
system.web.dll!System.Web.UI.WebControls.Button.OnClick(System.EventArgs e) + 0x6d 字节
system.web.dll!System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(string eventArgument) + 0x3b 字节
system.web.dll!System.Web.UI.Page.RaisePostBackEvent(System.Web.UI.IPostBackEventHandler sourceControl, string eventArgument) + 0x13 字节
system.web.dll!System.Web.UI.Page.RaisePostBackEvent(System.Collections.Specialized.NameValueCollection postData) + 0x22 字节
system.web.dll!System.Web.UI.Page.ProcessRequestMain() + 0x4fe 字节
system.web.dll!System.Web.UI.Page.ProcessRequest() + 0x76 字节
system.web.dll!System.Web.UI.Page.ProcessRequest(System.Web.HttpContext context) + 0x13 字节
system.web.dll!CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() + 0xb4 字节
system.web.dll!System.Web.HttpApplication.ExecuteStep(System.Web.HttpApplication.IExecutionStep step, bool completedSynchronously) + 0x58 字节
system.web.dll!System.Web.HttpApplication.ResumeSteps(System.Exception error) + 0xf3 字节
system.web.dll!System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(System.Web.HttpContext context, System.AsyncCallback cb, System.Object extraData) + 0xe3 字节
system.web.dll!System.Web.HttpRuntime.ProcessRequestInternal(System.Web.HttpWorkerRequest wr) + 0x1e7 字节
system.web.dll!System.Web.HttpRuntime.ProcessRequest(System.Web.HttpWorkerRequest wr) + 0xb0 字节
system.web.dll!System.Web.Hosting.ISAPIRuntime.ProcessRequest(int ecb, int iWRType) + 0x65 字节


Name and version of the database you are using:
Microsoft SQL Server 2000 - Personal Edition on Windows NT 5.1 (Build 2600: Service Pack 2)


The generated SQL (show_sql=true):

this?
exec sp_executesql N'SELECT this.menuID as menuID0_, this.url as url0_, this.parent as parent0_, this.menuText as menuText0_, this.menuName as menuName0_, this.pos as pos0_, this.menuLevel as menuLevel0_, this.leaf as leaf0_, this.menuCd as menuCd0_ FROM menu this WHERE this.menuID in (@p0, @p1) and this.parent is null ORDER BY this.pos asc', N'@p0 bigint,@p1 bigint', @p0 = 1, @p1 = 2

Debug level Hibernate log excerpt:


this?
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl..ctor(:0) NHibernate.Impl.SessionImpl..ctor(:0) [(null)] - opened session e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushEverything(:0) NHibernate.Impl.SessionImpl.FlushEverything(:0) [(null)] - flushing session e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushEntities(:0) NHibernate.Impl.SessionImpl.FlushEntities(:0) [(null)] - Flushing entities and processing referenced collections e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushCollections(:0) NHibernate.Impl.SessionImpl.FlushCollections(:0) [(null)] - Processing unreferenced collections e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushCollections(:0) NHibernate.Impl.SessionImpl.FlushCollections(:0) [(null)] - scheduling collection removes/(re)creates/updates e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushEverything(:0) NHibernate.Impl.SessionImpl.FlushEverything(:0) [(null)] - Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushEverything(:0) NHibernate.Impl.SessionImpl.FlushEverything(:0) [(null)] - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.AutoFlushIfRequired(:0) NHibernate.Impl.SessionImpl.AutoFlushIfRequired(:0) [(null)] - dont need to execute flush e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.LogOpenPreparedCommand(:0) NHibernate.Impl.BatcherImpl.LogOpenPreparedCommand(:0) [(null)] - Opened new IDbCommand, open IDbCommands :1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.Generate(:0) NHibernate.Impl.BatcherImpl.Generate(:0) [(null)] - Building an IDbCommand object for the SqlString: SELECT this.User_Id as User_Id0_, this.User_Name as User_Name0_, this.User_Status as User_Sta5_0_, this.Password as Password0_, this.Comment as Comment0_, this.Email as Email0_ FROM Users this WHERE 1=1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.GetResultSet(:0) NHibernate.Loader.Loader.GetResultSet(:0) [(null)] - SELECT this.User_Id as User_Id0_, this.User_Name as User_Name0_, this.User_Status as User_Sta5_0_, this.Password as Password0_, this.Comment as Comment0_, this.Email as Email0_ FROM Users this WHERE 1=1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.Log(:0) NHibernate.Impl.BatcherImpl.Log(:0) [(null)] - SELECT this.User_Id as User_Id0_, this.User_Name as User_Name0_, this.User_Status as User_Sta5_0_, this.Password as Password0_, this.Comment as Comment0_, this.Email as Email0_ FROM Users this WHERE 1=1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Connection.DriverConnectionProvider.GetConnection(:0) NHibernate.Connection.DriverConnectionProvider.GetConnection(:0) [(null)] - Obtaining IDbConnection from Driver e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.LogOpenReader(:0) NHibernate.Impl.BatcherImpl.LogOpenReader(:0) [(null)] - Opened Reader, open Readers :1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.DoQuery(:0) NHibernate.Loader.Loader.DoQuery(:0) [(null)] - processing result set e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.GetRow(:0) NHibernate.Loader.Loader.GetRow(:0) [(null)] - result row: 2 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.LoadFromResultSet(:0) NHibernate.Loader.Loader.LoadFromResultSet(:0) [(null)] - Initializing object from DataReader: 2 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.Hydrate(:0) NHibernate.Loader.Loader.Hydrate(:0) [(null)] - Hydrating entity: bms.db.BasicUserModel#2 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.DoQuery(:0) NHibernate.Loader.Loader.DoQuery(:0) [(null)] - done processing result set (1 rows) e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Driver.NHybridDataReader.Dispose(:0) NHibernate.Driver.NHybridDataReader.Dispose(:0) [(null)] - running NHybridDataReader.Dispose() e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.LogCloseReader(:0) NHibernate.Impl.BatcherImpl.LogCloseReader(:0) [(null)] - Closed Reader, open Readers :0 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.LogClosePreparedCommand(:0) NHibernate.Impl.BatcherImpl.LogClosePreparedCommand(:0) [(null)] - Closed IDbCommand, open IDbCommands :0 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.InitializeEntitiesAndCollections(:0) NHibernate.Loader.Loader.InitializeEntitiesAndCollections(:0) [(null)] - total objects hydrated: 1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.InitializeEntity(:0) NHibernate.Impl.SessionImpl.InitializeEntity(:0) [(null)] - resolving associations for: [bms.db.BasicUserModel#2] e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.InitializeEntity(:0) NHibernate.Impl.SessionImpl.InitializeEntity(:0) [(null)] - done materializing entity [bms.db.BasicUserModel#2] e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.InitializeNonLazyCollections(:0) NHibernate.Impl.SessionImpl.InitializeNonLazyCollections(:0) [(null)] - initializing non-lazy collections e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushEverything(:0) NHibernate.Impl.SessionImpl.FlushEverything(:0) [(null)] - flushing session e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushEntities(:0) NHibernate.Impl.SessionImpl.FlushEntities(:0) [(null)] - Flushing entities and processing referenced collections e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushCollections(:0) NHibernate.Impl.SessionImpl.FlushCollections(:0) [(null)] - Processing unreferenced collections e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushCollections(:0) NHibernate.Impl.SessionImpl.FlushCollections(:0) [(null)] - scheduling collection removes/(re)creates/updates e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushEverything(:0) NHibernate.Impl.SessionImpl.FlushEverything(:0) [(null)] - Flushed: 0 insertions, 0 updates, 0 deletions to 1 objects e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushEverything(:0) NHibernate.Impl.SessionImpl.FlushEverything(:0) [(null)] - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.Printer.ToString(:0) NHibernate.Impl.Printer.ToString(:0) [(null)] - listing entities: e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.Printer.ToString(:0) NHibernate.Impl.Printer.ToString(:0) [(null)] - bms.db.BasicUserModel{UserName=admin, UserId=2, Status=0, Password=123, Comment=null, Email=null} e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.AutoFlushIfRequired(:0) NHibernate.Impl.SessionImpl.AutoFlushIfRequired(:0) [(null)] - dont need to execute flush e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.LogOpenPreparedCommand(:0) NHibernate.Impl.BatcherImpl.LogOpenPreparedCommand(:0) [(null)] - Opened new IDbCommand, open IDbCommands :1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.Generate(:0) NHibernate.Impl.BatcherImpl.Generate(:0) [(null)] - Building an IDbCommand object for the SqlString: SELECT this.urId as urId0_, this.userId as userId0_, this.roleId as roleId0_ FROM user_role this WHERE this.userId = :this.userId e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.GetResultSet(:0) NHibernate.Loader.Loader.GetResultSet(:0) [(null)] - SELECT this.urId as urId0_, this.userId as userId0_, this.roleId as roleId0_ FROM user_role this WHERE this.userId = @p0 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.Log(:0) NHibernate.Impl.BatcherImpl.Log(:0) [(null)] - SELECT this.urId as urId0_, this.userId as userId0_, this.roleId as roleId0_ FROM user_role this WHERE this.userId = @p0 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.Log(:0) NHibernate.Impl.BatcherImpl.Log(:0) [(null)] - @p0 = '2' e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.LogOpenReader(:0) NHibernate.Impl.BatcherImpl.LogOpenReader(:0) [(null)] - Opened Reader, open Readers :1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.DoQuery(:0) NHibernate.Loader.Loader.DoQuery(:0) [(null)] - processing result set e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.GetRow(:0) NHibernate.Loader.Loader.GetRow(:0) [(null)] - result row: 1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.LoadFromResultSet(:0) NHibernate.Loader.Loader.LoadFromResultSet(:0) [(null)] - Initializing object from DataReader: 1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.Hydrate(:0) NHibernate.Loader.Loader.Hydrate(:0) [(null)] - Hydrating entity: bms.db.UserRoleModel#1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.DoQuery(:0) NHibernate.Loader.Loader.DoQuery(:0) [(null)] - done processing result set (1 rows) e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Driver.NHybridDataReader.Dispose(:0) NHibernate.Driver.NHybridDataReader.Dispose(:0) [(null)] - running NHybridDataReader.Dispose() e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.LogCloseReader(:0) NHibernate.Impl.BatcherImpl.LogCloseReader(:0) [(null)] - Closed Reader, open Readers :0 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.LogClosePreparedCommand(:0) NHibernate.Impl.BatcherImpl.LogClosePreparedCommand(:0) [(null)] - Closed IDbCommand, open IDbCommands :0 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.InitializeEntitiesAndCollections(:0) NHibernate.Loader.Loader.InitializeEntitiesAndCollections(:0) [(null)] - total objects hydrated: 1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.InitializeEntity(:0) NHibernate.Impl.SessionImpl.InitializeEntity(:0) [(null)] - resolving associations for: [bms.db.UserRoleModel#1] e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.InitializeEntity(:0) NHibernate.Impl.SessionImpl.InitializeEntity(:0) [(null)] - done materializing entity [bms.db.UserRoleModel#1] e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.InitializeNonLazyCollections(:0) NHibernate.Impl.SessionImpl.InitializeNonLazyCollections(:0) [(null)] - initializing non-lazy collections e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.Close(:0) NHibernate.Impl.SessionImpl.Close(:0) [(null)] - closing session e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.Disconnect(:0) NHibernate.Impl.SessionImpl.Disconnect(:0) [(null)] - disconnecting session e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Connection.ConnectionProvider.CloseConnection(:0) NHibernate.Connection.ConnectionProvider.CloseConnection(:0) [(null)] - Closing connection e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.AfterTransactionCompletion(:0) NHibernate.Impl.SessionImpl.AfterTransactionCompletion(:0) [(null)] - transaction completion e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl..ctor(:0) NHibernate.Impl.SessionImpl..ctor(:0) [(null)] - opened session e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.SqlCommand.SqlSelectBuilder.ToSqlString(:0) NHibernate.SqlCommand.SqlSelectBuilder.ToSqlString(:0) [(null)] - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 9 for the table RoleMenu this e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushEverything(:0) NHibernate.Impl.SessionImpl.FlushEverything(:0) [(null)] - flushing session e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushEntities(:0) NHibernate.Impl.SessionImpl.FlushEntities(:0) [(null)] - Flushing entities and processing referenced collections e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushCollections(:0) NHibernate.Impl.SessionImpl.FlushCollections(:0) [(null)] - Processing unreferenced collections e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushCollections(:0) NHibernate.Impl.SessionImpl.FlushCollections(:0) [(null)] - scheduling collection removes/(re)creates/updates e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushEverything(:0) NHibernate.Impl.SessionImpl.FlushEverything(:0) [(null)] - Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushEverything(:0) NHibernate.Impl.SessionImpl.FlushEverything(:0) [(null)] - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.AutoFlushIfRequired(:0) NHibernate.Impl.SessionImpl.AutoFlushIfRequired(:0) [(null)] - dont need to execute flush e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.LogOpenPreparedCommand(:0) NHibernate.Impl.BatcherImpl.LogOpenPreparedCommand(:0) [(null)] - Opened new IDbCommand, open IDbCommands :1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.Generate(:0) NHibernate.Impl.BatcherImpl.Generate(:0) [(null)] - Building an IDbCommand object for the SqlString: SELECT this.rolemenuId as rolemenuId0_, this.roleId as roleId0_, this.menuId as menuId0_ FROM RoleMenu this WHERE this.roleId in (:this.roleId_0) e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.GetResultSet(:0) NHibernate.Loader.Loader.GetResultSet(:0) [(null)] - SELECT this.rolemenuId as rolemenuId0_, this.roleId as roleId0_, this.menuId as menuId0_ FROM RoleMenu this WHERE this.roleId in (@p0) e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.Log(:0) NHibernate.Impl.BatcherImpl.Log(:0) [(null)] - SELECT this.rolemenuId as rolemenuId0_, this.roleId as roleId0_, this.menuId as menuId0_ FROM RoleMenu this WHERE this.roleId in (@p0) e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.Log(:0) NHibernate.Impl.BatcherImpl.Log(:0) [(null)] - @p0 = '1' e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Connection.DriverConnectionProvider.GetConnection(:0) NHibernate.Connection.DriverConnectionProvider.GetConnection(:0) [(null)] - Obtaining IDbConnection from Driver e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.LogOpenReader(:0) NHibernate.Impl.BatcherImpl.LogOpenReader(:0) [(null)] - Opened Reader, open Readers :1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.DoQuery(:0) NHibernate.Loader.Loader.DoQuery(:0) [(null)] - processing result set e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.GetRow(:0) NHibernate.Loader.Loader.GetRow(:0) [(null)] - result row: 1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.LoadFromResultSet(:0) NHibernate.Loader.Loader.LoadFromResultSet(:0) [(null)] - Initializing object from DataReader: 1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.Hydrate(:0) NHibernate.Loader.Loader.Hydrate(:0) [(null)] - Hydrating entity: bms.db.RoleMenuModel#1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.GetRow(:0) NHibernate.Loader.Loader.GetRow(:0) [(null)] - result row: 2 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.LoadFromResultSet(:0) NHibernate.Loader.Loader.LoadFromResultSet(:0) [(null)] - Initializing object from DataReader: 2 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.Hydrate(:0) NHibernate.Loader.Loader.Hydrate(:0) [(null)] - Hydrating entity: bms.db.RoleMenuModel#2 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.DoQuery(:0) NHibernate.Loader.Loader.DoQuery(:0) [(null)] - done processing result set (2 rows) e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Driver.NHybridDataReader.Dispose(:0) NHibernate.Driver.NHybridDataReader.Dispose(:0) [(null)] - running NHybridDataReader.Dispose() e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.LogCloseReader(:0) NHibernate.Impl.BatcherImpl.LogCloseReader(:0) [(null)] - Closed Reader, open Readers :0 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.LogClosePreparedCommand(:0) NHibernate.Impl.BatcherImpl.LogClosePreparedCommand(:0) [(null)] - Closed IDbCommand, open IDbCommands :0 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.InitializeEntitiesAndCollections(:0) NHibernate.Loader.Loader.InitializeEntitiesAndCollections(:0) [(null)] - total objects hydrated: 2 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.InitializeEntity(:0) NHibernate.Impl.SessionImpl.InitializeEntity(:0) [(null)] - resolving associations for: [bms.db.RoleMenuModel#1] e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.InitializeEntity(:0) NHibernate.Impl.SessionImpl.InitializeEntity(:0) [(null)] - done materializing entity [bms.db.RoleMenuModel#1] e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.InitializeEntity(:0) NHibernate.Impl.SessionImpl.InitializeEntity(:0) [(null)] - resolving associations for: [bms.db.RoleMenuModel#2] e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.InitializeEntity(:0) NHibernate.Impl.SessionImpl.InitializeEntity(:0) [(null)] - done materializing entity [bms.db.RoleMenuModel#2] e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.InitializeNonLazyCollections(:0) NHibernate.Impl.SessionImpl.InitializeNonLazyCollections(:0) [(null)] - initializing non-lazy collections e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.Close(:0) NHibernate.Impl.SessionImpl.Close(:0) [(null)] - closing session e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.Disconnect(:0) NHibernate.Impl.SessionImpl.Disconnect(:0) [(null)] - disconnecting session e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Connection.ConnectionProvider.CloseConnection(:0) NHibernate.Connection.ConnectionProvider.CloseConnection(:0) [(null)] - Closing connection e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.AfterTransactionCompletion(:0) NHibernate.Impl.SessionImpl.AfterTransactionCompletion(:0) [(null)] - transaction completion e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl..ctor(:0) NHibernate.Impl.SessionImpl..ctor(:0) [(null)] - opened session e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.SqlCommand.SqlSelectBuilder.ToSqlString(:0) NHibernate.SqlCommand.SqlSelectBuilder.ToSqlString(:0) [(null)] - The initial capacity was set too low at: 8 for the SelectSqlBuilder that needed a capacity of: 16 for the table menu this e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushEverything(:0) NHibernate.Impl.SessionImpl.FlushEverything(:0) [(null)] - flushing session e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushEntities(:0) NHibernate.Impl.SessionImpl.FlushEntities(:0) [(null)] - Flushing entities and processing referenced collections e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushCollections(:0) NHibernate.Impl.SessionImpl.FlushCollections(:0) [(null)] - Processing unreferenced collections e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushCollections(:0) NHibernate.Impl.SessionImpl.FlushCollections(:0) [(null)] - scheduling collection removes/(re)creates/updates e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushEverything(:0) NHibernate.Impl.SessionImpl.FlushEverything(:0) [(null)] - Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.FlushEverything(:0) NHibernate.Impl.SessionImpl.FlushEverything(:0) [(null)] - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.AutoFlushIfRequired(:0) NHibernate.Impl.SessionImpl.AutoFlushIfRequired(:0) [(null)] - dont need to execute flush e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.LogOpenPreparedCommand(:0) NHibernate.Impl.BatcherImpl.LogOpenPreparedCommand(:0) [(null)] - Opened new IDbCommand, open IDbCommands :1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.Generate(:0) NHibernate.Impl.BatcherImpl.Generate(:0) [(null)] - Building an IDbCommand object for the SqlString: SELECT this.menuID as menuID0_, this.url as url0_, this.parent as parent0_, this.menuText as menuText0_, this.menuName as menuName0_, this.pos as pos0_, this.menuLevel as menuLevel0_, this.leaf as leaf0_, this.menuCd as menuCd0_ FROM menu this WHERE this.menuID in (:this.menuID_0, :this.menuID_1) and this.parent is null ORDER BY this.pos asc e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.GetResultSet(:0) NHibernate.Loader.Loader.GetResultSet(:0) [(null)] - SELECT this.menuID as menuID0_, this.url as url0_, this.parent as parent0_, this.menuText as menuText0_, this.menuName as menuName0_, this.pos as pos0_, this.menuLevel as menuLevel0_, this.leaf as leaf0_, this.menuCd as menuCd0_ FROM menu this WHERE this.menuID in (@p0, @p1) and this.parent is null ORDER BY this.pos asc e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.Log(:0) NHibernate.Impl.BatcherImpl.Log(:0) [(null)] - SELECT this.menuID as menuID0_, this.url as url0_, this.parent as parent0_, this.menuText as menuText0_, this.menuName as menuName0_, this.pos as pos0_, this.menuLevel as menuLevel0_, this.leaf as leaf0_, this.menuCd as menuCd0_ FROM menu this WHERE this.menuID in (@p0, @p1) and this.parent is null ORDER BY this.pos asc e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.Log(:0) NHibernate.Impl.BatcherImpl.Log(:0) [(null)] - @p0 = '1' e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.Log(:0) NHibernate.Impl.BatcherImpl.Log(:0) [(null)] - @p1 = '2' e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Connection.DriverConnectionProvider.GetConnection(:0) NHibernate.Connection.DriverConnectionProvider.GetConnection(:0) [(null)] - Obtaining IDbConnection from Driver e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.LogOpenReader(:0) NHibernate.Impl.BatcherImpl.LogOpenReader(:0) [(null)] - Opened Reader, open Readers :1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.DoQuery(:0) NHibernate.Loader.Loader.DoQuery(:0) [(null)] - processing result set e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.GetRow(:0) NHibernate.Loader.Loader.GetRow(:0) [(null)] - result row: 2 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.LoadFromResultSet(:0) NHibernate.Loader.Loader.LoadFromResultSet(:0) [(null)] - Initializing object from DataReader: 2 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.Hydrate(:0) NHibernate.Loader.Loader.Hydrate(:0) [(null)] - Hydrating entity: bms.db.MenuModel#2 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.DoQuery(:0) NHibernate.Loader.Loader.DoQuery(:0) [(null)] - done processing result set (1 rows) e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Driver.NHybridDataReader.Dispose(:0) NHibernate.Driver.NHybridDataReader.Dispose(:0) [(null)] - running NHybridDataReader.Dispose() e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.LogCloseReader(:0) NHibernate.Impl.BatcherImpl.LogCloseReader(:0) [(null)] - Closed Reader, open Readers :0 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.BatcherImpl.LogClosePreparedCommand(:0) NHibernate.Impl.BatcherImpl.LogClosePreparedCommand(:0) [(null)] - Closed IDbCommand, open IDbCommands :0 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Loader.Loader.InitializeEntitiesAndCollections(:0) NHibernate.Loader.Loader.InitializeEntitiesAndCollections(:0) [(null)] - total objects hydrated: 1 e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.InitializeEntity(:0) NHibernate.Impl.SessionImpl.InitializeEntity(:0) [(null)] - resolving associations for: [bms.db.MenuModel#2] e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.Close(:0) NHibernate.Impl.SessionImpl.Close(:0) [(null)] - closing session e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.Disconnect(:0) NHibernate.Impl.SessionImpl.Disconnect(:0) [(null)] - disconnecting session e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Connection.ConnectionProvider.CloseConnection(:0) NHibernate.Connection.ConnectionProvider.CloseConnection(:0) [(null)] - Closing connection e
2006/05/16 +08:00 01:14:20 [3840] NHibernate.Impl.SessionImpl.AfterTransactionCompletion(:0) NHibernate.Impl.SessionImpl.AfterTransactionCompletion(:0) [(null)] - transaction completion e
2006/05/16 +08:00 01:14:20 [3840] bms.Sys.Utils.LogUtil.Log(:0) bms.Sys.Utils.LogUtil.Log(:0) [(null)] - ,, e
bms.Sys.Utils.MyException: NHibernate.MappingException: Invalid mapping information specified for type bms.db.MenuModel, check your mapping file for property type mismatches ---> System.InvalidCastException: 指定的转换无效。
at NHibernate.Persister.GetSetHelper_bms_db_MenuModel.SetPropertyValues(Object obj, Object[] values)
--- 内部异常堆栈跟踪的结尾 ---
at bms.Sys.Business.UserBusiness.SearchUserLogin(String loginUserId, String password)
at bms.Sys.login.btnLogin_Click(Object sender, EventArgs e)



Error Message
NHibernate.MappingException: Invalid mapping information specified for type bms.db.MenuModel, check your mapping file for property type mismatches ---> System.InvalidCastException: 指定的转换无效。(The specified cast is invalid) at NHibernate.Persister.GetSetHelper_bms_db_MenuModel.SetPropertyValues(Object obj, Object[] values) --- 内部异常堆栈跟踪的结尾 --- at bms.Sys.Business.UserBusiness.SearchUserLogin(String loginUserId, String password) in e:\work\bms\sys\business\userbusiness.cs:line 93 at bms.Sys.login.btnLogin_Click(Object sender, EventArgs e) in e:\work\bms\sys\login.aspx.cs:line 96

class file

using System;
namespace bms.db
{
public class MenuModel{
private System.Int64 __MenuId;
private string __Menucd;
private string __Menuname;
private string __Menutext;
private int __Menulevel;
private string __Parent;
private int __pos;
private string __Url;
private int __Leaf;


public System.Int64 MenuId
{
get
{
return __MenuId;
}

set
{
__MenuId=value;
}
}
public string Menucd
{
get
{
return __Menucd;
}

set
{
__Menucd=value;
}
}
public string Menuname
{
get
{
return __Menuname;
}

set
{
__Menuname=value;
}
}
public string Menutext
{
get
{
return __Menutext;
}

set
{
__Menutext=value;
}
}
public int Menulevel
{
get
{
return __Menulevel;
}

set
{
__Menulevel=value;
}
}
public string Parent
{
get
{
return __Parent;
}

set
{
__Parent=value;
}
}
public int pos
{
get
{
return __pos;
}
set
{
__pos=value;
}
}
public string Url
{
get
{
return __Url;
}

set
{
__Url=value;
}
}
public int Leaf
{
get
{
return __Leaf;
}

set
{
__Leaf=value;
}
}
}
}


error occurs after the setter of MenuName


Top
 Profile  
 
 Post subject:
PostPosted: Tue May 16, 2006 11:30 pm 
Newbie

Joined: Sun May 14, 2006 11:10 pm
Posts: 2
problem resolved.
value of the field url is set to null in the db. if i set a value for the filed in the db,it'll be ok.
or set not-null="false" in the hbm.xml file will also solve the problem.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 2 posts ] 

All times are UTC - 5 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.