I thought you worked with linq. A test case with mapping etc is appreciated.
Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Thu, Aug 6, 2009 at 5:08 PM, nicco80 <[email protected]> wrote: > > Sorry for being imprecise on that. > i do not perform a nested query but a query on quite nested mapping. > > this used to work correctly with nh1.2 > > i have a class hierarchy, performing the following call > session.Delete("from ObjectData o where o.DataOrigin = :DataOrigin", > object.Id, > NHibernate.NHibernateUtil.Int64); > > will trigger the exception - i already posted the inner exception, so > here goes the adoexception carrying the inner nullreferenceexception > thanks for any ideas on this > regards > > could not execute query > [ select objectdata0_.Id as Id2_, objectdata0_.CheckTime as > CheckTime2_, objectdata0_.ResponseTime as Response3_2_, > objectdata0_.StatusFlag as StatusFlag2_, objectdata0_.Status as > Status2_, objectdata0_.DataOrigin as DataOrigin2_, > objectdata0_.CheckExceptionMessage as CheckExc7_2_, > objectdata0_2_.AvailableBytes as Availabl2_27_, > objectdata0_2_.TotalBytes as TotalBytes27_, objectdata0_2_.UsedBytes > as UsedBytes27_, objectdata0_3_.Result as Result28_, > objectdata0_3_.RecordsAffected as RecordsA3_28_, > objectdata0_3_.RowsSelected as RowsSele4_28_, > objectdata0_4_.ErrorStreamContent as ErrorStr2_31_, > objectdata0_4_.OutputStreamContent as OutputSt3_31_, > objectdata0_4_.ExitCode as ExitCode31_, objectdata0_5_.HttpStatusCode > as HttpStat2_36_, objectdata0_5_.HttpStatusDescription as > HttpStat3_36_, objectdata0_5_.ContentType as ContentT4_36_, > objectdata0_5_.ContentEncoding as ContentE5_36_, > objectdata0_5_.ContentLength as ContentL6_36_, > objectdata0_5_.ResponseCharacterSet as Response7_36_, > objectdata0_5_.Checksum as Checksum36_, objectdata0_5_.ContentBytes as > ContentB9_36_, objectdata0_6_.RemoteIp as RemoteIp37_, > objectdata0_6_.RemotePort as RemotePort37_, objectdata0_7_.AverageTime > as AverageT2_38_, objectdata0_7_.StandardDeviation as Standard3_38_, > objectdata0_7_.MinimumTime as MinimumT4_38_, > objectdata0_7_.MaximumTime as MaximumT5_38_, > objectdata0_7_.AnswerPackages as AnswerPa6_38_, > objectdata0_7_.LostPackages as LostPack7_38_, > objectdata0_8_.ConnectionOk as Connecti2_40_, > objectdata0_8_.DnsResponseCode as DnsRespo3_40_, > objectdata0_8_.Records as Records40_, case when > objectdata0_5_.NetworkobjectData_Id is not null then 5 when > objectdata0_6_.NetworkobjectData_Id is not null then 6 when > objectdata0_7_.NetworkobjectData_Id is not null then 7 when > objectdata0_8_.NetworkobjectData_Id is not null then 8 when > objectdata0_1_.objectData_Id is not null then 1 when > objectdata0_2_.objectData_Id is not null then 2 when > objectdata0_3_.objectData_Id is not null then 3 when > objectdata0_4_.objectData_Id is not null then 4 when objectdata0_.Id > is not null then 0 end as clazz_ from objectData objectdata0_ left > outer join NetworkobjectData objectdata0_1_ on > objectdata0_.Id=objectdata0_1_.objectData_Id left outer join > DiskobjectData objectdata0_2_ on > objectdata0_.Id=objectdata0_2_.objectData_Id left outer join > DatabaseobjectData objectdata0_3_ on > objectdata0_.Id=objectdata0_3_.objectData_Id left outer join > ExecobjectData objectdata0_4_ on > objectdata0_.Id=objectdata0_4_.objectData_Id left outer join > HttpobjectData objectdata0_5_ on > objectdata0_.Id=objectdata0_5_.NetworkobjectData_Id left outer join > SocketobjectData objectdata0_6_ on > objectdata0_.Id=objectdata0_6_.NetworkobjectData_Id left outer join > ICMPobjectData objectdata0_7_ on > objectdata0_.Id=objectdata0_7_.NetworkobjectData_Id left outer join > DNSobjectData objectdata0_8_ on > objectdata0_.Id=objectdata0_8_.NetworkobjectData_Id where > objectdata0_.DataOrigin=? ] > > > On Aug 6, 3:03 pm, Tuna Toksoz <[email protected]> wrote: > > Nested queries are not really supported. > > > > Tuna Toksöz > > Eternal sunshine of the open source mind. > > > > > http://devlicio.us/blogs/tuna_toksozhttp://tunatoksoz.comhttp://twitter.com/tehlike > > > > On Thu, Aug 6, 2009 at 4:00 PM, nicco80 <[email protected]> > wrote: > > > > > Hi, > > > when performing a linq.select on a quite nested query i get an > > > adoexception > > > "could not execute query" with a NullReferenceException as an > > > innerexception - > > > has anybody seen this stacktrace already? > > > > > (innerexception): > > > at NHibernate.Param.NamedParameterSpecification.Bind(IDbCommand > > > statement, QueryParameters qp, ISessionImplementor session, Int32 > > > position) > > > at NHibernate.Hql.Ast.ANTLR.Loader.QueryLoader.BindParameterValues > > > (IDbCommand statement, QueryParameters queryParameters, Int32 > > > startIndex, ISessionImplementor session) > > > at NHibernate.Loader.Loader.PrepareQueryCommand(QueryParameters > > > queryParameters, Boolean scroll, ISessionImplementor session) > > > at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, > > > QueryParameters queryParameters, Boolean returnProxies) > > > at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections > > > (ISessionImplementor session, QueryParameters queryParameters, Boolean > > > returnProxies) > > > at NHibernate.Loader.Loader.DoList(ISessionImplementor session, > > > QueryParameters queryParameters) > > > > > thanks, > > > regards nico > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
