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.
