spring配置proxool连接池
本人菜鸟 项目以前用的是 spring+c3p0 现在 要改成 proxool 求指教。。我给所有分 详细点最好能加qq的
在线等
[解决办法]
http://sunnylocus.iteye.com/blog/359570自己看
[解决办法]
1、web.xml中新增：
<!-- proxool启动加载使用 -->
<servlet>
<servlet-name>ServletConfigurator</servlet-name>
<servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
<init-param>
<param-name>xmlFile</param-name>
<param-value>WEB-INF/proxool.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<!-- proxool管理专用 -->
<servlet>
<servlet-name>proxoolAdmin</servlet-name>
<servlet-class>
org.logicalcobwebs.proxool.admin.servlet.AdminServlet
</servlet-class>
</servlet>
<!-- proxool管理专用servlet映射 -->
<servlet-mapping>
<servlet-name>proxoolAdmin</servlet-name>
<url-pattern>/padmin</url-pattern>
</servlet-mapping>
2、将proxool.xml放到WEB-INF下。
3、spring配置datasource.xml中配置：
<bean id="datasource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName">
<value>org.logicalcobwebs.proxool.ProxoolDriver</value>
</property>
<property name="url">
<value>proxool.ptyz-ds</value>
</property>
</bean>
proxool.ptyz-ds即proxool.xml中的<alias>ptyz-ds</alias>
[解决办法]
我也正在用，参考如下：
1. 在web.xml文件中如下书写
<servlet>
<servlet-name>ServletConfigurator</servlet-name>
<servlet-class>org.logicalcobwebs.proxool.configuration.ServletConfigurator</servlet-class>
<init-param>
<param-name>xmlFile</param-name>
<param-value>WEB-INF/classes/proxool.xml</param-value>
</init-param>
<load-on-startup>0</load-on-startup>
</servlet>
2. 拷贝proxool-0.9.1.jar到lib下
3. 拷贝proxool.xml到src下，内容如下（节点属性自己查一下）
<?xml version="1.0" encoding="UTF-8"?>
<something-else-entirely>
<proxool>
<alias>数据库名称（一会在java类用到，现在如AAA）</alias>
<driver-url>jdbc:oracle:thin:@127.0.0.1:1521:orcl</driver-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<driver-properties>
<property name="user" value="用户名" />
<property name="password" value="密码" />
</driver-properties>
<maximum-connection-count>100</maximum-connection-count>
<minimum-connection-count>10</minimum-connection-count>
<house-keeping-sleep-time>90000</house-keeping-sleep-time>
<maximum-new-connections>100</maximum-new-connections>
<prototype-count>5</prototype-count>
<test-before-use>true</test-before-use>
<house-keeping-test-sql>select sysdate from DUAL</house-keeping-test-sql>
</proxool>
</something-else-entirely>
4. java类如下书写
public class JDBCConnection {
public static Connection getConnection() throws Exception {
Class.forName("org.logicalcobwebs.proxool.ProxoolDriver");
try{
Connection connection = DriverManager.getConnection("proxool.AAA");
//关闭自动commit
if(connection.getAutoCommit()){
connection.setAutoCommit(false);
}
return connection;
}catch(Throwable t){
throw new Exception(t);
}
}
public static void close(Connection connection) throws SQLException{
if(connection != null && !connection.isClosed()){
connection.close();
}
}
}
5. 之后怎么用应该知道了吧 connection = JDBCConnection.getConnection()
