使用ORACLE UCP

ORACLE UCP是指Universal Connecti了n Pool for JDBC，其实说白了就是ORACLE实现了一个数据库连接池，类似阿帕奇的commons-pool，使用这个东西可以提高JDBC程序的性能，并且不受应用服务器限制。

使用UCP需要：

• JDK 1.6
• Oracle JDBC thin driver supporting JDK 1.6
• Oracle Universal Connection Pool library

以下是一段样例代码，链接的ORACLE数据库中自带的HR用户。

import java.sql.*;
import oracle.ucp.jdbc.PoolDataSourceFactory;
import oracle.ucp.jdbc.PoolDataSource;

public class UcpConnection {
public static void main(String args[]) throws SQLException {
 try
 {
  //Creating a pool-enabled data source
  PoolDataSource pds = PoolDataSourceFactory.getPoolDataSource();
  //Setting connection properties of the data source
  pds.setConnectionFactoryClassName("oracle.jdbc.pool.OracleDataSource");
  pds.setURL("jdbc:oracle:thin:@//localhost:1521/XE");
  pds.setUser("hr");
  pds.setPassword("hr");
  //Setting pool properties
  pds.setInitialPoolSize(5);
  pds.setMinPoolSize(5);
  pds.setMaxPoolSize(10);
  //Borrowing a connection from the pool
  Connection conn = pds.getConnection();
  System.out.println("\nConnection borrowed from the pool");
  //Checking the number of available and borrowed connections
  int avlConnCount = pds.getAvailableConnectionsCount();
  System.out.println("\nAvailable connections: " + avlConnCount);
  int brwConnCount = pds.getBorrowedConnectionsCount();
  System.out.println("\nBorrowed connections: " + brwConnCount);
  //Working with the connection
  Statement stmt = conn.createStatement();
  ResultSet rs = stmt.executeQuery("select user from dual");
  while(rs.next())
   System.out.println("\nConnected as: "+rs.getString(1));
  rs.close();
  //Returning the connection to the pool
  conn.close();
  conn=null;
  System.out.println("\nConnection returned to the pool");
  //Checking the number of available and borrowed connections again
  avlConnCount = pds.getAvailableConnectionsCount();
  System.out.println("\nAvailable connections: " + avlConnCount);
  brwConnCount = pds.getBorrowedConnectionsCount();
  System.out.println("\nBorrowed connections: " + brwConnCount);
 }
 catch(SQLException e)
 {
  System.out.println("\nAn SQL exception occurred : " + e.getMessage());
 }
}

UCP的配置可以参考UCP的手册，其他的用法，这篇文章里就不详细说明了，OTN上有文章讲的很详细，想看的话，点击这里。
}