Now I see. There was a bug identified in NH-1362 specifically with refresh where there are children of children.
http://216.121.112.228/browse/NH-1362 It was fixed, but you need to be running NHibernate 2.0 or greater to have it work. Sorry! John Davidson On Fri, Jun 25, 2010 at 8:55 AM, [email protected] < [email protected]> wrote: > That is the Query sended from NHibernate to the SQL-Server. Please not > if I run the query in SQL-Server Management Studio the query executes > successfully. > > That is running when I call. > session.Refresh(cockpit); > > declare @p1 int > set @p1=733 > exec sp_prepexec @p1 output,N'@p0 nvarchar(4000)',N'SELECT > ac5cockpit0_.C_ID as C_ID8_, ac5cockpit0_.THUMBNAIL as THUMBNAIL8_, > ac5cockpit0_.AF_ID as AF_ID8_, ac5cockpit0_.LAYOUT as LAYOUT8_, > ac5analyse1_.AF_ID as AF_ID0_, ac5analyse1_.P_AF_ID as P_AF_ID0_, > ac5analyse1_.CREATOR_ID as CREATOR_ID0_, ac5analyse1_.IS_PUBLIC as > IS_PUBLIC0_, employee2_.MITARBEITER_ID as MITARBEI1_1_, > employee2_.ANREDE_ID as ANREDE_ID1_, employee2_.BEMERKUNG as > BEMERKUNG1_, employee2_.KENNZEICHEN3 as KENNZEI21_1_, > employee2_.KENNUNG as KENNUNG1_, employee2_.KENNZEICHEN2 as > KENNZEI20_1_, employee2_.LANGUAGE_ID_EDIT as LANGUAG28_1_, > employee2_.DUMKEY as DUMKEY1_, employee2_.EMAIL as EMAIL1_, > employee2_.TELEFAX as TELEFAX1_, employee2_.INFO1 as INFO11_, > employee2_.KURZZEICHEN as KURZZEI18_1_, employee2_.DEFAULT_MITARBEITER > as DEFAULT29_1_, employee2_.IMDS_ID as IMDS_ID1_, > employee2_.DEFAULT_STELLE_ID as DEFAULT31_1_, employee2_.VORNAME as > VORNAME1_, employee2_.MITARBEITER_NR as MITARBEI4_1_, > employee2_.KENNZEICHEN1 as KENNZEI19_1_, employee2_.AUSTRITTSDATUM as > AUSTRIT14_1_, employee2_.EINTRITTSDATUM as EINTRIT13_1_, > employee2_.MOBILTELEFON as MOBILTEL9_1_, employee2_.INFO3 as INFO31_, > employee2_.INFO2 as INFO21_, employee2_.SYSTEM_MITARBEITER as > SYSTEM_30_1_, employee2_.TITEL as TITEL1_, employee2_.LANGUAGE_ID as > LANGUAG15_1_, employee2_.DOMAENE as DOMAENE1_, employee2_.TELEFON as > TELEFON1_, employee2_.MITARBEITER_GUID as MITARBE17_1_, > employee2_.WERK_ID as WERK_ID1_, employee2_.NACHNAME as NACHNAME1_, > images3_.MITARBEITER_ID as MITARBEI2___, images3_.MI_ID as MI_ID__, > images3_.MI_ID as MI_ID2_, images3_.MITARBEITER_ID as MITARBEI2_2_, > images3_.BILD as BILD2_, images3_.TYP as TYP2_, employment4_.STELLE_ID > as STELLE_ID3_, employment4_.ORGA_ID as ORGA_ID3_, employment4_.DUMKEY > as DUMKEY3_, organisati5_.ORGA_ID as ORGA_ID4_, organisati5_.PARENT_ID > as PARENT_ID4_, organisati5_.DUMKEY as DUMKEY4_, pool6_.POOL_ID as > POOL_ID5_, pool6_.TYP_ID as TYP_ID5_, pool6_.ORG_ID as ORG_ID5_, > pool6_.MITARBEITER_ID as MITARBEI3_5_, businesspa7_.ORG_ID as > ORG_ID6_, businesspa7_.TS_UPDATE as TS_UPDATE6_, businesspa7_.ORG_TYP > as ORG_TYP6_, businesspa7_.DEFAULT_ORG as DEFAULT_3_6_, > businesspa7_.DUMKEY as DUMKEY6_, mmfolder8_.ORDNER_ID as ORDNER_ID7_, > mmfolder8_.MITARBEITER_ID as MITARBEI6_7_, mmfolder8_.PARENT_ID as > PARENT_ID7_, mmfolder8_.BEMERKUNG as BEMERKUNG7_, mmfolder8_.WERK_ID > as WERK_ID7_, mmfolder8_.TITEL as TITEL7_ FROM > IQSCAQ_MM_DEMO3.dbo.AC5_COCKPIT ac5cockpit0_ left outer join > IQSCAQ_MM_DEMO3.dbo.AC5_ANALYSE_FOLDER ac5analyse1_ on > ac5cockpit0_.AF_ID=ac5analyse1_.AF_ID left outer join > IQSCAQ_MM_DEMO3.dbo.IQS_ORG_MITARBEITER employee2_ on > ac5analyse1_.CREATOR_ID=employee2_.MITARBEITER_ID left outer join > IQSCAQ_MM_DEMO3.dbo.IQS_ORG_MITARBEITER_IMAGE images3_ on > employee2_.MITARBEITER_ID=images3_.MITARBEITER_ID left outer join > IQSCAQ_MM_DEMO3.dbo.IQS_ORG_STELLE employment4_ on > employee2_.DEFAULT_STELLE_ID=employment4_.STELLE_ID left outer join > IQSCAQ_MM_DEMO3.dbo.IQS_ORG_ABT organisati5_ on > employment4_.ORGA_ID=organisati5_.ORGA_ID left outer join > IQSCAQ_MM_DEMO3.dbo.PMV_POOLS pool6_ on > employee2_.MITARBEITER_ID=pool6_.MITARBEITER_ID left outer join > IQSCAQ_MM_DEMO3.dbo.IQS_ORG businesspa7_ on > pool6_.ORG_ID=businesspa7_.ORG_ID left outer join > IQSCAQ_MM_DEMO3.dbo.MM_ORDNER mmfolder8_ on > employee2_.MITARBEITER_ID=mmfolder8_.MITARBEITER_ID WHERE > ac5cockpit0_.c_...@p0',@p0=N'9f73fd52-2239-430b-9faf-f5a5b7fad23b' > select @p1 > > > The HQL for selection wich fails is: > > FROM Ac5Cockpit AS c WHERE c.CId = '...'; > > But it always runs as exspected when i do: > > FROM Ac5Cockpit AS c INNER JOIN FETCH c.AfId WHERE c.CId = '...' > > Hope it helps. > > -- > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- 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.
