各種數(shù)據(jù)源配置之Spring+JPA配置BoneCP數(shù)據(jù)源

so_brave

各種數(shù)據(jù)源配置之Spring+JPA配置BoneCP數(shù)據(jù)源

xml代碼：

1. <?xml version="1.0" encoding="UTF-8"?>
   
2. <beans xmlns="http://www.springframework.org/schema/beans"
   
3.        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   
4.        xmlns:context="http://www.springframework.org/schema/context"
   
5.        xmlns:aop="http://www.springframework.org/schema/aop"
   
6.        xmlns:tx="http://www.springframework.org/schema/tx"
   
7.        xsi:schemaLocation="http://www.springframework.org/schema/beans
   
8.            http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
   
9.            http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd
   
10.            http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
    
11.            http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
    
12.     <aop:aspectj-autoproxy/>
    
13.    
    
14.     <context:component-scan base-package="com.huhui"/><!-- 掃描注解方式 -->
    
15.    
    
16.     <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalEntityManagerFactoryBean">
    
17.     <property name="persistenceUnitName" value="huhui"/>
    
18.     </bean>
    
19.    
    
20.     <!-- 配置事務(wù)管理器 -->
    
21.     <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
    
22.         <property name="entityManagerFactory" ref="entityManagerFactory"/>
    
23.     </bean>
    
24.    
    
25.    <tx:annotation-driven transaction-manager="transactionManager"/>
    
26. </beans>

復(fù)制代碼

web.xml代碼：

1. <context-param>
   
2.     <param-name>contextConfigLocation</param-name>
   
3.     <param-value>classpath:beans.xml</param-value>
   
4. </context-param>

復(fù)制代碼

其它的略

persistence.xml代碼：

1. <?xml version="1.0" encoding="UTF-8"?>
   
2. <persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instanc"
   
3. xsi:schemaLocation="http://java.sun.com/xml/ns/persistence http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd" version="1.0">
   
4. <persistence-unit name="huhui" transaction-type="RESOURCE_LOCAL">
   
5. <provider>org.hibernate.ejb.HibernatePersistence</provider>
   
6. <properties>
   
7. <property name="hibernate.dialect" value="org.hibernate.dialect.MySQL5Dialect"/>
   
8. 
   
9. <property name="hibernate.connection.driver_class" value="org.gjt.mm.mysql.Driver"/>
   
10. <property name="hibernate.connection.username" value="root"/>
    
11. <property name="hibernate.connection.password" value="root"/>
    
12. <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/huhui?useUnicode=true&amp;characterEncoding=UTF-8"/>
    
13. <property name="hibernate.max_fetch_depth" value="3"/>
    
14. <property name="hibernate.hbm2ddl.auto" value="update"/>
    
15. <property name="hibernate.jdbc.fetch_size" value="18"/>
    
16. <property name="hibernate.jdbc.batch_size" value="10"/>
    
17. <property name="hibernate.show_sql" value="false"/>
    
18. <property name="hibernate.format_sql" value="false"/>
    
19. 
    
20. <property name="hibernate.connection.provider_class" value="com.jolbox.bonecp.provider.BoneCPConnectionProvider"/>
    
21. <property name="hibernate.connection.provider_class" value="com.jolbox.bonecp.provider.BoneCPConnectionProvider"/>
    
22. <!-- 設(shè)置連接的空閑存活時(shí)間，默認(rèn)為60，單位：分鐘 -->
    
23. <property name="bonecp.idleMaxAge" value="240"/>
    
24. <!-- 設(shè)置測試connection的間隔時(shí)間。這個(gè)參數(shù)默認(rèn)為240，單位：分鐘 -->
    
25. <property name="bonecp.idleConnectionTestPeriod" value="60"/>
    
26. <!-- 設(shè)置分區(qū)個(gè)數(shù)。這個(gè)參數(shù)默認(rèn)為1，建議3-4（根據(jù)特定應(yīng)用程序而定） -->
    
27. <property name="bonecp.partitionCount" value="3"/>
    
28. <!-- 設(shè)置分區(qū)中的連接增長數(shù)量。這個(gè)參數(shù)默認(rèn)為1 -->
    
29. <property name="bonecp.acquireIncrement" value="10"/>
    
30. <!-- 設(shè)置每個(gè)分區(qū)含有連接最大個(gè)數(shù)。這個(gè)參數(shù)默認(rèn)為2 -->
    
31. <property name="bonecp.maxConnectionsPerPartition" value="300"/>
    
32. <!-- 設(shè)置每個(gè)分區(qū)含有連接最大小個(gè)數(shù)。這個(gè)參數(shù)默認(rèn)為0 -->
    
33. <property name="bonecp.minConnectionsPerPartition" value="20"/>
    
34. <!-- 設(shè)置statement緩存?zhèn)�數(shù)。這個(gè)參數(shù)默認(rèn)為0 -->
    
35. <property name="bonecp.statementsCacheSize" value="50"/>
    
36. <!-- 設(shè)置連接助手線程個(gè)數(shù)。這個(gè)參數(shù)默認(rèn)為3 -->
    
37. <property name="bonecp.releaseHelperThreads" value="3"/> </properties>
    
38. </persistence-unit>
    
39. </persistence>

復(fù)制代碼

配置數(shù)據(jù)源時(shí)，我個(gè)人不喜歡配置多個(gè)數(shù)據(jù)源。以上使用的數(shù)據(jù)源是BoneCP數(shù)據(jù)源，性能比C3P0好，當(dāng)然也不是說不用C3P0了。下次我會(huì)給出C3P0的配置代碼及其Jar包

夢境照進(jìn)現(xiàn)實(shí)

謝謝分享