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]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
