proxool的应用

1.如何使用proxool链接多个数据库

1.1配置文件

Proxool.properties配置文件

jdbc-0.proxool.alias=mssql
jdbc-0.proxool.driver-class=com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc-0.proxool.driver-url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test
jdbc-0.user=sa
jdbc-0.password=sa

jdbc-0.proxool.maximum-connection-count=20
jdbc-0.proxool.prototype-count=4

jdbc-0.proxool.house-keeping-test-sql=select getDate()
jdbc-0.proxool.verbose=true
jdbc-0.proxool.statistics=10s,1m,1d
jdbc-0.proxool.statistics-log-level=ERROR

jdbc-1.proxool.alias=mssql2
jdbc-1.proxool.driver-class=com.microsoft.jdbc.sqlserver.SQLServerDriver
jdbc-1.proxool.driver-url=jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test2
jdbc-1.user=sa
jdbc-1.password=sa

jdbc-1.proxool.maximum-connection-count=20
jdbc-1.proxool.prototype-count=4

jdbc-1.proxool.house-keeping-test-sql=select getDate()
jdbc-1.proxool.verbose=true
jdbc-1.proxool.statistics=10s,1m,1d
jdbc-1.proxool.statistics-log-level=ERROR

 1.2使用

 

PropertyConfigurator.configure("Proxool.properties");
//连接数据库test
Connection conn = DriverManager.getConnection("proxool.mssql");
    PreparedStatement pstmt = conn.prepareStatement("SELECT * FROM table");
    pstmt.executeQuery();
    conn.close();


//连接数据库test2
Connection conn = DriverManager.getConnection("proxool.mssql2");
    PreparedStatement pstmt = conn.prepareStatement("SELECT * FROM table");
    pstmt.executeQuery();
    conn.close();