Ok thank you. In fact, if I use your configuration, in the log i see all the generated SQL. Is there a specific explanation?
On Jun 29, 5:42 am, Ricardo Peres <[email protected]> wrote: > Forget the built-in SQL output functionality, you need to configure > log4net properly: > > <configuration> > <configSections> > <section name="log4net" > type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" > requirePermission="false"/> > ... > </configSections> > <log4net debug="false"> > <!-- for console --> > <appender name="console" > type="log4net.Appender.ConsoleAppender, > log4net"> > <layout type="log4net.Layout.PatternLayout, log4net"> > <param name="ConversionPattern" > value="%d{ABSOLUTE} %-5p %c{1}:%L > - %m%n" /> > </layout> > </appender> > <!-- for web --> > <appender name="web" > type="log4net.Appender.AspNetTraceAppender, > log4net"> > <layout type="log4net.Layout.PatternLayout,log4net"> > <param name="ConversionPattern" > value="%d{ABSOLUTE} %-5p %c{1}:%L > - %m%n" /> > </layout> > </appender> > <logger name="NHibernate.SQL"> > <priority value="DEBUG" /> > <!-- choose web or console --> > <appender-ref ref="console" /> > </logger> > </log4net> > ... > </configuration> > > Then, on your code, add this line before using NHibernate: > > XmlConfigurator.Configure(); > > On Jun 28, 5:50 pm, raffaeu <[email protected]> wrote: > > > > > > > > > Hi guys, I just noticed that sometimes, but not always, NHibernate > > does not generate in the trace all the SQL statements it fires... > > I am using Resharper with nUnit and NHibernate profiler and none of > > them is able to see the "hidden" statement. > > > I have an entity Person and an entity Address. > > Person has a <bag> of Address with inverse="true" and I create them in > > this way: > > > Person person = new ... > > Address address = new Address(person) // here I add the back reference > > person.AddAddress(address) > > > // save > > > ISession session = factory.GetSession(); > > session.Save(address); > > > // I can see only the statement: > > INSERT INTO ADDRESS > > > // but I can't see the statement: > > INSERT INTO PERSON > > > but the record in the Person table is properly added ... > > Why? -- 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.
