bonecp配置数据源

XML配置

<bean id="mainDataSource" class="com.jolbox.bonecp.BoneCPDataSource" destroy-method="close"> 
     <property name="driverClass" value="com.mysql.jdbc.Driver" /> 
     <property name="jdbcUrl" value="jdbc:mysql://192.168.4.89/info_test" /> 
     <property name="username" value="root"/> 
     <property name="password" value="root"/> 
     <property name="idleConnectionTestPeriod" value="60"/> 
     <property name="idleMaxAge" value="180"/>       
     <property name="maxConnectionsPerPartition" value="60"/> 
     <property name="minConnectionsPerPartition" value="20"/> 
    <property name="partitionCount" value="3"/> 
     <property name="acquireIncrement" value="10"/>                               
     <property name="statementsCacheSize" value="50"/> 
     <property name="releaseHelperThreads" value="3"/>
  </bean>

 

 

<bean id="jdbcDataSource" class="org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy"> 
   <property name="targetDataSource"> 
       <ref local="mainDataSource" /> 
   </property> 
  </bean>

 

<bean id="sionFactory"
  class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
  <property name="dataSource">
   <ref bean="jdbcDataSource" />
  </property>
  <property name="hibernateProperties">
   <props>
    <prop key="hibernate.dialect">
     org.hibernate.dialect.Oracle9Dialect
    </prop>
    <prop key="hibernate.show_sql">true</prop>
    <prop key="hibernate.format_sql">true</prop>

   </props>
  </property>
 </bean>

 

<bean id="jdbctransactionManager"
  class="org.springframework.orm.hibernate3.HibernateTransactionManager">
  <property name="sionFactory" ref="sionFactory" />
 </bean>