Spring/Hibernate/Proxool集成

最新推荐文章于 2016-06-15 10:11:12 发布

转载最新推荐文章于 2016-06-15 10:11:12 发布 · 3.2k 阅读

文章标签：

#hibernate #encoding #bean #class #数据库 #mysql

Oracle 同时被 3 个专栏收录

21 篇文章

订阅专栏

hibernate

16 篇文章

订阅专栏

spring

7 篇文章

订阅专栏

本文提供了一种使用Spring、Hibernate和Proxool进行数据库连接池配置的方法。详细展示了proxool.xml和applicationContext.xml文件的具体配置，包括数据库连接参数、连接池设置、Hibernate属性等。

参考了很多网友的文章和文档.现将Spring+Hibernate+Proxool的配置发表如下:
proxool.xml

<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
  <proxool>
    <alias>DBPool</alias>
    <driver-url>jdbc:mysql://localhost:3306/db</driver-url>
    <driver-class>com.mysql.jdbc.Driver</driver-class>
    <driver-properties>
      <property name="user" value="root"/>
      <property name="password" value="123456"/>
    </driver-properties>
     <maximum-connection-count>50</maximum-connection-count>
      <minimum-connection-count>10</minimum-connection-count>
    <house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
  </proxool>
</something-else-entirely>

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>     <bean id="mySessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean" singleton="true">
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
                <prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.cglib.use_reflection_optimizer">true</prop>
                <prop key="hibernate.proxool.xml">proxool.xml</prop>
                <prop key="hibernate.proxool.pool_alias">DBPool</prop>

另外一种配置【很少见】：

   <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName">
    <value>org.logicalcobwebs.proxool.ProxoolDriver</value>
    </property>
    <property name="url">
    <value>proxool.db</value>
    </property>
    </bean>

<bean id="sessionFactory" lazy-init ="true"
    class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
        
        <property name="dataSource"><ref local="dataSource"/></property>
        <property name="lobHandler" ref="lobHandler"/>

        <property name="mappingLocations">
            <list>
                
     <value>classpath:xxx/xxx/xxx/xx/xxx.hbm.xml</value>
            </list>
        </property>
        
        <property name="hibernateProperties">
            <props>
                
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
                
                <prop key="hibernate.hbm2ddl.auto">update</prop>
                <prop key="hibernate.show_sql">false</prop>
     <prop key="connection.useUnicode">true</prop>
     <prop key="connection.characterEncoding">UTF-8</prop>

            </props>
        </property>


    </bean>