<!DOCTYPE hibernate-configuration PUBLIC
   "-//Hibernate/Hibernate Configuration DTD//EN"
   "http://hibernate.sourceforge.net/hibernate-configuration-2.0.dtd">
<hibernate-configuration>
   <session-factory>
      <!--put this back when using the web application name="java:comp/env/hibernate/SessionFactory"-->   
      
      <!-- ORACLE PROPERTIES -->
      <property name="hibernate.dialect">net.sf.hibernate.dialect.OracleDialect</property>
      <property name="hibernate.connection.driver_class">oracle.jdbc.driver.OracleDriver</property>
      <property name="hibernate.connection.username">rgiri</property>
      <property name="hibernate.connection.password">password</property>
      <property name="hibernate.connection.url">jdbc:oracle:thin:rgiri@//dev1:1521/csr</property>      
      <property name="hibernate.jdbc.batch_versioned_data">true</property>
      <property name="hibernate.jdbc.batch_size">20</property>
      <!-- the following only relevant if user supplied jdbc connection -->
      <property name="hibernate.jdbc.use_scrollable_resultset">true</property>
      
      <!-- TO BE USED ONLY WITHIN A APPSERVER -->
      <!--property name="hibernate.connection.datasource">SOME_VAL</property-->
      
      <!-- CONNECTION POOL -->
      <property name="hibernate.dbcp.maxActive">100</property>
      <property name="hibernate.dbcp.whenExhaustedAction">1</property>
      <property name="hibernate.dbcp.maxWait">120000</property>
      <property name="hibernate.dbcp.maxIdle">10</property>
      
      <!-- PREPARED STATEMENT CACHE -->
      <property name="hibernate.dbcp.ps.maxActive">100</property>
      <property name="hibernate.dbcp.ps.whenExhaustedAction">1</property>
      <property name="hibernate.dbcp.ps.maxWait">120000</property>
      <property name="hibernate.dbcp.ps.maxIdle">10</property>
      
      <!-- USE STREAMS WHEN WRITING BINARY TYPES TO/FROM JDBC -->
      <property name="hibernate.jdbc.use_streams_for_binary">true</property>   
      
      <!-- ONLY FOR DEVELOPMENT RUNS -->
      <property name="hibernate.cglib.use_reflection_optimizer">false</property>
      <property name="show_sql">false</property>
      
      <!-- MAPPING FILES -->                  
      <mapping resource="com/hfc/data/db/CSRLineDetail.hbm.xml"/>
      <mapping resource="com/hfc/data/db/CSRLineInfo.hbm.xml"/>
      <mapping resource="com/hfc/data/db/CSRSummaryInfo.hbm.xml"/>
      <mapping resource="com/hfc/data/db/Payer.hbm.xml"/>
      <mapping resource="com/hfc/data/db/ServiceAudit.hbm.xml"/>
      <mapping resource="com/hfc/data/db/ServiceProperty.hbm.xml"/>
      <mapping resource="com/hfc/data/db/X12Transaction.hbm.xml"/>
      <mapping resource="com/hfc/data/db/CategoryMap.hbm.xml"/>
      <mapping resource="com/hfc/data/db/RealTimeDefaults.hbm.xml"/>
   </session-factory>
</hibernate-configuration>