一定要将hbm.xml映射文件设置成嵌入的资源。
下面是mysql的映射文件:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name=" wh.db.test.model.Test, wh.db.test.model" table="test">
<!--主键-->
<id name="id" column="id" type="string" unsaved-value="0">
<!--非自增主键应该配置为assigned属性,自增主键应该配置成native-->
<generator class="assigned" />
</id>
<property name="name" column="name" type="string"/>
<property name="sex" column="sex" type="int"/>
<property name="address" column="address" type="string"/>
<property name="work" column="work" type="string"/>
</class>
</hibernate-mapping>
下面是oracle的映射文件:
<?xml version="1.0" encoding="utf-8" ?>
<hibernate-mapping xmlns="urn:nhibernate-mapping-2.2">
<class name="EPAP.SZ.Models.B_R_Szmjobcar, EPAP.SZ.Models" table="B_R_SZMJOBCAR">
<id name="Jobcarid" column="JOBCARID" type="int">
<generator class="sequence">
<param name="sequence">B_R_SZMJOBCAR_SEQ</param>
</generator>
</id>
<!--系统标识-->
<property name="Epapid" column="EPAPID" type="string" />
<!--作业分工单ID-->
<property name="Jdlistid" column="JDLISTID" type="int" />
<!--汽车管理ID-->
<property name="Carinfoid" column="CARINFOID" type="int" />
<!--车号-->
<property name="Carno" column="CARNO" type="string" />
<!--汽车司机-->
<property name="Driver" column="DRIVER" type="string" />
<!--汽车司机ID-->
<property name="Driverid" column="DRIVERID" type="string" />
<!--汽车司机电话-->
<property name="Drivertel" column="DRIVERTEL" type="string" />
<!--乘客-->
<property name="Passengers" column="PASSENGERS" type="string" />
<!--乘客ID-->
<property name="Passengersid" column="PASSENGERSID" type="string" />
<!--编号-->
<property name="Serialnumber" column="SERIALNUMBER" type="int" />
<!--作业前送地点-->
<property name="Sendaddress" column="SENDADDRESS" type="string" />
<!--作业后接地点-->
<property name="Receiveaddress" column="RECEIVEADDRESS" type="string" />
<!--出车时间-->
<property name="Dispatchtime" column="DISPATCHTIME" type="DateTime" />
<!--司机携带工具id-->
<property name="DriverCarryToolId" column="DRIVERCARRYTOOLID" type="int" />
</class>
</hibernate-mapping>
mysql的web.config配置参考:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="hibernate-configuration" type="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate" />
<!--用Log4Net记录NHibernate中执行的SQL语句及执行时间-->
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />
</configSections>
<!--NHibernate配置-->
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
<session-factory>
<property name="connection.provider">NHibernate.Connection.DriverConnectionProvider</property>
<property name="dialect">NHibernate.Dialect.MySQL5Dialect</property>
<!-- 版本改为 5-->
<property name="connection.driver_class">NHibernate.Driver.MySqlDataDriver</property>
<!--使用什么数据库-->
<property name="connection.connection_string">Server=127.0.0.1;Database=whtest;User ID=root;Password=123456</property>
<!-- Data Source=FirstSample.sdf 改为Server= localhost;Database=mygamedb;user ID=root;Password=root -->
<property name="show_sql">true</property>
<!--不配置hbm2ddl会报列“ReservedWord”不属于表 ReservedWords的错误-->
<property name="hbm2ddl.keywords">none</property>
<!--加载映射-->
<mapping assembly="wh.db.test.model"/>
</session-factory>
</hibernate-configuration>
<!--log4net配置-->
<log4net debug="true">
<appender name="ErrorLog" type="log4net.Appender.RollingFileAppender">
<param name="File" value="D:\\Services\\Logs\\Error\\" />
<param name="AppendToFile" value="true" />
<param name="RollingStyle" value="Date" />
<param name="DatePattern" value="yyyyMM\\yyyy-MM-dd".log"" />
<param name="StaticLogFileName" value="false" />
<layout type="log4net.Layout.PatternLayout">
<param name="ConversionPattern" value="%d [%t] %-5p %c [%x] - %m%n" />
</layout>
<filter type="log4net.Filter.LevelRangeFilter">
<!--只接受最小等级与最大等级之间的日志输出,其他的被过滤,这里接受WARN(警告),ERROR(错误),FATAL(致命)级别的输出-->
<param name="LevelMin" value="WARN" />
<param name="LevelMax" value="FATAL" />
</filter>
</appender>
<root>
<level value="ALL" />
<appender-ref ref="ErrorLog" />
</root>
</log4net>
<system.web>
<compilation debug="true" targetFramework="4.0" />
<!--需要配置该节点,不然HttpContext.current是为空的-->
<httpModules>
<add name="NHSessionFactory" type="wh.db.test.dao.DataBase.NHSessionFactory" />
</httpModules>
</system.web>
<system.serviceModel>
<behaviors>
<serviceBehaviors>
<behavior>
<!-- 为避免泄漏元数据信息,请在部署前将以下值设置为 false 并删除上面的元数据终结点 -->
<serviceMetadata httpGetEnabled="true"/>
<!-- 要接收故障异常详细信息以进行调试,请将以下值设置为 true。在部署前设置为 false 以避免泄漏异常信息 -->
<serviceDebug includeExceptionDetailInFaults="false"/>
</behavior>
</serviceBehaviors>
</behaviors>
<!--必须配置aspNetCompatibilityEnabled为true否则HttpContext.current为空-->
<serviceHostingEnvironment multipleSiteBindingsEnabled="true" aspNetCompatibilityEnabled="true"/>
</system.serviceModel>
<system.webServer>
<modules runAllManagedModulesForAllRequests="true"/>
</system.webServer>
</configuration>
oracle的web.config参考:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="hibernate-configuration" type="NHibernate.Cfg.ConfigurationSectionHandler, NHibernate" />
<!--用Log4Net记录NHibernate中执行的SQL语句及执行时间-->
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net" />
</configSections>
<appSettings file="Config/EPAPConfig.config">
<add key="Epapid" value="025" />
<add key ="WebUrl" value="http://192.168.1.161:1125"/>
</appSettings>
<!--nhibernate配置-->
<hibernate-configuration xmlns="urn:nhibernate-configuration-2.2">
<session-factory name="ora10gFactory">
<property name="dialect">NHibernate.Dialect.Oracle10gDialect</property>
<property name="connection.provider">NHibernate.Connection.DriverConnectionProvider, NHibernate</property>
<property name="connection.driver_class">NHibernate.Driver.OracleClientDriver</property>
<!--<property name="connection.driver_class">NHibernate.Driver.OracleManagedDataClientDriver</property>-->
<property name="connection.connection_string">
<!--User Id=epapsz;Password=epapsz;Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=TMIS)))-->
</property>
<property name="adonet.batch_size">10</property>
<property name="show_sql">false</property>
<property name="command_timeout">60</property>
<!--加载hibernate自动更新数据库结构,update为更新,none为不更新-->
<property name="hbm2ddl.auto">none</property>
<property name="query.substitutions">true 1, false 0, yes 'Y', no 'N'</property>
<property name="proxyfactory.factory_class">NHibernate.Bytecode.DefaultProxyFactoryFactory,NHibernate</property>
<property name="hbm2ddl.keywords">none</property>
<property name="cache.provider_class">NHibernate.Cache.HashtableCacheProvider</property>
<property name="cache.use_second_level_cache">false</property>
<property name="cache.use_query_cache">false</property>
<!--加载映射-->
<mapping assembly="EPAP.SZ.Models" />
<mapping assembly="EPAP.SZ.ViewModels" />
</session-factory>
</hibernate-configuration>
<!--log4net配置-->
<log4net debug="true">
<appender name="ErrorLog" type="log4net.Appender.RollingFileAppender">
<param name="File" value="D:\\Services\\Logs\\Error\\" />
<param name="AppendToFile" value="true" />
<param name="RollingStyle" value="Date" />
<param name="DatePattern" value="yyyyMM\\yyyy-MM-dd".log"" />
<param name="StaticLogFileName" value="false" />
<layout type="log4net.Layout.PatternLayout">
<param name="ConversionPattern" value="%d [%t] %-5p %c [%x] - %m%n" />
</layout>
<filter type="log4net.Filter.LevelRangeFilter">
<!--只接受最小等级与最大等级之间的日志输出,其他的被过滤,这里接受WARN(警告),ERROR(错误),FATAL(致命)级别的输出-->
<param name="LevelMin" value="WARN" />
<param name="LevelMax" value="FATAL" />
</filter>
</appender>
<root>
<level value="ALL" />
<appender-ref ref="ErrorLog" />
</root>
</log4net>
<system.web>
<compilation debug="true" targetFramework="4.0" />
<httpModules>
<add name="NHSessionFactory" type="EPAP.SZ.DAL.DataBase.NHSessionFactory" />
</httpModules>
</system.web>
<system.serviceModel>
<behaviors>
<serviceBehaviors>
<behavior>
<!-- 为避免泄漏元数据信息,请在部署前将以下值设置为 false 并删除上面的元数据终结点 -->
<serviceMetadata httpGetEnabled="true" />
<!-- 要接收故障异常详细信息以进行调试,请将以下值设置为 true。在部署前设置为 false 以避免泄漏异常信息 -->
<serviceDebug includeExceptionDetailInFaults="true" />
</behavior>
</serviceBehaviors>
</behaviors>
<!--管理会话状态-->
<serviceHostingEnvironment multipleSiteBindingsEnabled="true" aspNetCompatibilityEnabled="true"/>
<!--考勤一体机服务-->
<bindings>
<basicHttpBinding>
<!--其实要修改所有的服务,不管是服务端还是客户端,Binding那边增加一个没有设置名字的默认配置就OK了 maxBufferSize="2147483647"-->
<binding closeTimeout="00:10:00" receiveTimeout="00:10:00" sendTimeout="00:10:00"
maxReceivedMessageSize="2147483647" maxBufferSize="2147483647">
</binding >
</basicHttpBinding>
</bindings>
<!--考勤一体机服务end-->
</system.serviceModel>
<system.webServer>
<modules runAllManagedModulesForAllRequests="true" />
<validation validateIntegratedModeConfiguration="false" />
</system.webServer>
</configuration>