How to configure the database connection pool of hibernate + proxool

2. Next I will introduce how to useHibernate3.0 how to configure a persistent data layer solutionProxool0.8.3 database connection pool method.
4. 1. SetProxool-0.8.3.jar and the jar files used to connect to the database are included in the classpath or WEB-INF/lib of your project. In this example, the MS sqlserver database is used.
6. 2. In andHibernateCreate a proxoolconf. xml file in the. cfg. xml level directory and add the following file content:
8. <?XML Version="1.0" Encoding="UTF-8"?>
10. <Something-else-entirely>
12. <Proxool>
14. <Alias>Proxoolpool</Alias>
16. <! --ProxoolOnly connections generated by yourself can be managed -->
18. <Driver-URL>JDBC: Microsoft: sqlserver :/// 192.168.0.5: 1433;Databasename=Videopublish</Driver-URL>
20. <Driver-class>Com. Microsoft. JDBC. sqlserver. sqlserverdriver</Driver-class>
22. <Driver-Properties>
24. <Property Name="User" Value="Jdbc_user"/>
26. <Property Name="Password" Value="Memory"/>
28. </Driver-Properties>
30. <! --ProxoolThe time interval (in milliseconds) for automatic reconnaissance of Various connection States. When detecting idle connections, the system immediately recycles them and destroys connections that have timed out. -->
32. <House-keeping-sleep-time>90000</House-keeping-sleep-time>
34. <! -- Indicates the maximum number of requests waiting in the queue because no idle connections can be allocated. User connections exceeding the number of requests will not be accepted. -->
36. <Maximum-New-connections>20</Maximum-New-connections>
38. <! -- Minimum number of idle connections maintained -->
40. <Prototype-count>5</Prototype-count>
42. <! -- The maximum number of connections allowed. If the connection is exceeded, the requests are placed in the queue. the maximum number of waiting requests is determined by maximum-New-connections. -->
44. <Maximum-connection-count>100</Maximum-connection-count>
46. <! -- Minimum connections -->
48. <Minimum-connection-count>10</Minimum-connection-count>
50. </Proxool>
52. </Something-else-entirely>
54. 3. The above isProxoolThe required configuration file is as follows:HibernateThe configuration of the. cfg. xml file is also very simple. The file content is as follows:
56. <?XML Version='1. 0' Encoding='Utf-8'?>
58. <! DoctypeHibernate-Configuration public
60. "-//Hibernate/HibernateConfiguration DTD 3.0 // en"
62. "Http ://Hibernate.Sourceforge.net/Hibernate-Configuration-3.0.dtd">
66. <Hibernate-Configuration>
68. <Session-factory>
70. <Property Name="Proxool. Pool_alias">Proxoolpool</Property>
72. <Property Name="Proxool. Xml">Proxoolconf. xml</Property>
74. <Property Name="Connection. provider_class">Org.Hibernate. Connection. proxoolconnectionprovider</Property>
76. <Property Name="Connection. driver_class">Com. Microsoft. JDBC. sqlserver. sqlserverdriver</Property>
78. <Property Name="Show_ SQL">True</Property>
80. <Mapping Resource="Com/VP/persistent/pojo/users. HBM. xml" />
82. <Mapping Resource="Com/VP/persistent/pojo/videoclasses. HBM. xml" />
84. <Mapping Resource="Com/VP/persistent/pojo/videodiscuss. HBM. xml" />
86. <Mapping Resource="Com/VP/persistent/pojo/videoinfo. HBM. xml" />
88. </Session-factory>
90. </Hibernate-Configuration>
92. 4. The above is the configurationHibernate+ProxoolAs a solution for database connection poolCodeIn this example, a simple test code is provided as follows:
94. <%
96. LongR=0;
98. For (intI=0; I<10000; I ++ ){
100. Try {
102. LongO=NewDate (). gettime ();
104. SessionS=HSF. Currentsession ();
106. UsersU=NewUsers ();
108. U. setusername ("zhanglili ");
110. U. setuseremail ("baidongli@gmail.com ");
112. U. setusernickname ("Bai dongli ");
114. U. setuserpassword ("1234567980123456789 ");
116. U. setusersex ("male ");
118. U. setusersigndate (new date ());
120. TransactionTT=S. Begintransaction ();
122. S. Save (U );
124. TT. Commit ();
126. UsersUser= (Users) S. Get (users. Class, new INTEGER (1 ));
128. // Out. println (user. GetUserName ());
130. LongN=NewDate (). gettime ();
132. R + = n-o;
134. } Catch (exception e ){
136. Out. println (E. getmessage ());
138. } Finally {
140. HSF. closesession ();
142. }
144. }
146. Out. println ("AVG= "+ R/10 );
148. %>
150. 5. Describe how to useProxool, Tomcat JNDI,HibernateAfter the built-in connection pool is configured, the above 10000 data records are inserted and read separately. The result is displayed.ProxoolThe performance is better than that of Tomcat JNDI, andHibernateYou don't need to mention it if it comes with it. The difference is very long. In sequence: 39265 ms/10000, 26013 ms/10000, and 50029 ms/10000.
152. 6.HibernateThere are some solutions for configuring the connection pool, such as c3p0 and Apache DHCP. However, many comments on the Internet show that the performance of c3p0 is much lower under heavy load, apache DHCPHibernateThe author found a performance Bug During the test, so the support for hibernate3.0 has been removed. In contrast,ProxoolIs recommended by everyone. Many mature companies (such as Samsung) UseProxoolAs a solution.