> 本程式碼參考 網路，整合後 語句，僅用於測試.  初始化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

【JDBC】使用OracleDataSource建立連線池用於連線Oracle

相關文章