【JDBC】使用OracleDataSource创建连接池用于连接Oracle

来源：这里教程网时间：2026-03-03 16:37:13 作者：

> 本代码参考 网络，整合后 语句，仅用于测试.  初始化5个连接，没关闭，观察orale监听日志及会话、进程相关信息
```
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;
import oracle.jdbc.pool.OracleDataSource;
import oracle.jdbc.pool.OracleConnectionCacheManager;
public class ODBconn {
    public static void main(String[] args) {
	
	       java.util.Properties prop = new java.util.Properties();
           prop.setProperty("ConnectionWaitTimeout", "1");
           prop.setProperty("InactivityTimeout", "20");
           prop.setProperty("MaxStatementsLimit", "90");
           prop.setProperty("MinLimit", "5");
           prop.setProperty("MaxLimit", "10");
           prop.setProperty("InitialLimit", "5");
       //    prop.setProperty("PropertyCheckInterval", "30");
	   
        try{
            OracleDataSource ods = new OracleDataSource();
            			
            ods.setDriverType ( "thin" ); // type of driver
            ods.setNetworkProtocol("tcp"); // tcp is the default anyway
            ods.setServerName ( "192.168.80.116" ); // database server name
            ods.setDatabaseName("mydb"); // Oracle SID
            ods.setPortNumber(1521); // listener port number
            ods.setUser("mytest"); // username
            ods.setPassword("oracle"); // password
            
			ods.setConnectionCachingEnabled(true);
            ods.setConnectionCacheProperties(prop);
        //    ods.setConnectionCacheName("OralceConnectionCache");
         //   OracleConnectionCacheManager cacheManager = OracleConnectionCacheManager.getConnectionCacheManagerInstance();
            Connection conn=ods.getConnection();
            PreparedStatement ps=conn.prepareStatement("select count(*)from v$session where username='MYTEST'");
            ResultSet rs=ps.executeQuery();
            while (rs.next())
            {
                String source = rs.getString(1);
                System.out.println(source);
            }
            System.in.read();
        }
        catch(Exception e)
        {
            System.out.println(e.getMessage());
        }
	}
}
```
#### 参考
- http://www.wfuyu.com/oracle/7029.html
- http://blog.sina.com.cn/s/blog_b7836e390102v8uw.html