oracle.pg.rdbms

Class OraclePool

java.lang.Object

oracle.pg.rdbms.OraclePool

public class OraclePool
extends Object

This class is a wrapper of OracleDataSource. It provides a pool of Oracle objects to facilitate application development.

Version:

1.0

Author:

Vlad Kolovski

Constructor Summary

Constructors

Constructor and Description
OraclePool(oracle.jdbc.pool.OracleDataSource ods) Constructs an OraclePool instance based on a given OracleDataSource object.
OraclePool(String jdbcURL, String user, String password) This method creates an OraclePool instance based on the given JDBC connection information.
OraclePool(String jdbcURL, String user, String password, Properties connectionCacheProperties) Construct an OraclePool instance using the specified JDBC URL, user, password and connectionCacheProperties and a connection cache name.
OraclePool(String jdbcURL, String user, String password, Properties connectionCacheProperties, String connCacheName) Constructs an OraclePool instance using the specified JDBC URL, user, password and connectionCacheProperties and a connection cache name.

Method Summary

Methods

Modifier and Type	Method and Description
void	close() This method closes the OraclePool object.
oracle.jdbc.OracleConnection	getConnection() Returns an Oracle object from the managed pool.
DataSource	getDataSource() Get the data source associated to this object
void	releaseConnection(oracle.jdbc.OracleConnection conn) Release the given connection by closing the connection and freeing up the resources.

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

OraclePool

public OraclePool(oracle.jdbc.pool.OracleDataSource ods)

Constructs an OraclePool instance based on a given OracleDataSource object.

OraclePool

public OraclePool(String jdbcURL,
          String user,
          String password)

This method creates an OraclePool instance based on the given JDBC connection information.

Parameters:

jdbcURL - the JDBC URL

user - user name to connect to the database

password - password to connect to the database

OraclePool

public OraclePool(String jdbcURL,
          String user,
          String password,
          Properties connectionCacheProperties)

Construct an OraclePool instance using the specified JDBC URL, user, password and connectionCacheProperties and a connection cache name.

Parameters:

jdbcURL - the JDBC URL

user - user name to connect to the database

password - password to connect to the database

connectionCacheProperties - connection cache properties

OraclePool

public OraclePool(String jdbcURL,
          String user,
          String password,
          Properties connectionCacheProperties,
          String connCacheName)

Constructs an OraclePool instance using the specified JDBC URL, user, password and connectionCacheProperties and a connection cache name.

Parameters:

jdbcURL - the JDBC URL

user - user name to connect to the database

password - password to connect to the database

connectionCacheProperties - connection cache properties

connCacheName - connection cache name

Method Detail

close

public void close()

This method closes the OraclePool object.

getConnection

public oracle.jdbc.OracleConnection getConnection()
                                           throws ConnectionSetupException

Returns an Oracle object from the managed pool.

Throws:

ConnectionSetupException

getDataSource

public DataSource getDataSource()

Get the data source associated to this object

Returns:

a DataSource object.

releaseConnection

public void releaseConnection(oracle.jdbc.OracleConnection conn)

Release the given connection by closing the connection and freeing up the resources.

Parameters:

conn - an OracleConnection object