栏目导航
热点推荐
- 三十条有用的 Java 编程规则
- Java制作水印图片源码
- Java常见异常及可能的导致原因
- Java中的修饰词使用方法总结
- J2EE系统异常的处理准则
- Java中的异常、断言、日志解析(
- Java面试技巧:Java面试题集锦(
- 面向Java开发人员的Scala指南:
- Java程序员:一刻钟精通正则表达
- 网友经验分享:学好java开发的关
- 专家解答:创建表格与数据库进行
- Java远程访问Domino数据库
阅览排行
配置Spring的Proxool数据源
www.jz123.cn 2009-10-20 来源: IT专家网 责任编辑(袁袁) 我要投递新闻
另外今天有个同事说Proxool不能配置多个连接池,我经过测试,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" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd"> <bean id="dataSource" class="org.logicalcobwebs.proxool.ProxoolDataSource"> <property name="driver"> <value>oracle.jdbc.driver.OracleDriver</value> </property> <property name="driverUrl"> <value>jdbc:oracle:thin:@192.168.104.192:1521:tim</value> </property> <property name="user" value="tim"/> <property name="password" value="tim_8968888"/> <property name="alias" value="proxool.a2"/> <property name="maximumActiveTime" value="300000"/> <property name="prototypeCount" value="0"/> <property name="maximumConnectionCount" value="50"/> <property name="minimumConnectionCount" value="2"/> <property name="simultaneousBuildThrottle" value="50"/> <property name="houseKeepingTestSql" value="select CURRENT_DATE"/> </bean> <bean id="dataSource2" class="org.logicalcobwebs.proxool.ProxoolDataSource"> <property name="driver"> <value>oracle.jdbc.driver.OracleDriver</value> </property> <property name="driverUrl"> <value>jdbc:oracle:thin:@192.168.104.164:1521:orcl</value> </property> <property name="user" value="rural"/> <property name="password" value="rural"/> <property name="alias" value="proxool.a1"/> <property name="maximumActiveTime" value="300000"/> <property name="prototypeCount" value="0"/> <property name="maximumConnectionCount" value="50"/> <property name="minimumConnectionCount" value="2"/> <property name="simultaneousBuildThrottle" value="50"/> <property name="houseKeepingTestSql" value="select CURRENT_DATE"/> </bean> </beans> |
另外,进行极刑的变态测试,代码***,目的是为了将程序高挂,可惜没挂,呵呵!
import org.springframework.context.ApplicationContext; import javax.sql.DataSource; import java.sql.Connection; import java.sql.SQLException; import java.sql.Statement; import java.sql.ResultSet; /** * Created by IntelliJ IDEA. * * @author leizhimin 2009-10-15 17:39:50 */ public class Test { public static void main(String[] args) throws SQLException { ApplicationContext ctx = ApplicationContextUtil.getApplicationContext(); DataSource ds1 = (DataSource)ctx.getBean("dataSource"); DataSource ds2 = (DataSource)ctx.getBean("dataSource2"); Connection conn1 = ds1.getConnection(); Connection conn2 = ds2.getConnection(); Statement stmt = conn1.createStatement(); //4:执行SQL,并获取返回结果 ResultSet rs = stmt.executeQuery("select * from city"); //5:处理返回结果,此处打印查询结果 while (rs.next()) { System.out.print(rs.getLong("id") + "t"); System.out.print(rs.getString("name") + "t"); System.out.println(); Statement stmt2 = conn2.createStatement(); //4:执行SQL,并获取返回结果 // ResultSet rs2 = stmt2.executeQuery("select * from city"); ResultSet rs2 = stmt2.executeQuery("select * from lm where lm_id = "+rs.getLong("id")); //5:处理返回结果,此处打印查询结果 while (rs2.next()) { System.out.println(rs2.getLong(1)); } System.out.println("<<<<"); //6:关闭数据库连接 } //6:关闭数据库连接 conn1.close(); conn2.close(); // System.out.println("----------"); // // Statement stmt2 = conn2.createStatement(); // //4:执行SQL,并获取返回结果 // ResultSet rs2 = stmt2.executeQuery("select count(*) from lm"); // //5:处理返回结果,此处打印查询结果 // while (rs2.next()) { // System.out.println(rs2.getLong(1)); // } // //6:关闭数据库连接 // conn2.close(); } } |
输出如下:
2009-10-15 18:25:37 - INFO org.springframework.core.CollectionFactory - JDK 1.4+ collections available 2009-10-15 18:25:37 - INFO org.springframework.beans.factory.xml.XmlBeanDefinitionReader - Loading XML bean definitions from class path resource [syndsconfig.xml] 2009-10-15 18:25:37 - INFO org.springframework.context.support.ClassPathXmlApplicationContext - Bean factory for application context [org.springframework.context.support.ClassPathXmlApplicationContext;hashCode=6161922]: org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,dataSource2]; root of BeanFactory hierarchy 2009-10-15 18:25:37 - INFO org.springframework.context.support.ClassPathXmlApplicationContext - 2 beans defined in application context [org.springframework.context.support.ClassPathXmlApplicationContext;hashCode=6161922] 2009-10-15 18:25:37 - INFO org.springframework.context.support.ClassPathXmlApplicationContext - Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@18dfef8] 2009-10-15 18:25:37 - INFO org.springframework.context.support.ClassPathXmlApplicationContext - Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@134bed0] 2009-10-15 18:25:37 - INFO org.springframework.beans.factory.support.DefaultListableBeanFactory - Pre-instantiating singletons in factory [org.springframework.beans.factory.support.DefaultListableBeanFactory defining beans [dataSource,dataSource2]; root of BeanFactory hierarchy] 410100 郑州市 <<<< 410200 开封市 <<<< 410300 洛阳市 <<<< 410400 平顶山市 <<<< 410500 安阳市 <<<< 410600 鹤壁市 <<<< 410700 新乡市 <<<< 410800 焦作市 <<<< 410881 济源市 <<<< 410900 濮阳市 <<<< 411000 许昌市 <<<< 411100 漯河市 <<<< 411200 三门峡市 <<<< 411300 南阳市 <<<< 411400 商丘市 <<<< 411500 信阳市 <<<< 411600 周口市 <<<< 411700 驻马店市 <<<< 2009-10-15 18:25:39 - INFO org.logicalcobwebs.proxool.proxool.a2 - Shutting down 'proxool.a2' pool immediately [Shutdown Hook] 2009-10-15 18:25:39 - INFO org.logicalcobwebs.proxool.proxool.a1 - Shutting down 'proxool.a1' pool immediately [Shutdown Hook] 2009-10-15 18:25:39 - INFO org.logicalcobwebs.proxool.PrototyperController - Stopping Prototyper thread 2009-10-15 18:25:39 - INFO org.logicalcobwebs.proxool.HouseKeeperController - Stopping HouseKeeper thread Process finished with exit code 0 |
如果大家想看Web应用的例子,可以参看:
http://blog.csdn.net/goodhumor/archive/2008/03/04/2144911.aspx
本文出自 “熔 岩” 博客 http://lavasoft.blog.51cto.com/62575/212616
0
上一篇:Java 设计模式之 观察者模式(Observer) 下一篇:基础编程:Java快速排序实例详解