java.lang.Object
|
+--stec.sql.ConnectionPoolManager
public class ConnectionPoolManager extends Object
Used to manage access to connection pools. Connection pools can be defined
using the iServer Administrator or created using the ConnectionPoolManager.
This class is a wrapper for java.sql.ConnectionPoolManager. It is
primarily used to return a connection from an existing connection pool.
Methods
createConnectionPool
Creates a new connection pool.
Syntax
public static void createConnectionPool(String name,
String driver,
String url,
int initSize,
int maxSize)
throws Exception
public static void createConnectionPool(String name,
String driver,
String url,
String username,
String password,
int initSize,
int maxSize)
throws Exception
public static void createConnectionPool(String name,
String driver,
String url,
Properties info,
int initSize,
int maxSize)
throws Exception
public static void createConnectionPool(String name,
String driver,
String url,
int initSize,
int maxSize,
long timeout)
throws Exception
public static void createConnectionPool(String name,
String driver,
String url,
String username,
String password,
int initSize,
int maxSize,
long timeout)
throws Exception
public static void createConnectionPool(String name,
String driver,
String url,
Properties info,
int initSize,
int maxSize,
long timeout)
throws Exception
Parameters
name
|
the name of the connection pool.
|
driver
|
the JDBC driver to the database.
|
url
|
the url to the database.
|
username
|
the user's id.
|
password
|
the user's password.
|
info
|
any connection arguments, key/value pairs.
|
initSize
|
the initial number of connections.
|
maxSize
|
the maximum number of connections.
|
timeout
|
the number of milliseconds to keep an inactive connection open in the
connection pool, -1 is the default.
-1 is used for unlimited.
|
Returns
Throws
Exception
|
if an error occurs.
|
Example
ConnectionPoolManager.createConnectionPool
(
"iob",
"sun.jdbc.odbc.JdbcOdbcDriver",
"jdbc:odbc:IOB",
10,
20,
1000L * 60L * 15L
);
destroyConnectionPool
Removes an existing connection pool.
Syntax
public static void destroyConnectionPool(String name)
throws Exception
Parameters
name
|
the name of a connection pool.
|
Returns
Throws
Example
ConnectionPoolManager.destroyConnectionPool("iob");
destroyAllConnectionPools
Removes all existing connection pools.
Syntax
public static void destroyAllConnectionPools() throws Exception
Parameters
Returns
Throws
Example
ConnectionPoolManager.destroyAllConnectionPools();
getConnection
Returns a connection from the named connection pool.
Syntax
public static Connection getConnection(String name)
throws Exception
Parameters
name
|
the name of a connection pool.
|
Returns
Connection
|
the connection. null if all connections are in use.
|
Throws
Exception
|
if an error occurs.
|
Example
Connection con = ConnectionPoolManager.getConnection("iob");
getConnectionPools
Returns an enumeration of the connection pools.
Syntax
public static Enumeration getConnectionPools()
Parameters
Returns
Enumeration
|
the enumeration of the connection pools.
|
Throws
Example
Enumeration e = ConnectionPoolManager.getConnnectionPools();
|