Menu
▾
▴
[nhibernate-issues] [JIRA] Updated: (NH-686) Formula field in joined subclass possibly works incorrectly
|
From: NHibernate J. <mik...@us...> - 2006-10-26 20:33:18
|
[ http://jira.nhibernate.org/browse/NH-686?page=3Dall ] Sergey Koshcheyev updated NH-686: --------------------------------- type: Bug (was: Task) > Formula field in joined subclass possibly works incorrectly > ----------------------------------------------------------- > > Key: NH-686 > URL: http://jira.nhibernate.org/browse/NH-686 > Project: NHibernate > Type: Bug > Components: Core > Versions: 1.0.2 > Reporter: Ivanov Mikhail > > I have created the following mapping: > <?xml version=3D"1.0" encoding=3D"utf-8" ?>=20 > <hibernate-mapping xmlns=3D"urn:nhibernate-mapping-2.0"> > <class name=3D"CoreIMSEE.Domain.Partner, CoreIMSEE.Domain" table=3D"P= ARTNER"> > =09=09<id name=3D"Id" column=3D"ID" unsaved-value=3D"0" access=3D"field.c= amelcase"> > =09=09=09<generator class=3D"native" /> > =09=09</id> > =09=09 > =09=09<timestamp name=3D"timestamp" column=3D"TS" access=3D"field"/> > <property name=3D"Code" column=3D"CODE" type=3D"String" length=3D"50"= not-null=3D"true" /> > =09=09<property name=3D"Name" column=3D"NAME" type=3D"String" length=3D"1= 00" not-null=3D"true" /> > =09=09<property name=3D"IsVendor" column=3D"IS_VENDOR" type=3D"YesNo" not= -null=3D"true" /> > =09=09<property name=3D"IsCustomer" column=3D"IS_CUSTOMER" type=3D"YesNo"= not-null=3D"true" /> > =09=09<property name=3D"IsClient" column=3D"IS_CLIENT" type=3D"YesNo" not= -null=3D"true" /> > =09=09<property name=3D"IsActive" column=3D"IS_ACTIVE" type=3D"YesNo" not= -null=3D"true" /> > <property name=3D"IsAutoFax" column=3D"AUTOFAX" type=3D"YesNo" not-= null=3D"true" /> > =09=09<many-to-one name=3D"Address" column=3D"ADDRESS_ID" not-null=3D"tru= e" cascade=3D"all" /> > <many-to-one name=3D"CreatedBy" column=3D"CREATED_BY" not-null=3D"fal= se" cascade=3D"none" /> > <many-to-one name=3D"VerifiedBy" column=3D"VERIFIED_BY" not-null=3D"f= alse" cascade=3D"none" /> > <joined-subclass name=3D"CoreIMSEE.Domain.Customer, CoreIMSEE.Domai= n" table=3D"CUSTOMER"> > =09=09=09<key column=3D"ID" /> > =09=09 > =09=09=09<!--timestamp name=3D"timestamp" column=3D"TS" access=3D"field"/= --> > =09=09=09 > =09=09=09<property name=3D"IsDefault" column=3D"IS_DEFAULT" type=3D"YesNo= " not-null=3D"true" /> > =09=09=09<property name=3D"IsVerified" column=3D"IS_VERIFIED" type=3D"Yes= No" not-null=3D"true" /> > =09=09=09<property name=3D"Name2" column=3D"NAME2" /> > =09=09=09<property name=3D"Name3" column=3D"NAME3" /> > <property name=3D"customerName" formula=3D"(select p.Name from Part= ner p where p.Id =3D Id) + ' ' + Name2 + ' ' + Name3" insert=3D"false" upda= te=3D"false" type=3D"String" access=3D"field" /> > <property name=3D"TaxId" column=3D"TAX_ID" type=3D"String" length= =3D"1" not-null=3D"true" /> > =09=09=09<property name=3D"IsTaxExempt" column=3D"TAX_EXEMPT" type=3D"Yes= No" not-null=3D"true" /> > =09=09=09<property name=3D"TxStatementType" column=3D"TX_STATEMENT_TYPE" = type=3D"String" length=3D"50" not-null=3D"true" /> > =09=09=09<property name=3D"TxStatementFrequency" column=3D"TX_STATEMENT_F= REQ" type=3D"String" length=3D"50" not-null=3D"true" /> > =09=09=09<property name=3D"StorageStatementType" column=3D"STORAGE_STATEM= ENT_TYPE" type=3D"String" length=3D"50" not-null=3D"true" /> > =09=09=09<property name=3D"StorageStatementFrequency" column=3D"STORAGE_S= TATEMENT_FREQ" type=3D"String" length=3D"50" not-null=3D"true" /> > =09=09=09<many-to-one name=3D"BillingAddress" column=3D"BILLING_ADDRESS_I= D" cascade=3D"all"/> > =09=09=09<many-to-one name=3D"ParentCustomer" column=3D"PARENT_ID" /> > <set name=3D"CustomerCrossReference" cascade =3D"all"> > <key column=3D"CUSTOMER_ID"/> > <one-to-many class=3D"CoreIMSEE.Domain.CustomerCrossReference, Co= reIMSEE.Domain"/> > </set> > =09=09=09 > =09=09</joined-subclass> > <!--joined-subclass name=3D"CoreIMSEE.Domain.Vendor, CoreIMSEE.Doma= in" table=3D"VENDOR"> > <key column=3D"ID" /> > =20 > </joined-subclass--> > =09=09=09=09 > =09</class> > </hibernate-mapping> > I want to use property Name from Partner in formula field in Customer. Bu= t this works incorrectly (Excaption occurs) because in generated SQL field = Name translates into <customer_alias>.Name instead of <partner_alias.Name>.= I solved this using (select p.Namr from Partner where p.Id =3D Id) > <property name=3D"customerName" formula=3D"(select p.Name from Part= ner p where p.Id =3D Id) + ' ' + Name2 + ' ' + Name3" insert=3D"false" upda= te=3D"false" type=3D"String" access=3D"field" /> > , but this is nor very effective solution because we can just use Partner= table which is Joined in generated SQL. > SQL: > SELECT customer0_.ID as ID6_, customer0_.IS_VERIFIED as IS_VER3_4_6_, cus= tomer0_.BILLING_ADDRESS_ID as BILLI12_4_6_, customer0_.NAME2 as NAME24_6_, = customer0_.NAME3 as NAME34_6_, customer0_.TX_STATEMENT_FREQ as TX_STA9_4_6_= , customer0_.STORAGE_STATEMENT_TYPE as STORA10_4_6_, customer0_.PARENT_ID a= s PAREN13_4_6_, customer0_.IS_DEFAULT as IS_DEF2_4_6_, customer0_.TAX_EXEMP= T as TAX_EX7_4_6_, customer0_.TX_STATEMENT_TYPE as TX_STA8_4_6_, customer0_= .STORAGE_STATEMENT_FREQ as STORA11_4_6_, customer0_.TAX_ID as TAX_ID4_6_, [= customer0__1_].IS_ACTIVE as IS_ACT8_3_6_, [customer0__1_].NAME as NAME3_6_,= [customer0__1_].ADDRESS_ID as ADDRE10_3_6_, [customer0__1_].IS_CUSTOMER as= IS_CUS6_3_6_, [customer0__1_].VERIFIED_BY as VERIF12_3_6_, [customer0__1_]= .CREATED_BY as CREAT11_3_6_, [customer0__1_].TS as TS3_6_, [customer0__1_].= IS_VENDOR as IS_VEN5_3_6_, [customer0__1_].IS_CLIENT as IS_CLI7_3_6_, [cust= omer0__1_].CODE as CODE3_6_, [customer0__1_].AUTOFAX as AUTOFAX3_6_, custom= er0_.Name + ' ' + customer0_.Name2 + ' ' + customer0_.Name3 as f1_6_, addre= ss1_.ID as ID0_, address1_.STATE_CODE as STATE_CODE0_, address1_.FAX1 as FA= X10_, address1_.STREET2 as STREET20_, address1_.TS as TS0_, address1_.COUNT= RY_CODE as COUNTRY18_0_, address1_.FAX2 as FAX20_, address1_.EMAIL1 as EMAI= L10_, address1_.CITY as CITY0_, address1_.PHONE2 as PHONE20_, address1_.SWI= FT_BIC_CODE as SWIFT_BI8_0_, address1_.ZIP as ZIP0_, address1_.CONTACT1 as = CONTACT10_, address1_.PHONE1 as PHONE10_, address1_.STREET3 as STREET30_, a= ddress1_.STREET1 as STREET10_, address1_.EMAIL2 as EMAIL20_, address1_.CONT= ACT2 as CONTACT20_, address1_.PHONE3 as PHONE30_, state2_.CODE as CODE1_, s= tate2_.DESCRIPTION as DESCRIPT2_1_, state2_.COUNTRY_CODE as COUNTRY_3_1_, c= ountry3_.CODE as CODE2_, country3_.DESCRIPTION as DESCRIPT2_2_, country4_.C= ODE as CODE3_, country4_.DESCRIPTION as DESCRIPT2_3_, user5_.ID as ID4_, us= er5_.EMAIL as EMAIL4_, user5_.PASSWORD_EXPIRES as PASSWORD5_4_, user5_.PHON= E as PHONE4_, user5_.FIRST_NAME as FIRST_NAME4_, user5_.TS as TS4_, user5_.= ROWS_PER_PAGE as ROWS_PE10_4_, user5_.PASSWORD as PASSWORD4_, user5_.PREF_C= ULTURE_NAME as PREF_CU11_4_, user5_.USERNAME as USERNAME4_, user5_.LAST_NAM= E as LAST_NAME4_, user6_.ID as ID5_, user6_.EMAIL as EMAIL5_, user6_.PASSWO= RD_EXPIRES as PASSWORD5_5_, user6_.PHONE as PHONE5_, user6_.FIRST_NAME as F= IRST_NAME5_, user6_.TS as TS5_, user6_.ROWS_PER_PAGE as ROWS_PE10_5_, user6= _.PASSWORD as PASSWORD5_, user6_.PREF_CULTURE_NAME as PREF_CU11_5_, user6_.= USERNAME as USERNAME5_, user6_.LAST_NAME as LAST_NAME5_ FROM CUSTOMER custo= mer0_ inner join PARTNER [customer0__1_] on customer0_.ID=3D[customer0__1_]= .ID left outer join ADDRESS address1_ on customer0_.BILLING_ADDRESS_ID=3Dad= dress1_.ID left outer join STATE state2_ on address1_.STATE_CODE=3Dstate2_.= CODE left outer join COUNTRY country3_ on state2_.COUNTRY_CODE=3Dcountry3_.= CODE left outer join COUNTRY country4_ on address1_.COUNTRY_CODE=3Dcountry4= _.CODE left outer join SYS_USER user5_ on [customer0__1_].VERIFIED_BY=3Duse= r5_.ID left outer join SYS_USER user6_ on [customer0__1_].CREATED_BY=3Duser= 6_.ID WHERE customer0_.ID=3D:ID > Exception details: > System.Data.SqlClient.SqlException: Invalid column name 'Name'. > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,= Boolean breakConnection) > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException ex= ception, Boolean breakConnection) > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserS= tateObject stateObj) > at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCom= mand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopy= Handler, TdsParserStateObject stateObj) > at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() > at System.Data.SqlClient.SqlDataReader.get_MetaData() > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader = ds, RunBehavior runBehavior, String resetOptionsString) > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavio= r cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async= ) > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior c= mdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, D= bAsyncResult result) > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior c= mdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) > at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior beha= vior, String method) > at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavio= r behavior) > at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() > at NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) > at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection s= election, ISessionImplementor session) > 2006-08-05 09:27:00,310 [4940] WARN NHibernate.Util.ADOExceptionReporter= [(null)] - System.Data.SqlClient.SqlException: Invalid column name 'Name'. > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,= Boolean breakConnection) > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException ex= ception, Boolean breakConnection) > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserS= tateObject stateObj) > at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCom= mand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopy= Handler, TdsParserStateObject stateObj) > at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() > at System.Data.SqlClient.SqlDataReader.get_MetaData() > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader = ds, RunBehavior runBehavior, String resetOptionsString) > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavio= r cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async= ) > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior c= mdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, D= bAsyncResult result) > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior c= mdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) > at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior beha= vior, String method) > at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavio= r behavior) > at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() > at NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) > at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection s= election, ISessionImplementor session) > 2006-08-05 09:27:00,310 [4940] ERROR NHibernate.Util.ADOExceptionReporter= [(null)] - Invalid column name 'Name'. > 2006-08-05 09:27:00,310 [4940] DEBUG NHibernate.Impl.BatcherImpl [(null)]= - Closed IDbCommand, open IDbCommands :0 > 2006-08-05 09:27:00,310 [4940] DEBUG NHibernate.Util.ADOExceptionReporter= [(null)] - could not load by id: [CoreIMSEE.Domain.Customer#1] > System.Data.SqlClient.SqlException: Invalid column name 'Name'. > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,= Boolean breakConnection) > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException ex= ception, Boolean breakConnection) > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserS= tateObject stateObj) > at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCom= mand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopy= Handler, TdsParserStateObject stateObj) > at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() > at System.Data.SqlClient.SqlDataReader.get_MetaData() > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader = ds, RunBehavior runBehavior, String resetOptionsString) > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavio= r cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async= ) > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior c= mdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, D= bAsyncResult result) > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior c= mdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) > at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior beha= vior, String method) > at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavio= r behavior) > at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() > at NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) > at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection s= election, ISessionImplementor session) > at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, Query= Parameters queryParameters, Object optionalObject, Object optionalId, Objec= t[] optionalCollectionKeys, Boolean returnProxies) > at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISe= ssionImplementor session, QueryParameters queryParameters, Object optionalO= bject, Object optionalId, Object[] optionalCollectionKeys, Boolean returnPr= oxies) > at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Ob= ject[] values, IType[] types, Object optionalObject, Object optionalID) > at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Ob= ject id, IType identifierType, Object optionalObject, Object optionalIdenti= fier) > at NHibernate.Loader.EntityLoader.Load(ISessionImplementor session, Ob= ject id, Object optionalObject, Object optionalId) > at NHibernate.Loader.EntityLoader.Load(ISessionImplementor session, Ob= ject id, Object optionalObject) > at NHibernate.Persister.NormalizedEntityPersister.Load(Object id, Obje= ct optionalObject, LockMode lockMode, ISessionImplementor session) > 2006-08-05 09:27:00,326 [4940] WARN NHibernate.Util.ADOExceptionReporter= [(null)] - System.Data.SqlClient.SqlException: Invalid column name 'Name'. > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,= Boolean breakConnection) > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException ex= ception, Boolean breakConnection) > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserS= tateObject stateObj) > at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCom= mand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopy= Handler, TdsParserStateObject stateObj) > at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() > at System.Data.SqlClient.SqlDataReader.get_MetaData() > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader = ds, RunBehavior runBehavior, String resetOptionsString) > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavio= r cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async= ) > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior c= mdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, D= bAsyncResult result) > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior c= mdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) > at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior beha= vior, String method) > at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavio= r behavior) > at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() > at NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) > at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection s= election, ISessionImplementor session) > at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, Query= Parameters queryParameters, Object optionalObject, Object optionalId, Objec= t[] optionalCollectionKeys, Boolean returnProxies) > at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISe= ssionImplementor session, QueryParameters queryParameters, Object optionalO= bject, Object optionalId, Object[] optionalCollectionKeys, Boolean returnPr= oxies) > at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Ob= ject[] values, IType[] types, Object optionalObject, Object optionalID) > at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Ob= ject id, IType identifierType, Object optionalObject, Object optionalIdenti= fier) > at NHibernate.Loader.EntityLoader.Load(ISessionImplementor session, Ob= ject id, Object optionalObject, Object optionalId) > at NHibernate.Loader.EntityLoader.Load(ISessionImplementor session, Ob= ject id, Object optionalObject) > at NHibernate.Persister.NormalizedEntityPersister.Load(Object id, Obje= ct optionalObject, LockMode lockMode, ISessionImplementor session) > 2006-08-05 09:27:00,326 [4940] ERROR NHibernate.Util.ADOExceptionReporter= [(null)] - Invalid column name 'Name'. > 2006-08-05 09:27:00,326 [4940] ERROR CoreIMSEE.Core.Persistence.HqlExecut= or [(null)] - Could not execute query > NHibernate.ADOException: Could not execute query ---> NHibernate.ADOExcep= tion: could not load by id: [CoreIMSEE.Domain.Customer#1] ---> System.Data.= SqlClient.SqlException: Invalid column name 'Name'. > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,= Boolean breakConnection) > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException ex= ception, Boolean breakConnection) > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserS= tateObject stateObj) > at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCom= mand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopy= Handler, TdsParserStateObject stateObj) > at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() > at System.Data.SqlClient.SqlDataReader.get_MetaData() > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader = ds, RunBehavior runBehavior, String resetOptionsString) > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavio= r cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async= ) > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior c= mdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, D= bAsyncResult result) > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior c= mdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) > at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior beha= vior, String method) > at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavio= r behavior) > at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() > at NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) > at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection s= election, ISessionImplementor session) > at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, Query= Parameters queryParameters, Object optionalObject, Object optionalId, Objec= t[] optionalCollectionKeys, Boolean returnProxies) > at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISe= ssionImplementor session, QueryParameters queryParameters, Object optionalO= bject, Object optionalId, Object[] optionalCollectionKeys, Boolean returnPr= oxies) > at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Ob= ject[] values, IType[] types, Object optionalObject, Object optionalID) > at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Ob= ject id, IType identifierType, Object optionalObject, Object optionalIdenti= fier) > at NHibernate.Loader.EntityLoader.Load(ISessionImplementor session, Ob= ject id, Object optionalObject, Object optionalId) > at NHibernate.Loader.EntityLoader.Load(ISessionImplementor session, Ob= ject id, Object optionalObject) > at NHibernate.Persister.NormalizedEntityPersister.Load(Object id, Obje= ct optionalObject, LockMode lockMode, ISessionImplementor session) > --- End of inner exception stack trace --- > at NHibernate.Persister.NormalizedEntityPersister.Load(Object id, Obje= ct optionalObject, LockMode lockMode, ISessionImplementor session) > at NHibernate.Impl.SessionImpl.DoLoad(Type theClass, Object id, Object= optionalObject, LockMode lockMode, Boolean checkDeleted) > at NHibernate.Impl.SessionImpl.DoLoadByClass(Type clazz, Object id, Bo= olean checkDeleted, Boolean allowProxyCreation) > at NHibernate.Impl.SessionImpl.InternalLoad(Type clazz, Object id) > at NHibernate.Type.ManyToOneType.ResolveIdentifier(Object id, ISession= Implementor session) > at NHibernate.Type.EntityType.ResolveIdentifier(Object id, ISessionImp= lementor session, Object owner) > at NHibernate.Impl.SessionImpl.InitializeEntity(Object obj) > at NHibernate.Loader.Loader.InitializeEntitiesAndCollections(IList hyd= ratedObjects, Object resultSetId, ISessionImplementor session) > at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, Query= Parameters queryParameters, Object optionalObject, Object optionalId, Objec= t[] optionalCollectionKeys, Boolean returnProxies) > at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISe= ssionImplementor session, QueryParameters queryParameters, Object optionalO= bject, Object optionalId, Object[] optionalCollectionKeys, Boolean returnPr= oxies) > at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryP= arameters queryParameters) > at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryPar= ameters queryParameters, ISet querySpaces, IType[] resultTypes) > at NHibernate.Hql.QueryTranslator.List(ISessionImplementor session, Qu= eryParameters queryParameters) > at NHibernate.Impl.SessionImpl.Find(String query, QueryParameters para= meters) > --- End of inner exception stack trace --- > at NHibernate.Impl.SessionImpl.Find(String query, QueryParameters para= meters) > at NHibernate.Impl.QueryImpl.List() > at CoreIMSEE.Core.Persistence.HqlExecutor.Execute(IHqlQueryFilterState= filterState) in C:\Inetpub\wwwroot\CoreIMSEE.HSBC\CoreIMSEE.Core\Core\Pers= istence\HqlExecutor.cs:line 135 > at CoreIMSEE.Core.Persistence.HqlExecutor.Execute(IFilterState filterS= tate) in C:\Inetpub\wwwroot\CoreIMSEE.HSBC\CoreIMSEE.Core\Core\Persistence\= HqlExecutor.cs:line 73 > 2006-08-05 09:27:00,326 [4940] WARN CoreIMSEE.Core.Persistence.PstInterc= eptor [(null)] - exception is thrown, rolling back a transaction and closin= g current session > NHibernate.ADOException: Could not execute query ---> NHibernate.ADOExcep= tion: could not load by id: [CoreIMSEE.Domain.Customer#1] ---> System.Data.= SqlClient.SqlException: Invalid column name 'Name'. > at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,= Boolean breakConnection) > at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException ex= ception, Boolean breakConnection) > at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserS= tateObject stateObj) > at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCom= mand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopy= Handler, TdsParserStateObject stateObj) > at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() > at System.Data.SqlClient.SqlDataReader.get_MetaData() > at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader = ds, RunBehavior runBehavior, String resetOptionsString) > at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavio= r cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async= ) > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior c= mdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, D= bAsyncResult result) > at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior c= mdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) > at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior beha= vior, String method) > at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavio= r behavior) > at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() > at NHibernate.Impl.BatcherImpl.ExecuteReader(IDbCommand cmd) > at NHibernate.Loader.Loader.GetResultSet(IDbCommand st, RowSelection s= election, ISessionImplementor session) > at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, Query= Parameters queryParameters, Object optionalObject, Object optionalId, Objec= t[] optionalCollectionKeys, Boolean returnProxies) > at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISe= ssionImplementor session, QueryParameters queryParameters, Object optionalO= bject, Object optionalId, Object[] optionalCollectionKeys, Boolean returnPr= oxies) > at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Ob= ject[] values, IType[] types, Object optionalObject, Object optionalID) > at NHibernate.Loader.Loader.LoadEntity(ISessionImplementor session, Ob= ject id, IType identifierType, Object optionalObject, Object optionalIdenti= fier) > at NHibernate.Loader.EntityLoader.Load(ISessionImplementor session, Ob= ject id, Object optionalObject, Object optionalId) > at NHibernate.Loader.EntityLoader.Load(ISessionImplementor session, Ob= ject id, Object optionalObject) > at NHibernate.Persister.NormalizedEntityPersister.Load(Object id, Obje= ct optionalObject, LockMode lockMode, ISessionImplementor session) > --- End of inner exception stack trace --- > at NHibernate.Persister.NormalizedEntityPersister.Load(Object id, Obje= ct optionalObject, LockMode lockMode, ISessionImplementor session) > at NHibernate.Impl.SessionImpl.DoLoad(Type theClass, Object id, Object= optionalObject, LockMode lockMode, Boolean checkDeleted) > at NHibernate.Impl.SessionImpl.DoLoadByClass(Type clazz, Object id, Bo= olean checkDeleted, Boolean allowProxyCreation) > at NHibernate.Impl.SessionImpl.InternalLoad(Type clazz, Object id) > at NHibernate.Type.ManyToOneType.ResolveIdentifier(Object id, ISession= Implementor session) > at NHibernate.Type.EntityType.ResolveIdentifier(Object id, ISessionImp= lementor session, Object owner) > at NHibernate.Impl.SessionImpl.InitializeEntity(Object obj) > at NHibernate.Loader.Loader.InitializeEntitiesAndCollections(IList hyd= ratedObjects, Object resultSetId, ISessionImplementor session) > at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, Query= Parameters queryParameters, Object optionalObject, Object optionalId, Objec= t[] optionalCollectionKeys, Boolean returnProxies) > at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISe= ssionImplementor session, QueryParameters queryParameters, Object optionalO= bject, Object optionalId, Object[] optionalCollectionKeys, Boolean returnPr= oxies) > at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryP= arameters queryParameters) > at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryPar= ameters queryParameters, ISet querySpaces, IType[] resultTypes) > at NHibernate.Hql.QueryTranslator.List(ISessionImplementor session, Qu= eryParameters queryParameters) > at NHibernate.Impl.SessionImpl.Find(String query, QueryParameters para= meters) > --- End of inner exception stack trace --- > at Spring.Aop.Framework.AbstractMethodInvocation.InvokeJoinpoint() in = C:\dotnet\2005 patched frameworks\Spring.NET 1.1 Preview 2\src\Spring\Sprin= g.Aop\Aop\Framework\AbstractMethodInvocation.cs:line 275 > at Spring.Aop.Framework.AbstractMethodInvocation.Proceed() in C:\dotne= t\2005 patched frameworks\Spring.NET 1.1 Preview 2\src\Spring\Spring.Aop\Ao= p\Framework\AbstractMethodInvocation.cs:line 224 > at CoreIMSEE.Core.Persistence.PstInterceptor.Invoke(IMethodInvocation = invocation) in C:\Inetpub\wwwroot\CoreIMSEE.HSBC\CoreIMSEE.Core\Core\Persis= tence\PstInterceptor.cs:line 80 --=20 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 |
