Package com.iizix.jdbc
Interface IDBConnectionPool
public interface IDBConnectionPool
Interface used to retrieve a connection from a connection pool.
- Author:
- Christopher Mindus
Field Summary
Modifier and TypeFieldDescriptionstatic final int
Flavor for JDBC: DB2.static final int
Flavor for JDBC: Derby.static final int
Flavor for JDBC: MySQL.static final int
Flavor for JDBC: PostgreSQL.static final int
Flavor for JDBC: SQL Server.static final int
Unknown flavor for JDBC Driver.static final String
Property name: class path, comma separated.static final String
Property name: default auto-commit flag.static final String
Property name: description.static final String
Property name: driver class name.static final String
Property name: password.static final String
Property name: JDBC URL.static final String
Property name: user name.Method Summary
Field Details
FLAVOR_UNKNOWN
static final int FLAVOR_UNKNOWNUnknown flavor for JDBC Driver.- See Also:
FLAVOR_DERBY
static final int FLAVOR_DERBYFlavor for JDBC: Derby.- See Also:
FLAVOR_MYSQL
static final int FLAVOR_MYSQLFlavor for JDBC: MySQL.- See Also:
FLAVOR_POSTGRE
static final int FLAVOR_POSTGREFlavor for JDBC: PostgreSQL.- See Also:
FLAVOR_SQLSERVER
static final int FLAVOR_SQLSERVERFlavor for JDBC: SQL Server.- See Also:
FLAVOR_DB2
static final int FLAVOR_DB2Flavor for JDBC: DB2.- See Also:
PN_DESCRIPTION
Property name: description.- See Also:
PN_CLASS_PATH
Property name: class path, comma separated. Specify comma twice for a single comma.- See Also:
PN_DRIVER_CLASS_NAME
Property name: driver class name.- See Also:
PN_URL
Property name: JDBC URL.- See Also:
PN_USER_NAME
Property name: user name.- See Also:
PN_PASSWORD
Property name: password.- See Also:
PN_DEFAULT_AUTO_COMMIT
Property name: default auto-commit flag.- See Also:
Method Details
getConnection
Gets a connection from the pool.- Throws:
SQLException
- For SQL errors.
getFlavor
int getFlavor()Gets the JDBC Driver flavor.- Returns:
- one of the flavors:
FLAVOR_DERBY
,FLAVOR_MYSQL
,FLAVOR_POSTGRE
[not yet supported],FLAVOR_SQLSERVER
[not yet supported],FLAVOR_DB2
[not yet supported].
getName
String getName()Gets the name of the connection pool.- Returns:
- The name of the connection pool.
dispose
Disposes of the pool.Closes and releases all idle connections that are currently stored in the connection pool associated with this data source.
Connections that are checked out to clients when this method is invoked are not affected. When client applications subsequently invoke
Connection.close()
to return these connections to the pool, the underlying JDBC connections are closed.Attempts to acquire connections using
getConnection()
after this method has been invoked result in SQLExceptions.This method is idempotent - i.e., closing an already closed BasicDataSource has no effect and does not generate exceptions.
- Throws:
SQLException
- If an error occurs closing idle connections
isDisposed
boolean isDisposed()Checks if the connection pool is disposed of.- Returns:
- true for disposed of, false if not disposed of and ready.