Hibernate 三种连接池的写法

第一种方法 使用webloigc 的数据库连接池即：JNDI数据连接池

<bean id="dataSource" class="org.springframework.jndi.JndiObjectFactoryBean">  
    <property name="jndiName">
     <value>jdbc/jyxt</value>
    </property>
    <property name="resourceRef">
     <value>false</value>
    </property>
    <property name="jndiEnvironment">
     <props>
      <prop key="java.naming.provider.url">
       t3://localhost:7070
      </prop>
      <prop key="java.naming.factory.initial">
       weblogic.jndi.WLInitialContextFactory
      </prop>
    </props>
   </property>
</bean>

 <bean id="sessionFactory"
  class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
  <property name="dataSource">
   <ref local="dataSource" />
  </property>
  <property name="mappingResources">
   <list>
    <value>
     jyxt/model/admin/system/user/UserInfo.hbm.xml
    </value>
    <value>
     jyxt/model/admin/system/department/Department.hbm.xml
    </value>
    <value>
     jyxt/model/admin/system/systemlog/SystemLog.hbm.xml
    </value>
    <value>
     jyxt/model/admin/system/role/RoleInfo.hbm.xml
    </value>
    <value>
     jyxt/model/admin/system/menu/Menuinfo.hbm.xml
    </value>
    <value>
     jyxt/model/admin/system/menupop/MenuPope.hbm.xml
    </value>
    <value>
     jyxt/model/admin/system/role/RoleMenuPope.hbm.xml
    </value>
    <value>
     jyxt/model/admin/system/userrole/UserRole.hbm.xml
    </value>
    <value>
     jyxt/model/admin/system/parament/RefParam.hbm.xml
    </value>
    <value>
     jyxt/model/admin/information/country/CountryInfo.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/register/MemberInfo.hbm.xml
    </value>
    <value>
     jyxt/model/admin/jymanager/lucksky/signup/JyxtSignup.hbm.xml
    </value>
    <value>
     jyxt/model/admin/jymanager/lucksky/leavewword/JyxtLeaveword.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/lovestory/OurSpace.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/lovestory/album/SpaceAlbum.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/lovestory/critique/SpaceComments.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/lovestory/story/LoveStory.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/lovestory/story/critique/StoryComments.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/mooddiary/MoodDiary.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/mooddiary/critique/DiaryComments.hbm.xml
    </value>
    
    <value>jyxt/model/admin/system/year/Jyyear.hbm.xml</value>
    
    <value>jyxt/model/jyweb/myjuyuan/Memberphoto.hbm.xml</value>
    
    <value>jyxt/model/admin/jymanager/lucksky/affiche/JyxtAffiche.hbm.xml</value>
    <value>
     jyxt/model/jyweb/loveinfo/mymail/MyMail.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/loveinfo/myleer/MyLeer.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/loveinfo/myattention/MyAttention.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/loveinfo/myskim/MySkim.hbm.xml
    </value>
    <value>
     jyxt/model/admin/jymanager/lucksky/marriageup/JyxtMarriage.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/search/manage/SearchMemberInfo.hbm.xml
    </value>
    <value>
     jyxt/model/admin/jymanager/lucksky/gueststoview/JyxtGueststoview.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/myjuyuan/shieldmember/Shieldmember.hbm.xml
    </value>
    <value>
     jyxt/model/admin/jymanager/lucksky/video/JyxtVideo.hbm.xml
    </value>
    <value>
     jyxt/model/admin/jymanager/lucksky/accperiod/JyxtAccperiod.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/validate/IdentityValidate.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/applymember/ApplyMember.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/hongniang/regonline/OnlineRegister.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/hongniang/feedback/Feedback.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/loveinfo/linkmandynamic/LinkmanDynamic.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/hongniang/vip/VipInfo.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/hongniang/vip/ServiceManage.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/loveinfo/mymail/SysMail.hbm.xml
    </value>
    <value>
     jyxt/model/admin/jymanager/accessmode/AccessMode.hbm.xml
    </value>
    <value>
     jyxt/model/admin/lognum/Loginnum.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/campaign/Campaign.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/campaign/CamPhoto.hbm.xml
    </value>
    <value>
     jyxt/model/jyweb/campaign/CamLeaveword.hbm.xml
    </value>
   </list>
  </property>
  <property name="hibernateProperties">
   <props>
    <prop key="hibernate.dialect">
     org.hibernate.dialect.OracleDialect
    </prop>
    <prop key="hibernate.query.factory_class"><!--
     这是hibernate2.0的
     org.hibernate.hql.classic.ClassicQueryTranslatorFactory
    -->
     org.hibernate.hql.ast.ASTQueryTranslatorFactory
    </prop>
    <prop key="hibernate.show_sql">false</prop>
    <prop key="hibernate.max_fetch_depth">2</prop>
    <prop key="hibernate.jdbc.fetch_size">100</prop>
    <prop key="hibernate.jdbc.batch_size">100</prop>
    <prop key="hibernate.hbm2ddl.auto">update</prop>
    <!--add ehcache-->
    <!-- <prop key="hibernate.cache.provider_class">org.hibernate.cache.EhCacheProvider</prop> -->             
                <prop key="hibernate.cache.use_query_cache">false</prop><!-- 是否使用查询缓存 -->
                <!--
                <prop key="hibernate.cache.provider_configuration_file_resource_path">/ehcache.xml</prop>
    -->
            
    
   </props>
  </property>
 </bean>

第二种使用C3PO数据库连接池

   <bean id="dataSource"
  class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">
  <property name="driverClass" value="oracle.jdbc.driver.OracleDriver"/>
  <property name="jdbcUrl" value="jdbc:oracle:thin:@10.10.10.55:1521:oradb10g"/>
  <property name="user" value="jy"/>
  <property name="password" value="angel"/>

  <property name="maxPoolSize" value="100"/>
  <property name="minPoolSize" value="10"/>
  <property name="initialPoolSize" value="30"/>
  <property name="maxIdleTime" value="60"/>
  <property name="acquireIncrement"  value="10"/>   
  <property name="maxStatements"  value="10"/>   
  <property name="idleConnectionTestPeriod"  value="60"/>   
  <property name="testConnectionOnCheckout" value="false" />
  <property name="breakAfterAcquireFailure"  value="false"/> 
        <property name="acquireRetryAttempts" value="30"/>
        <property name="acquireRetryDelay" value="1000"/>
   
 </bean>
   

第三种是DBCP连接池

  
<bean id="dataSource"
  class="org.apache.commons.dbcp.BasicDataSource">
  <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
  <property name="url" value="jdbc:oracle:thin:@10.10.10.55:1521:oradb10g"/>
  <property name="username" value="jy"/>
  <property name="password" value="angel"/>
  <property name="maxActive" value="350"/>
  <property name="maxIdle" value="200"/>
  <property name="minIdle" value="10"/>
  <property name="maxWait" value="5000"/>
  <property name="poolPreparedStatements" value="true"/>
  <property name="maxOpenPreparedStatements" value="100"/>
  <property name="defaultAutoCommit" value="true"/>
  <property name="defaultReadOnly" value="false"/>
  <property name="removeAbandoned" value="true"/>
  <property name="removeAbandonedTimeout" value="60"/>
 </bean>

以上三种数据库连接池方法，我的使用感觉使用的效率依次为：

  第一种、第二种、第三种 依此次之。

 <Directory "E:/jyapp/jyxt/WEB-INF/">
  Order deny,allow
  deny from all
 </Directory>