Spring+Hibernate 配置和使用c3p0和proxool连接池

其实原理都是一样 就是用一个继承了实现javax.sql.DataSource的DataSource类

在Spring中用bean来组装,管理 来配置其属性 提供给sessionFactory来组装

API上可能属性没有写出来 但是可以看到方法 要想真正了解 还是要看源代码中的详细属性

比如在cp30中这个具体的DataSource是

com.mchange.v2.c3p0.ComboPooledDataSource
他的源代码中有以下片段：

    .............

       public  String getDriverClass()
     ... { return dmds.getDriverClass(); }

     public   void  setDriverClass( String driverClass )  throws  PropertyVetoException
     ... { 
        dmds.setDriverClass( driverClass ); 
//      System.err.println("setting driverClass: " + driverClass); 
    }

     public  String getJdbcUrl()
     ... {  
//      System.err.println("getting jdbcUrl: " + dmds.getJdbcUrl()); 
        return dmds.getJdbcUrl(); 
    }

     public   void  setJdbcUrl( String jdbcUrl )
     ... { 
        dmds.setJdbcUrl( jdbcUrl ); 
        this.resetPoolManager( false );
//      System.err.println("setting jdbcUrl: " + jdbcUrl + " [dmds@" + C3P0ImplUtils.identityToken( dmds ) + "]"); 
//      if (jdbcUrl == null)
//      new Exception("*** NULL SETTER ***").printStackTrace();
    }

     public  Properties getProperties()
     ... { 
        //System.err.println("getting properties: " + dmds.getProperties()); 
        return dmds.getProperties(); 
    }

     public   void  setProperties( Properties properties )
     ... { 
        //System.err.println("setting properties: " + properties); 
        dmds.setProperties( properties ); 
        this.resetPoolManager(false);
    }

     //  DriverManagerDataSource "virtual properties" based on properties
     public  String getUser()
     ... { return dmds.getUser(); }

     public   void  setUser( String user )
     ... { 
        dmds.setUser( user ); 
        this.resetPoolManager( false );
    }

     public  String getPassword()
     ... { return dmds.getPassword(); }

     public   void  setPassword( String password )
     ... { 
        dmds.setPassword( password ); 
        this.resetPoolManager( false );

................

里面有个property属性的get和set方法

因此在bean中可以对其进行配置

组装到sessionFactory中之后 还可以通过hibernateProperties对Hibernate进行一些配置 

一   c3p0

beas-config.xml

 

<? xml version="1.0" encoding="UTF-8" ?>
<! DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd" >

< beans >

<!--  ===================================================================  -->
<!--  JDBC dataSource                                                      -->
<!--  ===================================================================  -->

<!--  ***********************************************************************
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName">
            <value>com.mysql.jdbc.Driver</value>
        </property>
        <property name="url">
            <value>jdbc:mysql://localhost:3306/shtest</value>
        </property>
        <property name="username">
            <value>root</value>
        </property>
        <property name="password">
            <value>password</value>
        </property>
    </bean>
************************************************************************  -->

<!--  ===================================================================  -->
<!--  c3p0 dataSource                                                      -->
<!--  ===================================================================  -->


     < bean  id ="dataSource"  class ="com.mchange.v2.c3p0.ComboPooledDataSource"  destroy-method ="close" >
         < property  name ="driverClass" >
             < value > com.mysql.jdbc.Driver </ value >
         </ property >
         < property  name ="jdbcUrl" >
             < value > jdbc:mysql://localhost:3306/shtest </ value >
         </ property >
         < property  name ="properties" >
             < props >
                 < prop  key ="c3p0.acquire_increment" > 2 </ prop >
                 < prop  key ="c3p0.idle_test_period" > 200 </ prop >
                 < prop  key ="c3p0.timeout" > 1000 </ prop >
                 < prop  key ="c3p0.max_size" > 100 </ prop >
                 < prop  key ="hibernate.c3p0.max_statements" > 100 </ prop >
                 < prop  key ="hibernate.c3p0.min_size" > 20 </ prop >
                 < prop  key ="user" > root </ prop >  
                 < prop  key ="password" > password </ prop >
             </ props >
         </ property >
     </ bean >

    
<!--  ===================================================================  -->
<!--  Hibernate sessionFactory                                             -->
<!--  ===================================================================  -->
    
     < bean  id ="sessionFactory"  class ="org.springframework.orm.hibernate3.LocalSessionFactoryBean"  destroy-method ="close" >
         < property  name ="dataSource" >
             < ref  bean ="dataSource" />
         </ property >
         < property  name ="mappingResources" >
             < list >
                 < value > /com/ergal/hibernate/User.hbm.xml </ value >
             </ list >
         </ property >
         < property  name ="hibernateProperties" >
             < props >
                 < prop  key ="hibernate.dialect" > org.hibernate.dialect.MySQLDialect </ prop >
                 < prop  key ="hibernate.show_sql" > true </ prop >
                 < prop  key ="hibernate.current_session_context_class" > thread </ prop >
             </ props >
         </ property >
     </ bean >
    
<!--  ===================================================================  -->
<!--  Hibernate POJO                                                       -->
<!--  ===================================================================  -->
    
     < bean  id ="userDao"  class ="com.ergal.hibernate.UserDao" >
         < property  name ="sessionFactory" >
             < ref  bean ="sessionFactory" />
         </ property >
     </ bean >

<!--  ===================================================================  -->
<!--  transactionManager                                                   -->
<!--  ===================================================================  -->
    
     < bean  id ="transactionManager"  class ="org.springframework.orm.hibernate3.HibernateTransactionManager" >
         < property  name ="sessionFactory" >
             < ref  bean ="sessionFactory" />
         </ property >
     </ bean >

<!--  ===================================================================  -->
<!--  Dao Proxy                                                            -->
<!--  ===================================================================  -->

     < bean  id ="userDaoProxy"  class ="org.springframework.transaction.interceptor.TransactionProxyFactoryBean" >
         < property  name ="transactionManager" >
             < ref  bean ="transactionManager" />
         </ property >
         < property  name ="proxyInterfaces" >
             < list >
                 < value > com.ergal.hibernate.IUserDao </ value >
             </ list >
         </ property >
         < property  name ="target" >
             < ref  bean ="userDao" />
         </ property >
         < property  name ="transactionAttributes" >
             < props >
                 < prop  key ="insert" > PROPAGATION_REQUIRED </ prop >
             </ props >
         </ property >
    
     </ bean >



</ beans >

 

这么一来在修改数据库连接的部分就变的非常简单 修改后也不用修改除sessionFactory的组装外的其他代码

二 proxool

这个可以通过对hibernateProperties的属性配置来设置

beans-config.xml

     < bean  id ="mySessionFactory"  class ="org.springframework.orm.hibernate.LocalSessionFactoryBean" >
         < property  name ="mappingResources" >
             < list >
                 < value > com/meagle/bo/Order.hbm.xml </ value >
                 < value > com/meagle/bo/OrderLineItem.hbm.xml </ value >                 
             </ list >
         </ property >         
        
         < property  name ="hibernateProperties" >
             < props >
                 < prop  key ="hibernate.dialect" > net.sf.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" > C:/....../WebContent/WEB-INF/proxool.xml </ prop >
                 < prop  key ="hibernate.proxool.pool_alias" > spring </ prop >
             </ props >
         </ property >         
     </ bean >

 

然后单独写一个proxool.xml

 

<? xml version="1.0" encoding="UTF-8" ?>
<!--  the proxool configuration can be embedded within your own application's.
    Anything outside the "proxool" tag is ignored.  -->

< proxool >
     < alias > spring </ alias >
     < driver-url > jdbc:mysql://localhost:3306/shtest </ driver-url >     
     < driver-class > com.mysql.jdbc.Driver </ driver-class >
     < driver-properties >
         < property  name ="user"  value ="root"   />
         < property  name ="password"  value ="password"   />
     </ driver-properties >
     < minimum-connection-count > 2 </ minimum-connection-count >
     < maximum-connection-count > 20 </ maximum-connection-count >
     < maximum-connection-lifetime > 180000 </ maximum-connection-lifetime >   <!--  5 hours  -->
     < house-keeping-test-sql > values(current TimeStamp) </ house-keeping-test-sql >
     < statistics > 1m,15m,1d </ statistics >
     < statistics-log-level > INFO </ statistics-log-level >
     < fatal-sql-exception > Connection is closed,SQLSTATE=08003,Error opening socket. SQLSTATE=08S01,SQLSTATE=08S01 </ fatal-sql-exception >
     < fatal-sql-exception-wrapper-class > org.logicalcobwebs.proxool.FatalRuntimeException </ fatal-sql-exception-wrapper-class >
     < verbose > false </ verbose >
</ proxool >