I here is my webconfig file
Code:
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
<sectionGroup name="spring">
<section name="context" type="Spring.Context.Support.ContextHandler, Spring.Core"/>
<section name="objects" type="Spring.Context.Support.DefaultSectionHandler, Spring.Core" />
</sectionGroup>
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler,log4net, Version=1.2.9.0, Culture=neutral, PublicKeyToken=b32731d11ce58905" />
</configSections>
<spring>
<context>
<resource uri="config://spring/objects"/>
</context>
<objects xmlns="http://www.springframework.net">
<object singleton="false" id="EmployeeDAO" type="Persistence.EmployeeDAO, Persistence"/>
</objects>
</spring>
<appSettings>
<!-- User application and configured property settings go here.-->
<!-- Example: <add key="settingName" value="settingValue"/> -->
<!--add key="SqlDataSource" value="SOC-APP01" />-->
<!--add key="SqlCatalog" value="SOC" /> -->
</appSettings>
<log4net debug="true">
<!-- Define some output appenders -->
<appender name="trace" type="log4net.Appender.TraceAppender, log4net">
<layout type="log4net.Layout.PatternLayout,log4net">
<param name="ConversionPattern" value="%d [%t] %-5p %c - %m%n" />
</layout>
</appender>
<appender name="console" type="log4net.Appender.ConsoleAppender, log4net">
<layout type="log4net.Layout.PatternLayout,log4net">
<param name="ConversionPattern" value="%d [%t] %-5p %c - %m%n" />
</layout>
</appender>
<appender name="NHibernateLog" type="log4net.Appender.RollingFileAppender,log4net" >
<param name="File" value="Logs/NHibernateLog.txt" />
<param name="AppendToFile" value="false" />
<param name="RollingStyle" value="Date" />
<param name="DatePattern" value="yyyy.MM.dd" />
<param name="StaticLogFileName" value="true" />
<layout type="log4net.Layout.PatternLayout,log4net">
<param name="ConversionPattern" value="%d [%t] %-5p %c - %m%n" />
</layout>
</appender>
<appender name="SpringLog" type="log4net.Appender.RollingFileAppender,log4net" >
<param name="File" value="Logs/SpringLog.txt" />
<param name="AppendToFile" value="false" />
<param name="RollingStyle" value="Date" />
<param name="DatePattern" value="yyyy.MM.dd" />
<param name="StaticLogFileName" value="true" />
<layout type="log4net.Layout.PatternLayout,log4net">
<param name="ConversionPattern" value="%d [%t] %-5p %c - %m%n" />
</layout>
</appender>
<!-- Setup the root category, add the appenders and set the default priority -->
<root>
<priority value="INFO" />
<appender-ref ref="console" />
</root>
<logger name="Spring">
<level value="DEBUG"/>
<appender-ref ref="SpringLog" />
</logger>
<logger name="NHibernate" additivity="true">
<level value="DEBUG" />
<appender-ref ref="NHibernateLog" />
</logger>
<logger name="NHibernate.SQL" additivity="true">
<level value="DEBUG" />
<appender-ref ref="NHibernateLog" />
</logger>
</log4net>
here is my log file
Quote:
2005-11-16 15:42:07,640 [3024] DEBUG NHibernate.Cfg.Environment - no hibernate settings in app.config/web.config were found
2005-11-16 15:42:07,640 [3024] DEBUG NHibernate.Cfg.Configuration - connection.provider=NHibernate.Connection.DriverConnectionProvider
2005-11-16 15:42:07,640 [3024] DEBUG NHibernate.Cfg.Configuration - connection.driver_class=NHibernate.Driver.SqlClientDriver
2005-11-16 15:42:07,640 [3024] DEBUG NHibernate.Cfg.Configuration - connection.connection_string=Server=PANDA;initial catalog=Northwind;User ID=asd;Password=qweqwe;Min Pool Size=2
2005-11-16 15:42:07,640 [3024] DEBUG NHibernate.Cfg.Configuration - show_sql=true
2005-11-16 15:42:07,640 [3024] DEBUG NHibernate.Cfg.Configuration - dialect=NHibernate.Dialect.MsSql2000Dialect
2005-11-16 15:42:07,640 [3024] DEBUG NHibernate.Cfg.Configuration - use_outer_join=true
2005-11-16 15:42:07,640 [3024] DEBUG NHibernate.Cfg.Configuration - query.substitutions=true 1, false 0, yes 'Y', no 'N'
2005-11-16 15:42:07,640 [3024] DEBUG NHibernate.Cfg.Configuration - HBSpringSessionFactory<-Persistence
2005-11-16 15:42:07,640 [3024] INFO NHibernate.Cfg.Configuration - searching for mapped documents in assembly: Persistence
2005-11-16 15:42:07,640 [3024] INFO NHibernate.Cfg.Configuration - Configured SessionFactory: HBSpringSessionFactory
2005-11-16 15:42:07,640 [3024] DEBUG NHibernate.Cfg.Configuration - properties: System.Collections.Hashtable
2005-11-16 15:42:07,640 [3024] INFO NHibernate.Cfg.Configuration - processing one-to-many association mappings
2005-11-16 15:42:07,640 [3024] INFO NHibernate.Cfg.Configuration - processing one-to-one association property references
2005-11-16 15:42:07,640 [3024] INFO NHibernate.Cfg.Configuration - processing foreign key constraints
2005-11-16 15:42:07,640 [3024] INFO NHibernate.Dialect.Dialect - Using dialect: NHibernate.Dialect.MsSql2000Dialect
2005-11-16 15:42:07,640 [3024] INFO NHibernate.Cfg.SettingsFactory - use outer join fetching: True
2005-11-16 15:42:07,640 [3024] INFO NHibernate.Connection.ConnectionProviderFactory - Intitializing connection provider: NHibernate.Connection.DriverConnectionProvider
2005-11-16 15:42:07,640 [3024] INFO NHibernate.Connection.ConnectionProvider - Configuring ConnectionProvider
2005-11-16 15:42:07,640 [3024] INFO NHibernate.Cfg.SettingsFactory - Optimize cache for minimal puts: False
2005-11-16 15:42:07,640 [3024] INFO NHibernate.Cfg.SettingsFactory - echoing all SQL to stdout
2005-11-16 15:42:07,640 [3024] INFO NHibernate.Cfg.SettingsFactory - Query language substitutions: {yes='Y', true=1, no='N', false=0}
2005-11-16 15:42:07,640 [3024] INFO NHibernate.Cfg.SettingsFactory - cache provider: NHibernate.Cache.HashtableCacheProvider
2005-11-16 15:42:07,640 [3024] INFO NHibernate.Cfg.Configuration - instantiating and configuring caches
2005-11-16 15:42:07,640 [3024] INFO NHibernate.Impl.SessionFactoryImpl - building session factory
2005-11-16 15:42:07,640 [3024] DEBUG NHibernate.Impl.SessionFactoryImpl - instantiating session factory with properties: {show_sql=true, connection.provider=NHibernate.Connection.DriverConnectionProvider, dialect=NHibernate.Dialect.MsSql2000Dialect, connection.driver_class=NHibernate.Driver.SqlClientDriver, hibernate.session_factory_name=HBSpringSessionFactory, hibernate.use_outer_join=true, hibernate.connection.connection_string=Server=PANDA;initial catalog=Northwind;User ID=asd;Password=qweqwe;Min Pool Size=2, hibernate.connection.driver_class=NHibernate.Driver.SqlClientDriver, query.substitutions=true 1, false 0, yes 'Y', no 'N', connection.connection_string=Server=PANDA;initial catalog=Northwind;User ID=asd;Password=qweqwe;Min Pool Size=2, hibernate.connection.provider=NHibernate.Connection.DriverConnectionProvider, hibernate.dialect=NHibernate.Dialect.MsSql2000Dialect, use_outer_join=true, hibernate.show_sql=true, hibernate.query.substitutions=true 1, false 0, yes 'Y', no 'N'}
2005-11-16 15:42:07,640 [3024] DEBUG NHibernate.Impl.SessionFactoryObjectFactory - initializing class SessionFactoryObjectFactory
2005-11-16 15:42:07,640 [3024] DEBUG NHibernate.Impl.SessionFactoryObjectFactory - registered: b295430ca6554e53966ebfbb5b43a9a3(HBSpringSessionFactory)
2005-11-16 15:42:07,640 [3024] INFO NHibernate.Impl.SessionFactoryObjectFactory - Factory name:HBSpringSessionFactory
2005-11-16 15:42:07,640 [3024] DEBUG NHibernate.Impl.SessionFactoryImpl - Instantiated session factory
2005-11-16 15:42:07,640 [3024] DEBUG NHibernate.Impl.SessionImpl - opened session
2005-11-16 15:42:07,656 [3024] DEBUG NHibernate.Impl.SessionImpl - flushing session
2005-11-16 15:42:07,656 [3024] DEBUG NHibernate.Impl.SessionImpl - Flushing entities and processing referenced collections
2005-11-16 15:42:07,656 [3024] DEBUG NHibernate.Impl.SessionImpl - Processing unreferenced collections
2005-11-16 15:42:07,656 [3024] DEBUG NHibernate.Impl.SessionImpl - scheduling collection removes/(re)creates/updates
2005-11-16 15:42:07,656 [3024] DEBUG NHibernate.Impl.SessionImpl - Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects
2005-11-16 15:42:07,656 [3024] DEBUG NHibernate.Impl.SessionImpl - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
2005-11-16 15:42:07,656 [3024] DEBUG NHibernate.Impl.SessionImpl - dont need to execute flush
2005-11-16 15:42:07,656 [3024] DEBUG NHibernate.Impl.SessionImpl - flushing session
2005-11-16 15:42:07,656 [3024] DEBUG NHibernate.Impl.SessionImpl - Flushing entities and processing referenced collections
2005-11-16 15:42:07,656 [3024] DEBUG NHibernate.Impl.SessionImpl - Processing unreferenced collections
2005-11-16 15:42:07,656 [3024] DEBUG NHibernate.Impl.SessionImpl - scheduling collection removes/(re)creates/updates
2005-11-16 15:42:07,656 [3024] DEBUG NHibernate.Impl.SessionImpl - Flushed: 0 insertions, 0 updates, 0 deletions to 0 objects
2005-11-16 15:42:07,656 [3024] DEBUG NHibernate.Impl.SessionImpl - Flushed: 0 (re)creations, 0 updates, 0 removals to 0 collections
2005-11-16 15:42:07,656 [3024] DEBUG NHibernate.Impl.SessionImpl - executing flush
2005-11-16 15:42:07,656 [3024] DEBUG NHibernate.Impl.SessionImpl - post flush
2005-11-16 15:42:07,656 [3024] DEBUG NHibernate.Impl.SessionImpl - closing session
between the opening and closing of the session I retreived a Employee with my criteria using criteria.List(); It returned null. fine. But have no trace of the SQL formed by NHibernate.
Can anybody help
thanks
Login
FAQ
Search
