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();