java.lang.Object
|
+--stec.sql.ConnectionPoolManager
public final class ConnectionPoolManager
Used to manage access to connection pools. Connection pools can be defined
using the Servertec Internet Server 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
containsConnectionPool
Returns whether the ConnectionPoolManager contains the specified ConnectionPool.
Syntax
public final static boolean containsConnectionPool(String name)
Parameters
|
name
|
the name of the connection pool.
|
Returns
|
boolean
|
whether the ConnectionPoolManager contains the specified ConnectionPool.
|
Throws
Example
boolean found = ConnectionPoolManager.containsConnnectionPool("iob");
createConnectionPool
Creates a new connection pool.
Syntax
public final static void createConnectionPool(String name,
String driver,
String url,
int initSize,
int maxSize)
throws SQLException
public final static void createConnectionPool(String name,
String driver,
String url,
String username,
String password,
int initSize,
int maxSize)
throws SQLException
public final static void createConnectionPool(String name,
String driver,
String url,
Properties info,
int initSize,
int maxSize)
throws SQLException
public final static void createConnectionPool(String name,
String driver,
String url,
int initSize,
int maxSize,
long timeout)
throws SQLException
public final static void createConnectionPool(String name,
String driver,
String url,
String username,
String password,
int initSize,
int maxSize,
long timeout)
throws SQLException
public final static void createConnectionPool(String name,
String driver,
String url,
Properties info,
int initSize,
int maxSize,
long timeout)
throws SQLException
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
|
SQLException
|
if an error occurs.
|
Example
ConnectionPoolManager.createConnectionPool
(
"iob",
"com.ms.jdbc.odbc.JdbcOdbcDriver",
"jdbc:odbc:IOB",
10,
20,
1000L * 60L * 15L
);
destroyConnectionPool
Removes an existing connection pool.
Syntax
public final static void destroyConnectionPool(String name)
Parameters
|
name
|
the name of a connection pool.
|
Returns
Throws
Example
ConnectionPoolManager.destroyConnectionPool("iob");
destroyAllConnectionPools
Removes all existing connection pools.
Syntax
public final static void destroyAllConnectionPools()
Parameters
Returns
Throws
Example
ConnectionPoolManager.destroyAllConnectionPools();
getConnection
Returns a connection from the named connection pool.
Syntax
public final static Connection getConnection(String name)
throws SQLException
Parameters
|
name
|
the name of a connection pool.
|
Returns
|
Connection
|
the connection. null if all connections are in use.
|
Throws
|
SQLException
|
if an error occurs.
|
Example
Connection con = ConnectionPoolManager.getConnection("iob");
getConnectionPools
Returns an enumeration of the connection pools.
Syntax
public final static Enumeration getConnectionPools()
Parameters
Returns
|
Enumeration
|
the enumeration of the connection pools.
|
Throws
Example
Enumeration e = ConnectionPoolManager.getConnnectionPools();
|