The suggestion entirely violates the XLM structure. Attribute values must be quoted.
Also the query executed by nHibernate is successfully executed on SQL server. nHibernate successfully receives back the recordset results. The problem is that nHibernate doesn't like that the provided unique key is a calculated value (not a stored attribute of a table) that nHibernate can't manipulate ~~ even though I will never ask nHibernate to persist any of the recordset. On Monday, March 21, 2016 at 8:20:46 PM UTC-4, Steve Lyle wrote: > > My application calls and successfully receives a result set from my > database. > When I look in the log4net file I can even see the values of each field of > each row returned because the values are logged as DEBUG messages in the > log file. > > *But at the end of receiving the rows hbm fails complaining - from the log > at the failure:* > 2016-03-21 14:36:49,820 [11] DEBUG NHibernate.Type.StringType - returning > 'VRM' as column: col_6_0_ > 2016-03-21 14:36:49,820 [11] DEBUG NHibernate.Type.StringType - returning > 'Flash freeze' as column: col_7_0_ > 2016-03-21 14:36:49,820 [11] DEBUG NHibernate.Type.Int32Type - returning > '14' as column: col_8_0_ > 2016-03-21 14:36:49,820 [11] DEBUG NHibernate.Type.StringType - returning > 'steve2' as column: col_9_0_ > 2016-03-21 14:36:49,820 [11] DEBUG NHibernate.Type.StringType - returning > 'steve2' as column: col_10_0_ > 2016-03-21 14:36:49,820 [11] DEBUG NHibernate.Type.StringType - returning > 'steve2' as column: col_11_0_ > 2016-03-21 14:36:49,820 [11] DEBUG NHibernate.Type.StringType - returning > 'steve2' as column: col_12_0_ > 2016-03-21 14:36:49,820 [11] DEBUG NHibernate.Type.DateTimeType - > returning null as column: col_13_0_ > 2016-03-21 14:36:49,820 [11] DEBUG NHibernate.Type.Int32Type - returning > null as column: col_14_0_ > 2016-03-21 14:36:49,820 [11] DEBUG NHibernate.Type.StringType - returning > null as column: col_15_0_ > 2016-03-21 14:36:49,820 [11] DEBUG NHibernate.Loader.Loader - done > processing result set (35 rows) > 2016-03-21 14:36:49,820 [11] DEBUG NHibernate.Driver.NHybridDataReader - > running NHybridDataReader.Dispose() > 2016-03-21 14:36:49,820 [11] DEBUG NHibernate.AdoNet.AbstractBatcher - > Closed IDataReader, open IDataReaders :0 > 2016-03-21 14:36:49,820 [11] DEBUG NHibernate.AdoNet.AbstractBatcher - > DataReader was closed after 32 ms > 2016-03-21 14:36:49,820 [11] DEBUG NHibernate.AdoNet.AbstractBatcher - > Closed IDbCommand, open IDbCommands: 0 > 2016-03-21 14:36:49,820 [11] DEBUG NHibernate.AdoNet.ConnectionManager - > aggressively releasing database connection > 2016-03-21 14:36:49,820 [11] DEBUG > NHibernate.Connection.ConnectionProvider - Closing connection > 2016-03-21 14:36:49,820 [11] DEBUG > NHibernate.Engine.StatefulPersistenceContext - initializing non-lazy > collections > 2016-03-21 14:36:49,840 [11] DEBUG NHibernate.Util.ADOExceptionReporter - > Could not execute query > [ SQL not available ] > > System.NullReferenceException: Object reference not set to an instance of > an object. > at lambda_method(Closure , Object[] ) > at NHibernate.Linq.ResultTransformer.TransformTuple(Object[] tuple, > String[] aliases) > at NHibernate.Hql.HolderInstantiator.Instantiate(Object[] row) > at NHibernate.Loader.Hql.QueryLoader.GetResultList(IList results, > IResultTransformer resultTransformer) > at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor > session, QueryParameters queryParameters) > at NHibernate.Loader.Loader.List(ISessionImplementor session, > QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) > at NHibernate.Loader.Hql.QueryLoader.List(ISessionImplementor session, > QueryParameters queryParameters) > at > NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.List(ISessionImplementor > session, QueryParameters queryParameters) > at NHibernate.Engine.Query.HQLQueryPlan.PerformList(QueryParameters > queryParameters, ISessionImplementor session, IList results) > at NHibernate.Impl.SessionImpl.List(IQueryExpression queryExpression, > QueryParameters queryParameters, IList results) > 2016-03-21 14:36:49,843 [11] WARN NHibernate.Util.ADOExceptionReporter - > System.NullReferenceException: Object reference not set to an instance of > an object. > at lambda_method(Closure , Object[] ) > at NHibernate.Linq.ResultTransformer.TransformTuple(Object[] tuple, > String[] aliases) > at NHibernate.Hql.HolderInstantiator.Instantiate(Object[] row) > at NHibernate.Loader.Hql.QueryLoader.GetResultList(IList results, > IResultTransformer resultTransformer) > at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor > session, QueryParameters queryParameters) > at NHibernate.Loader.Loader.List(ISessionImplementor session, > QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) > at NHibernate.Loader.Hql.QueryLoader.List(ISessionImplementor session, > QueryParameters queryParameters) > at > NHibernate.Hql.Ast.ANTLR.QueryTranslatorImpl.List(ISessionImplementor > session, QueryParameters queryParameters) > at NHibernate.Engine.Query.HQLQueryPlan.PerformList(QueryParameters > queryParameters, ISessionImplementor session, IList results) > at NHibernate.Impl.SessionImpl.List(IQueryExpression queryExpression, > QueryParameters queryParameters, IList results) > 2016-03-21 14:36:49,843 [11] ERROR NHibernate.Util.ADOExceptionReporter - > Object reference not set to an instance of an object. > 2016-03-21 14:37:02,383 [11] DEBUG NHibernate.AdoNet.ConnectionManager - > after autocommit > > > > > *This is the query of the view the 35 rows come from:* > create view vCustomersServicesSets > as > > select > ROW_NUMBER() OVER(ORDER BY aa.ServiceRecid DESC) AS > 'CustomerServiceSetRecid' <-- is this something nHibernate can't deal > with? And if so what can be done? > .... > , bb.ModifiedByName > from > ( > select > a.ServiceRecid > ..... > , b.CustomerEnabled > from vServices a > , vCustomers b > ) aa > left join ...... > go > > > > > > *This is my class from the embedded mapping:* > <class name ="vCustomersServiceOptions" > table="dbo.vCustomersServicesSets" dynamic-update="true"> > <cache usage="read-only"/> > <id name="CustomerServiceSetRecid" column="CustomerServiceSetRecid" > type="int"> > <generator class="native" /> > </id> > <property name="DataEntryRowDisabled" /> > ....... > <property name="ModifiedByName" /> > </class> > > > *What do I do?* > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/nhusers. For more options, visit https://groups.google.com/d/optout.
