ConnPool.java Source code

Java tutorial

Introduction

Here is the source code for ConnPool.java

Source

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.sql.PooledConnection;

import oracle.jdbc.pool.OracleConnectionPoolDataSource;

public class ConnPool {
    public static void main(String[] args) throws Exception {
        OracleConnectionPoolDataSource ocpds = new OracleConnectionPoolDataSource();
        ocpds.setURL("jdbc:oracle:thin:@localhost:1521:ORCL");
        ocpds.setUser("user");
        ocpds.setPassword("password");

        PooledConnection pc_1 = ocpds.getPooledConnection();

        Connection conn_1 = pc_1.getConnection();
        Statement stmt = conn_1.createStatement();

        ResultSet rs = stmt.executeQuery("SELECT count(*) FROM v$session WHERE username = 'SYS'");
        rs.next();
        String msg = "Total connections after ";
        System.out.println(msg + "conn_1: " + rs.getString(1));

        Connection conn_2 = pc_1.getConnection();
        stmt = conn_2.createStatement();
        rs = stmt.executeQuery("SELECT count(*) FROM v$session WHERE username = 'SYS'");
        rs.next();
        System.out.println(msg + "conn_2: " + rs.getString(1));

        PooledConnection pc_2 = ocpds.getPooledConnection();
        rs = stmt.executeQuery("SELECT count(*) FROM v$session WHERE username = 'SYS'");
        rs.next();
        System.out.println(msg + "pc_2: " + rs.getString(1));

        conn_1.close();
        conn_2.close();
        pc_1.close();
        pc_2.close();
    }
}