NHibernate操作Oracle的配置

 

我用的是Oracle9i,应用程序app.config的配置如下"

< configuration >
   <!--  Add this element  -->
   < configSections >
     < section  name ="hibernate-configuration"  type ="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate"   />
     < section  name ="log4net"  type ="log4net.Config.Log4NetConfigurationSectionHandler,log4net"   />
   </ configSections >
   <!--  Add this element  -->
   < hibernate-configuration  xmlns ="urn:nhibernate-configuration-2.2"    >
     <!-- <session-factory>
      <property name="dialect">NHibernate.Dialect.MsSql2000Dialect</property>
      <property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
      <property name="connection.connection_string">Server=BOCO-Terry\DATA;initial catalog=NHibernate;Integrated Security=true</property>
    </session-factory> -->
     < session-factory >
       < property  name ="dialect" > NHibernate.Dialect.OracleDialect </ property >
       < property  name ="connection.provider" > NHibernate.Connection.DriverConnectionProvider </ property >
       < property  name ="connection.connection_string" > user id=jkpt;data source=jkorasvr;password=designer; </ property >
       < property  name ="connection.isolation"   > ReadCommitted </ property >
       < property  name ="show_sql" > true </ property >
     </ session-factory >
   </ hibernate-configuration >
   < log4net >
     < appender  name ="ConsoleAppender"  type ="log4net.Appender.ConsoleAppender"   >
       < layout  type ="log4net.Layout.PatternLayout" >
         < conversionPattern  value ="%date [%thread] %-5level %logger [%ndc] - %message%newline"   />
       </ layout >
     </ appender >
     < root >
       < level  value ="ALL"   />
       < appender-ref  ref ="ConsoleAppender"   />
     </ root >

   </ log4net >
   <!--  Leave the system.web section unchanged  -->
   < system.web >
   </ system.web >
</ configuration >

 

其中把show_sql设置成true,就能在控制台看到调试的结果,即控制台下的调试配置.

log4net节点,不是必须的,这个是用在写日志配置的.