Spring、Hibernate、Proxool整合配置
主要配置信息在两个文件中，一个XML，一个Properties，并在Web.xml中展示Proxool自带的控制台。
?
?
<?xml version="1.0" encoding="UTF-8"?><beans xmlns="http://www.springframework.org/schema/beans"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p"xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd"><bean id="propertyConfig"value="spring-proxool" /><property name="driver"><value>${jdbc.default.driverClassName}</value></property><property name="driverUrl"><value>${jdbc.default.url}</value></property><property name="user" value="${jdbc.default.username}" /><property name="password" value="${jdbc.default.password}"></property><property name="prototypeCount"><value>5</value></property><property name="maximumConnectionCount" value="${proxool.maximumConnectionCount}" /><property name="minimumConnectionCount" value="${proxool.minimumConnectionCount}" /><property name="houseKeepingTestSql" value="${proxool.houseKeepingTestSql}" /><property name="trace"><value>true</value></property><property name="verbose"><value>true</value></property><!--<property name="driver"> <value>com.mysql.jdbc.Driver</value></property> <property name="driverUrl"><value>jdbc:mysql://localhost:3306/nxjdf?user=root&password=12345</value></property> <property name="user" value="root" /> <propertyname="password" value="12345" />--></bean><bean id="sessionFactory"ref="dataSource" /><property name="mappingResources"><list><!---Hibernate映射文件列表--->?<value>org/migle/persister/model/User.hbm.xml</value></list></property><property name="hibernateProperties"><props><prop key="hibernate.dialect">${hibernate.dialect}</prop><!--根据映射Hibernate映射文件每次启动时创建数据库 --><prop key="hbm2ddl.auto">create</prop><!--<prop key="proxool.pool_alias">spring-proxool</prop> <propkey="connection.provider_class">org.hibernate.connection.ProxoolConnectionProvider</prop>--></props></property></bean></beans>?
migle.properties
?
#######------JDBC---------------------############################ #MySQL jdbc.default.driverClassName=com.mysql.jdbc.Driver jdbc.default.url=jdbc:mysql://localhost/hbm?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false jdbc.default.username=root jdbc.default.password=12345 hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect #Oracle #jdbc.default.driverClassName=oracle.jdbc.driver.OracleDriver #jdbc.default.url=jdbc:oracle:thin:migle/longforfreedom@10.180.85.205:1521:orcl #jdbc.default.username=migle #jdbc.default.password=longforfreedom #hibernate.dialect=org.hibernate.dialect.OracleDialect #PostgreSQL # #jdbc.default.driverClassName=org.postgresql.Driver #jdbc.default.url=jdbc:postgresql://10.180.85.205:5432/DB #jdbc.default.username=postgres #jdbc.default.password=km12345 #hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect ## SQL Server # #jdbc.default.driverClassName=net.sourceforge.jtds.jdbc.Driver #jdbc.default.url=jdbc:jtds:sqlserver://localhost/nxjdf #jdbc.default.username=sa #jdbc.default.password=org.hibernate.dialect.SQLServerDialect #######------proxool---------------------############################proxool.houseKeepingTestSql=select now()proxool.maximumConnectionCount=100proxool.minimumConnectionCount=10?
?
web.xml配置示例
?
<?xml version="1.0" encoding="UTF-8"?><web-app version="2.5" xmlns="http://java.sun.com/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"> <context-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:applicationContext.xml</param-value> </context-param> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <servlet><!---proxool自带的监控--> <description>proxool 监控</description> <display-name>proxool admin</display-name> <servlet-name>proxooladmin</servlet-name> <servlet-class>org.logicalcobwebs.proxool.admin.servlet.AdminServlet</servlet-class> <load-on-startup>0</load-on-startup> </servlet> <servlet-mapping> <servlet-name>proxooladmin</servlet-name> <url-pattern>/admin/proxool</url-pattern> </servlet-mapping> <session-config> <session-timeout>60</session-timeout> </session-config></web-app>?
?
?
1 楼 lyqidao 2010-02-01 我也快学SSH了 一起加油！ 2 楼 longforfreedom 2010-02-13 lyqidao 写道我也快学SSH了 一起加油！