public class ConnectionPool extends NotificationBroadcasterSupport implements ConnectionPoolMBean
Modifier and Type | Field and Description |
---|---|
static String |
FAILED_QUERY_NOTIFICATION |
protected ConcurrentLinkedQueue<NotificationListener> |
listeners
Listeners that are local and interested in our notifications, no need for JMX
|
static String |
NOTIFY_ABANDON |
static String |
NOTIFY_CONNECT |
static String |
NOTIFY_INIT |
protected ConnectionPool |
pool
the connection pool
|
static String |
POOL_EMPTY |
protected AtomicInteger |
sequence
sequence for JMX notifications
|
static String |
SLOW_QUERY_NOTIFICATION |
static String |
SUSPECT_ABANDONED_NOTIFICATION |
static String |
SUSPECT_RETURNED_NOTIFICATION |
PKG_PREFIX
Constructor and Description |
---|
ConnectionPool(ConnectionPool pool) |
Modifier and Type | Method and Description |
---|---|
void |
addListener(NotificationListener list) |
void |
checkAbandoned() |
void |
checkIdle() |
int |
getAbandonWhenPercentageFull()
Connections that have been abandoned (timed out) wont get closed and reported up unless the number of connections in use are
above the percentage defined by abandonWhenPercentageFull.
|
int |
getActive() |
long |
getBorrowedCount() |
boolean |
getCommitOnReturn() |
String |
getConnectionProperties()
The connection properties that will be sent to the JDBC driver when establishing new connections.
|
long |
getCreatedCount() |
Object |
getDataSource()
Returns a datasource, if one exists that is being used to create connections.
|
String |
getDataSourceJNDI()
Returns the JNDI string configured for data source usage.
|
Properties |
getDbProperties()
Returns the database properties that are passed into the
Driver.connect(String, Properties) method. |
Boolean |
getDefaultAutoCommit()
The default auto-commit state of connections created by this pool.
|
String |
getDefaultCatalog()
If non null, during connection creation the method
Connection.setCatalog(String) will be called with the set value. |
static MBeanNotificationInfo[] |
getDefaultNotificationInfo() |
Boolean |
getDefaultReadOnly()
If non null, during connection creation the method
Connection.setReadOnly(boolean) will be called with the set value. |
int |
getDefaultTransactionIsolation()
Returns the default transaction isolation level.
|
String |
getDriverClassName()
The fully qualified Java class name of the JDBC driver to be used.
|
int |
getIdle() |
int |
getInitialSize()
Returns the number of connections that will be established when the connection pool is started.
|
String |
getInitSQL()
A custom query to be run when a connection is first created.
|
String |
getJdbcInterceptors()
A semicolon separated list of classnames extending
JdbcInterceptor class. |
PoolProperties.InterceptorDefinition[] |
getJdbcInterceptorsAsArray()
Returns the
PoolConfiguration.getJdbcInterceptors() as an array of objects with properties and the classes. |
boolean |
getLogValidationErrors()
Returns true if errors that happen during validation will be logged
|
int |
getMaxActive()
The maximum number of active connections that can be allocated from this pool at the same time.
|
long |
getMaxAge()
Time in milliseconds to keep this connection before reconnecting.
|
int |
getMaxIdle()
The maximum number of connections that should be kept in the idle pool if
PoolConfiguration.isPoolSweeperEnabled() returns false. |
int |
getMaxWait()
The maximum number of milliseconds that the pool will wait (when there are no available connections and the
PoolConfiguration.getMaxActive() has been reached) for a connection to be returned
before throwing an exception. |
int |
getMinEvictableIdleTimeMillis()
The minimum amount of time an object must sit idle in the pool before it is eligible for eviction.
|
int |
getMinIdle()
The minimum number of established connections that should be kept in the pool at all times.
|
String |
getName()
Returns the name of the connection pool.
|
MBeanNotificationInfo[] |
getNotificationInfo() |
int |
getNumActive() |
int |
getNumIdle() |
int |
getNumTestsPerEvictionRun()
Property not used
|
String |
getPassword()
Returns the password used when establishing connections to the database.
|
ConnectionPool |
getPool() |
String |
getPoolName() |
PoolConfiguration |
getPoolProperties() |
boolean |
getPropagateInterruptState()
Returns true if the pool is configured to propagate interrupt state of a thread.
|
long |
getReconnectedCount() |
long |
getReleasedCount() |
long |
getReleasedIdleCount() |
long |
getRemoveAbandonedCount() |
int |
getRemoveAbandonedTimeout()
The time in seconds before a connection can be considered abandoned.
|
long |
getReturnedCount() |
boolean |
getRollbackOnReturn() |
int |
getSize() |
int |
getSuspectTimeout()
Returns the time in seconds to pass before a connection is marked an abandoned suspect.
|
int |
getTimeBetweenEvictionRunsMillis()
The number of milliseconds to sleep between runs of the idle connection validation, abandoned cleaner
and idle pool resizing.
|
String |
getUrl()
The URL used to connect to the database
|
boolean |
getUseDisposableConnectionFacade()
Returns
true if this connection pool is configured to use a connection facade to prevent re-use of connection after
Connection.close() has been invoked |
boolean |
getUseLock()
Return true if a lock should be used when operations are performed on the connection object.
|
String |
getUsername()
Returns the username used to establish the connection with
|
boolean |
getUseStatementFacade()
Returns
true if this connection pool is configured to wrap statements in order
to enable equals() and hashCode() methods to be called on the closed statements if any
statement proxy is set. |
long |
getValidationInterval()
avoid excess validation, only run validation at most at this frequency - time in milliseconds.
|
String |
getValidationQuery()
The SQL query that will be used to validate connections from this
pool before returning them to the caller or pool.
|
int |
getValidationQueryTimeout()
The timeout in seconds before a connection validation queries fail.
|
Validator |
getValidator() |
String |
getValidatorClassName()
Return the name of the optional validator class - may be null.
|
int |
getWaitCount() |
boolean |
isAccessToUnderlyingConnectionAllowed()
Property not used.
|
boolean |
isAlternateUsernameAllowed()
Returns true if the call
getConnection(username,password) is
allowed. |
Boolean |
isDefaultAutoCommit()
The default auto-commit state of connections created by this pool.
|
Boolean |
isDefaultReadOnly()
If non null, during connection creation the method
Connection.setReadOnly(boolean) will be called with the set value. |
boolean |
isFairQueue()
Returns
true if a fair queue is being used by the connection pool |
boolean |
isIgnoreExceptionOnPreLoad() |
boolean |
isJmxEnabled()
If set to true, the connection pool creates a
ConnectionPoolMBean object
that can be registered with JMX to receive notifications and state about the pool. |
boolean |
isLogAbandoned()
boolean flag to set if stack traces should be logged for application code which abandoned a Connection.
|
boolean |
isPoolSweeperEnabled()
Returns true if the pool sweeper is enabled for the connection pool.
|
boolean |
isRemoveAbandoned()
boolean flag to remove abandoned connections if they exceed the removeAbandonedTimeout.
|
boolean |
isTestOnBorrow()
The indication of whether objects will be validated before being borrowed from the pool.
|
boolean |
isTestOnConnect()
Returns true if we should run the validation query when connecting to the database for the first time on a connection.
|
boolean |
isTestOnReturn()
The indication of whether objects will be validated after being returned to the pool.
|
boolean |
isTestWhileIdle()
Set to true if query validation should take place while the connection is idle.
|
boolean |
isUseEquals()
Set to true if you wish the
ProxyConnection class to use String.equals instead of
== when comparing method names. |
boolean |
notify(String type,
String message)
Return true if the notification was sent successfully, false otherwise.
|
void |
purge()
Purges all connections in the pool.
|
void |
purgeOnReturn()
Purges connections when they are returned from the pool.
|
boolean |
removeListener(NotificationListener list) |
void |
resetStats()
reset the statistics of this pool.
|
void |
setAbandonWhenPercentageFull(int percentage)
Connections that have been abandoned (timed out) wont get closed and reported up unless the number of connections in use are
above the percentage defined by abandonWhenPercentageFull.
|
void |
setAccessToUnderlyingConnectionAllowed(boolean accessToUnderlyingConnectionAllowed)
No-op
|
void |
setAlternateUsernameAllowed(boolean alternateUsernameAllowed)
Set to true if the call
getConnection(username,password) is
allowed and honored.. |
void |
setCommitOnReturn(boolean commitOnReturn)
Set to true if you want the connection pool to commit any pending transaction when a connection is returned.
|
void |
setConnectionProperties(String connectionProperties)
The properties that will be passed into
Driver.connect(String, Properties) method. |
void |
setDataSource(Object ds)
Injects a datasource that will be used to retrieve/create connections.
|
void |
setDataSourceJNDI(String jndiDS)
Configure the connection pool to use a DataSource according to
PoolConfiguration.setDataSource(Object)
But instead of injecting the object, specify the JNDI location. |
void |
setDbProperties(Properties dbProperties)
Overrides the database properties passed into the
Driver.connect(String, Properties) method. |
void |
setDefaultAutoCommit(Boolean defaultAutoCommit)
The default auto-commit state of connections created by this pool.
|
void |
setDefaultCatalog(String defaultCatalog)
If non null, during connection creation the method
Connection.setCatalog(String) will be called with the set value. |
void |
setDefaultReadOnly(Boolean defaultReadOnly)
If non null, during connection creation the method
Connection.setReadOnly(boolean) will be called with the set value. |
void |
setDefaultTransactionIsolation(int defaultTransactionIsolation)
If set to
DataSourceFactory.UNKNOWN_TRANSACTIONISOLATION the method
Connection.setTransactionIsolation(int) will not be called during connection creation. |
void |
setDriverClassName(String driverClassName)
The fully qualified Java class name of the JDBC driver to be used.
|
void |
setFairQueue(boolean fairQueue)
Set to true if you wish that calls to getConnection
should be treated fairly in a true FIFO fashion.
|
void |
setIgnoreExceptionOnPreLoad(boolean ignoreExceptionOnPreLoad)
Set to true if you want to ignore error of connection creation while initializing the pool.
|
void |
setInitialSize(int initialSize)
Set the number of connections that will be established when the connection pool is started.
|
void |
setInitSQL(String initSQL)
A custom query to be run when a connection is first created.
|
void |
setJdbcInterceptors(String jdbcInterceptors)
A semicolon separated list of classnames extending
JdbcInterceptor class. |
void |
setJmxEnabled(boolean jmxEnabled)
If set to true, the connection pool creates a
ConnectionPoolMBean object
that can be registered with JMX to receive notifications and state about the pool. |
void |
setLogAbandoned(boolean logAbandoned)
boolean flag to set if stack traces should be logged for application code which abandoned a Connection.
|
void |
setLogValidationErrors(boolean logValidationErrors)
Set to true if you wish that errors from validation should be logged as error messages.
|
void |
setMaxActive(int maxActive)
The maximum number of active connections that can be allocated from this pool at the same time.
|
void |
setMaxAge(long maxAge)
Time in milliseconds to keep this connection before reconnecting.
|
void |
setMaxIdle(int maxIdle)
The maximum number of connections that should be kept in the idle pool if
PoolConfiguration.isPoolSweeperEnabled() returns false. |
void |
setMaxWait(int maxWait)
The maximum number of milliseconds that the pool will wait (when there are no available connections and the
PoolConfiguration.getMaxActive() has been reached) for a connection to be returned
before throwing an exception. |
void |
setMinEvictableIdleTimeMillis(int minEvictableIdleTimeMillis)
The minimum amount of time an object must sit idle in the pool before it is eligible for eviction.
|
void |
setMinIdle(int minIdle)
The minimum number of established connections that should be kept in the pool at all times.
|
void |
setName(String name)
Sets the name of the connection pool
|
void |
setNumTestsPerEvictionRun(int numTestsPerEvictionRun)
Property not used
|
void |
setPassword(String password)
Sets the password to establish the connection with.
|
void |
setPropagateInterruptState(boolean propagateInterruptState)
Configure the pool to propagate interrupt state for interrupted threads waiting for a connection
A thread waiting for a connection, can have its wait interrupted, and by default
will clear the interrupt flag and throw a
PoolExhaustedException
If set to true, this behavior will change, while the PoolExhaustedException is still thrown, the threads interrupted state is still set. |
void |
setRemoveAbandoned(boolean removeAbandoned)
boolean flag to remove abandoned connections if they exceed the removeAbandonedTimeout.
|
void |
setRemoveAbandonedTimeout(int removeAbandonedTimeout)
The time in seconds before a connection can be considered abandoned.
|
void |
setRollbackOnReturn(boolean rollbackOnReturn)
Set to true if you want the connection pool to rollback any pending transaction when a connection is returned.
|
void |
setSuspectTimeout(int seconds)
Similar to
PoolConfiguration.setRemoveAbandonedTimeout(int) but instead of treating the connection
as abandoned, and potentially closing the connection, this simply logs the warning if
PoolConfiguration.isLogAbandoned() returns true. |
void |
setTestOnBorrow(boolean testOnBorrow)
The indication of whether objects will be validated before being borrowed from the pool.
|
void |
setTestOnConnect(boolean testOnConnect)
Set to true if we should run the validation query when connecting to the database for the first time on a connection.
|
void |
setTestOnReturn(boolean testOnReturn)
The indication of whether objects will be validated after being returned to the pool.
|
void |
setTestWhileIdle(boolean testWhileIdle)
Set to true if query validation should take place while the connection is idle.
|
void |
setTimeBetweenEvictionRunsMillis(int timeBetweenEvictionRunsMillis)
The number of milliseconds to sleep between runs of the idle connection validation, abandoned cleaner
and idle pool resizing.
|
void |
setUrl(String url)
Sets the URL used to connect to the database
|
void |
setUseDisposableConnectionFacade(boolean useDisposableConnectionFacade)
If set to
true , the connection will be wrapped with facade that will disallow the connection to be used after
Connection.close() is called. |
void |
setUseEquals(boolean useEquals)
Set to true if you wish the
ProxyConnection class to use String.equals instead of
== when comparing method names. |
void |
setUseLock(boolean useLock)
Set to true if a lock should be used when operations are performed on the connection object.
|
void |
setUsername(String username)
Sets the username used to establish the connection with
It will also be a property called 'user' in the database properties.
|
void |
setUseStatementFacade(boolean useStatementFacade)
Set this to true if you wish to wrap statements in order to enable equals() and hashCode()
methods to be called on the closed statements if any statement proxy is set.
|
void |
setValidationInterval(long validationInterval)
avoid excess validation, only run validation at most at this frequency - time in milliseconds.
|
void |
setValidationQuery(String validationQuery)
The SQL query that will be used to validate connections from this
pool before returning them to the caller or pool.
|
void |
setValidationQueryTimeout(int validationQueryTimeout)
The timeout in seconds before a connection validation queries fail.
|
void |
setValidator(Validator validator)
Sets the validator object
If this is a non null object, it will be used as a validator instead of the validationQuery
If this is null, remove the usage of the validator.
|
void |
setValidatorClassName(String className)
Set the name for an optional validator class which will be used in place of test queries.
|
void |
testIdle() |
addNotificationListener, handleNotification, removeNotificationListener, removeNotificationListener, sendNotification
protected ConnectionPool pool
protected AtomicInteger sequence
protected ConcurrentLinkedQueue<NotificationListener> listeners
public static final String NOTIFY_INIT
public static final String NOTIFY_CONNECT
public static final String NOTIFY_ABANDON
public static final String SLOW_QUERY_NOTIFICATION
public static final String FAILED_QUERY_NOTIFICATION
public static final String SUSPECT_ABANDONED_NOTIFICATION
public static final String POOL_EMPTY
public static final String SUSPECT_RETURNED_NOTIFICATION
public ConnectionPool(ConnectionPool pool)
public ConnectionPool getPool()
public PoolConfiguration getPoolProperties()
public MBeanNotificationInfo[] getNotificationInfo()
getNotificationInfo
in interface NotificationBroadcaster
getNotificationInfo
in class NotificationBroadcasterSupport
public static MBeanNotificationInfo[] getDefaultNotificationInfo()
public boolean notify(String type, String message)
type
- message
- public void addListener(NotificationListener list)
public boolean removeListener(NotificationListener list)
public int getSize()
getSize
in interface ConnectionPoolMBean
public int getIdle()
getIdle
in interface ConnectionPoolMBean
public int getActive()
getActive
in interface ConnectionPoolMBean
public int getNumIdle()
getNumIdle
in interface ConnectionPoolMBean
public int getNumActive()
getNumActive
in interface ConnectionPoolMBean
public int getWaitCount()
getWaitCount
in interface ConnectionPoolMBean
public long getBorrowedCount()
getBorrowedCount
in interface ConnectionPoolMBean
public long getReturnedCount()
getReturnedCount
in interface ConnectionPoolMBean
public long getCreatedCount()
getCreatedCount
in interface ConnectionPoolMBean
public long getReleasedCount()
getReleasedCount
in interface ConnectionPoolMBean
public long getReconnectedCount()
getReconnectedCount
in interface ConnectionPoolMBean
public long getRemoveAbandonedCount()
getRemoveAbandonedCount
in interface ConnectionPoolMBean
public long getReleasedIdleCount()
getReleasedIdleCount
in interface ConnectionPoolMBean
public void checkIdle()
checkIdle
in interface ConnectionPoolMBean
public void checkAbandoned()
checkAbandoned
in interface ConnectionPoolMBean
public void testIdle()
testIdle
in interface ConnectionPoolMBean
public void resetStats()
ConnectionPoolMBean
resetStats
in interface ConnectionPoolMBean
public String getConnectionProperties()
PoolConfiguration
getConnectionProperties
in interface PoolConfiguration
public Properties getDbProperties()
PoolConfiguration
Driver.connect(String, Properties)
method.getDbProperties
in interface PoolConfiguration
Driver.connect(String, Properties)
method.public String getDefaultCatalog()
PoolConfiguration
Connection.setCatalog(String)
will be called with the set value.getDefaultCatalog
in interface PoolConfiguration
public int getDefaultTransactionIsolation()
PoolConfiguration
DataSourceFactory.UNKNOWN_TRANSACTIONISOLATION
the method
Connection.setTransactionIsolation(int)
will not be called during connection creation.getDefaultTransactionIsolation
in interface PoolConfiguration
DataSourceFactory.UNKNOWN_TRANSACTIONISOLATION
if not set.public String getDriverClassName()
PoolConfiguration
getDriverClassName
in interface PoolConfiguration
public int getInitialSize()
PoolConfiguration
getInitialSize
in interface PoolConfiguration
public String getInitSQL()
PoolConfiguration
getInitSQL
in interface PoolConfiguration
public String getJdbcInterceptors()
PoolConfiguration
JdbcInterceptor
class.
These interceptors will be inserted as an interceptor into the chain of operations on a java.sql.Connection object.
Example interceptors are StatementFinalizer
to close all
used statements during the session.
ResetAbandonedTimer
resets the timer upon every operation
on the connection or a statement.
ConnectionState
caches the auto commit, read only and catalog settings to avoid round trips to the DB.
The default value is null.getJdbcInterceptors
in interface PoolConfiguration
public int getMaxActive()
PoolConfiguration
getMaxActive
in interface PoolConfiguration
public int getMaxIdle()
PoolConfiguration
PoolConfiguration.isPoolSweeperEnabled()
returns false.
If the If PoolConfiguration.isPoolSweeperEnabled()
returns true, then the idle pool can grow up to PoolConfiguration.getMaxActive()
and will be shrunk according to PoolConfiguration.getMinEvictableIdleTimeMillis()
setting.
Default value is maxActive:100getMaxIdle
in interface PoolConfiguration
public int getMaxWait()
PoolConfiguration
PoolConfiguration.getMaxActive()
has been reached) for a connection to be returned
before throwing an exception. Default value is 30000 (30 seconds)getMaxWait
in interface PoolConfiguration
public int getMinEvictableIdleTimeMillis()
PoolConfiguration
getMinEvictableIdleTimeMillis
in interface PoolConfiguration
public int getMinIdle()
PoolConfiguration
PoolConfiguration.getInitialSize()
(also see PoolConfiguration.setTestWhileIdle(boolean)
The idle pool will not shrink below this value during an eviction run, hence the number of actual connections
can be between PoolConfiguration.getMinIdle()
and somewhere between PoolConfiguration.getMaxIdle()
and PoolConfiguration.getMaxActive()
getMinIdle
in interface PoolConfiguration
public long getMaxAge()
PoolConfiguration
PoolConfiguration.getTimeBetweenEvictionRunsMillis()
returns a value greater than 0.
The default value is 0, which implies that connections will be left open and no
age checks will be done.
This is a useful setting for database sessions that leak memory as it ensures that the session
will have a finite life span.getMaxAge
in interface PoolConfiguration
public String getName()
PoolConfiguration
getName
in interface PoolConfiguration
public int getNumTestsPerEvictionRun()
PoolConfiguration
getNumTestsPerEvictionRun
in interface PoolConfiguration
public String getPassword()
PoolConfiguration
getPassword
in interface PoolConfiguration
public int getRemoveAbandonedTimeout()
PoolConfiguration
getRemoveAbandonedTimeout
in interface PoolConfiguration
ResetAbandonedTimer
public int getTimeBetweenEvictionRunsMillis()
PoolConfiguration
getTimeBetweenEvictionRunsMillis
in interface PoolConfiguration
public String getUrl()
PoolConfiguration
getUrl
in interface PoolConfiguration
Driver.connect(String, Properties)
public String getUsername()
PoolConfiguration
getUsername
in interface PoolConfiguration
public long getValidationInterval()
PoolConfiguration
getValidationInterval
in interface PoolConfiguration
public String getValidationQuery()
PoolConfiguration
getValidationQuery
in interface PoolConfiguration
public int getValidationQueryTimeout()
PoolConfiguration
getValidationQueryTimeout
in interface PoolConfiguration
public String getValidatorClassName()
getValidatorClassName
in interface PoolConfiguration
public Validator getValidator()
getValidator
in interface PoolConfiguration
public boolean isAccessToUnderlyingConnectionAllowed()
PoolConfiguration
DataSource
interface
or call getConnection through reflection or cast the object as PooledConnection
isAccessToUnderlyingConnectionAllowed
in interface PoolConfiguration
true
public Boolean isDefaultAutoCommit()
PoolConfiguration
Connection.setAutoCommit(boolean)
method will not be called.)isDefaultAutoCommit
in interface PoolConfiguration
public Boolean isDefaultReadOnly()
PoolConfiguration
Connection.setReadOnly(boolean)
will be called with the set value.isDefaultReadOnly
in interface PoolConfiguration
public boolean isLogAbandoned()
PoolConfiguration
isLogAbandoned
in interface PoolConfiguration
public boolean isPoolSweeperEnabled()
PoolConfiguration
boolean result = getTimeBetweenEvictionRunsMillis()>0;
result = result && (isRemoveAbandoned() && getRemoveAbandonedTimeout()>0);
result = result || (isTestWhileIdle() && getValidationQuery()!=null);
return result;
isPoolSweeperEnabled
in interface PoolConfiguration
public boolean isRemoveAbandoned()
PoolConfiguration
PoolConfiguration.getRemoveAbandonedTimeout()
and the condition for
PoolConfiguration.getAbandonWhenPercentageFull()
is met.
Setting this to true can recover db connections from applications that fail to close a connection.
See also PoolConfiguration.isLogAbandoned()
The default value is false.isRemoveAbandoned
in interface PoolConfiguration
public int getAbandonWhenPercentageFull()
PoolConfiguration
getAbandonWhenPercentageFull
in interface PoolConfiguration
public boolean isTestOnBorrow()
PoolConfiguration
PoolConfiguration.setValidationInterval(long)
isTestOnBorrow
in interface PoolConfiguration
PoolConfiguration.getValidationInterval()
public boolean isTestOnConnect()
PoolConfiguration
isTestOnConnect
in interface PoolConfiguration
public boolean isTestOnReturn()
PoolConfiguration
PoolConfiguration.setValidationInterval(long)
isTestOnReturn
in interface PoolConfiguration
PoolConfiguration.getValidationInterval()
public boolean isTestWhileIdle()
PoolConfiguration
isTestWhileIdle
in interface PoolConfiguration
PoolConfiguration.setTimeBetweenEvictionRunsMillis(int)
public Boolean getDefaultAutoCommit()
PoolConfiguration
Connection.setAutoCommit(boolean)
method will not be called.)getDefaultAutoCommit
in interface PoolConfiguration
public Boolean getDefaultReadOnly()
PoolConfiguration
Connection.setReadOnly(boolean)
will be called with the set value.getDefaultReadOnly
in interface PoolConfiguration
public PoolProperties.InterceptorDefinition[] getJdbcInterceptorsAsArray()
PoolConfiguration
PoolConfiguration.getJdbcInterceptors()
as an array of objects with properties and the classes.getJdbcInterceptorsAsArray
in interface PoolConfiguration
public boolean getUseLock()
PoolConfiguration
getUseLock
in interface PoolConfiguration
public boolean isFairQueue()
PoolConfiguration
true
if a fair queue is being used by the connection poolisFairQueue
in interface PoolConfiguration
true
if a fair waiting queue is being usedpublic boolean isJmxEnabled()
PoolConfiguration
ConnectionPoolMBean
object
that can be registered with JMX to receive notifications and state about the pool.
The ConnectionPool object doesn't register itself, as there is no way to keep a static non changing ObjectName across JVM restarts.isJmxEnabled
in interface PoolConfiguration
public boolean isUseEquals()
PoolConfiguration
ProxyConnection
class to use String.equals
instead of
==
when comparing method names.
This property does not apply to added interceptors as those are configured individually.
The default value is false
.isUseEquals
in interface PoolConfiguration
String.equals(Object)
instead of == when comparing method names on Connection
methodspublic void setAbandonWhenPercentageFull(int percentage)
PoolConfiguration
setAbandonWhenPercentageFull
in interface PoolConfiguration
percentage
- a value between 0 and 100 to indicate when connections that have been abandoned/timed out are considered abandonedpublic void setAccessToUnderlyingConnectionAllowed(boolean accessToUnderlyingConnectionAllowed)
PoolConfiguration
setAccessToUnderlyingConnectionAllowed
in interface PoolConfiguration
accessToUnderlyingConnectionAllowed
- parameter ignoredpublic void setDbProperties(Properties dbProperties)
PoolConfiguration
Driver.connect(String, Properties)
method.setDbProperties
in interface PoolConfiguration
dbProperties
- The database propertiespublic void setDefaultReadOnly(Boolean defaultReadOnly)
PoolConfiguration
Connection.setReadOnly(boolean)
will be called with the set value.setDefaultReadOnly
in interface PoolConfiguration
defaultReadOnly
- null if not set and accepting the driver default.public void setMaxAge(long maxAge)
PoolConfiguration
PoolConfiguration.getTimeBetweenEvictionRunsMillis()
returns a value greater than 0.
The default value is 0, which implies that connections will be left open and no
age checks will be done.
This is a useful setting for database sessions that leak memory as it ensures that the session
will have a finite life span.setMaxAge
in interface PoolConfiguration
maxAge
- the time in milliseconds a connection will be open for when usedpublic void setName(String name)
PoolConfiguration
setName
in interface PoolConfiguration
name
- the name of the pool, should be unique in a runtime JVMpublic String getPoolName()
getPoolName
in interface PoolConfiguration
PoolConfiguration.getName()
public void setConnectionProperties(String connectionProperties)
PoolConfiguration
Driver.connect(String, Properties)
method.
Username and password do not need to be stored here, they will be passed into the properties right before the connection is established.setConnectionProperties
in interface PoolConfiguration
connectionProperties
- properties - Format of the string is [propertyName=property;]*
Example: prop1=value1;prop2=value2public void setDefaultAutoCommit(Boolean defaultAutoCommit)
PoolConfiguration
Connection.setAutoCommit(boolean)
method will not be called.)setDefaultAutoCommit
in interface PoolConfiguration
defaultAutoCommit
- default auto commit setting, null is Driver default.public void setDefaultCatalog(String defaultCatalog)
PoolConfiguration
Connection.setCatalog(String)
will be called with the set value.setDefaultCatalog
in interface PoolConfiguration
defaultCatalog
- null if not set and accepting the driver default.public void setDefaultTransactionIsolation(int defaultTransactionIsolation)
PoolConfiguration
DataSourceFactory.UNKNOWN_TRANSACTIONISOLATION
the method
Connection.setTransactionIsolation(int)
will not be called during connection creation. Otherwise the method
will be called with the isolation level set by this property.setDefaultTransactionIsolation
in interface PoolConfiguration
defaultTransactionIsolation
- a value of Connection.TRANSACTION_NONE
, Connection.TRANSACTION_READ_COMMITTED
,
Connection.TRANSACTION_READ_UNCOMMITTED
, Connection.TRANSACTION_REPEATABLE_READ
,
Connection.TRANSACTION_SERIALIZABLE
or DataSourceFactory.UNKNOWN_TRANSACTIONISOLATION
The last value will not be set on the connection.public void setDriverClassName(String driverClassName)
PoolConfiguration
setDriverClassName
in interface PoolConfiguration
driverClassName
- a fully qualified Java class name of a Driver
implementation.public void setFairQueue(boolean fairQueue)
PoolConfiguration
FairBlockingQueue
implementation for the list of the idle connections.
The default value is true.
This flag is required when you want to use asynchronous connection retrieval.setFairQueue
in interface PoolConfiguration
fairQueue
- true
to use a fair queuepublic void setInitialSize(int initialSize)
PoolConfiguration
PoolConfiguration.setMaxActive(int)
it will automatically be lowered.setInitialSize
in interface PoolConfiguration
initialSize
- the number of connections to be established.public void setInitSQL(String initSQL)
PoolConfiguration
setInitSQL
in interface PoolConfiguration
initSQL
- the init SQL used to run against the DB or null if no query should be executedpublic void setJdbcInterceptors(String jdbcInterceptors)
PoolConfiguration
JdbcInterceptor
class.
These interceptors will be inserted as an interceptor into the chain of operations on a java.sql.Connection object.
Example interceptors are StatementFinalizer
to close all
used statements during the session.
ResetAbandonedTimer
resets the timer upon every operation
on the connection or a statement.
ConnectionState
caches the auto commit, read only and catalog settings to avoid round trips to the DB.
The default value is null.setJdbcInterceptors
in interface PoolConfiguration
jdbcInterceptors
- the interceptors that are used for connections.
Example format: 'ConnectionState(useEquals=true,fast=yes);ResetAbandonedTimer'public void setJmxEnabled(boolean jmxEnabled)
PoolConfiguration
ConnectionPoolMBean
object
that can be registered with JMX to receive notifications and state about the pool.
The ConnectionPool object doesn't register itself, as there is no way to keep a static non changing ObjectName across JVM restarts.setJmxEnabled
in interface PoolConfiguration
jmxEnabled
- set to to if the mbean object should be created upon startup.public void setLogAbandoned(boolean logAbandoned)
PoolConfiguration
setLogAbandoned
in interface PoolConfiguration
logAbandoned
- set to true if stack traces should be recorded when DataSourceProxy.getConnection()
is called.public void setMaxActive(int maxActive)
PoolConfiguration
setMaxActive
in interface PoolConfiguration
maxActive
- hard limit for number of managed connections by this poolpublic void setMaxIdle(int maxIdle)
PoolConfiguration
PoolConfiguration.isPoolSweeperEnabled()
returns false.
If the If PoolConfiguration.isPoolSweeperEnabled()
returns true, then the idle pool can grow up to PoolConfiguration.getMaxActive()
and will be shrunk according to PoolConfiguration.getMinEvictableIdleTimeMillis()
setting.
Default value is maxActive:100setMaxIdle
in interface PoolConfiguration
maxIdle
- the maximum size of the idle poolpublic void setMaxWait(int maxWait)
PoolConfiguration
PoolConfiguration.getMaxActive()
has been reached) for a connection to be returned
before throwing an exception. Default value is 30000 (30 seconds)setMaxWait
in interface PoolConfiguration
maxWait
- the maximum number of milliseconds to wait.public void setMinEvictableIdleTimeMillis(int minEvictableIdleTimeMillis)
PoolConfiguration
setMinEvictableIdleTimeMillis
in interface PoolConfiguration
minEvictableIdleTimeMillis
- the number of milliseconds a connection must be idle to be eligible for eviction.public void setMinIdle(int minIdle)
PoolConfiguration
PoolConfiguration.getInitialSize()
(also see PoolConfiguration.setTestWhileIdle(boolean)
The idle pool will not shrink below this value during an eviction run, hence the number of actual connections
can be between PoolConfiguration.getMinIdle()
and somewhere between PoolConfiguration.getMaxIdle()
and PoolConfiguration.getMaxActive()
setMinIdle
in interface PoolConfiguration
minIdle
- the minimum number of idle or established connectionspublic void setNumTestsPerEvictionRun(int numTestsPerEvictionRun)
PoolConfiguration
setNumTestsPerEvictionRun
in interface PoolConfiguration
numTestsPerEvictionRun
- parameter ignored.public void setPassword(String password)
PoolConfiguration
setPassword
in interface PoolConfiguration
password
- The passwordPoolConfiguration.getDbProperties()
public void setRemoveAbandoned(boolean removeAbandoned)
PoolConfiguration
PoolConfiguration.getRemoveAbandonedTimeout()
and the condition for
PoolConfiguration.getAbandonWhenPercentageFull()
is met.
Setting this to true can recover db connections from applications that fail to close a connection.
See also PoolConfiguration.isLogAbandoned()
The default value is false.setRemoveAbandoned
in interface PoolConfiguration
removeAbandoned
- set to true if abandoned connections can be closed and expelled out of the poolpublic void setRemoveAbandonedTimeout(int removeAbandonedTimeout)
PoolConfiguration
setRemoveAbandonedTimeout
in interface PoolConfiguration
removeAbandonedTimeout
- the time in seconds before a used connection can be considered abandonedResetAbandonedTimer
public void setTestOnBorrow(boolean testOnBorrow)
PoolConfiguration
PoolConfiguration.setValidationInterval(long)
setTestOnBorrow
in interface PoolConfiguration
testOnBorrow
- set to true if validation should take place before a connection is handed out to the applicationPoolConfiguration.getValidationInterval()
public void setTestOnConnect(boolean testOnConnect)
PoolConfiguration
PoolConfiguration.setInitSQL(String)
will override this setting, as the init SQL will be used instead of the validation querysetTestOnConnect
in interface PoolConfiguration
testOnConnect
- set to true if we should run the validation query upon connectpublic void setTestOnReturn(boolean testOnReturn)
PoolConfiguration
PoolConfiguration.setValidationInterval(long)
setTestOnReturn
in interface PoolConfiguration
testOnReturn
- true if validation should take place after a connection is returned to the poolPoolConfiguration.getValidationInterval()
public void setTestWhileIdle(boolean testWhileIdle)
PoolConfiguration
setTestWhileIdle
in interface PoolConfiguration
testWhileIdle
- true if validation should take place during idle checksPoolConfiguration.setTimeBetweenEvictionRunsMillis(int)
public void setTimeBetweenEvictionRunsMillis(int timeBetweenEvictionRunsMillis)
PoolConfiguration
setTimeBetweenEvictionRunsMillis
in interface PoolConfiguration
timeBetweenEvictionRunsMillis
- the sleep time in between validations in millisecondspublic void setUrl(String url)
PoolConfiguration
setUrl
in interface PoolConfiguration
url
- the configured URL for this connection poolDriver.connect(String, Properties)
public void setUseEquals(boolean useEquals)
PoolConfiguration
ProxyConnection
class to use String.equals
instead of
==
when comparing method names.
This property does not apply to added interceptors as those are configured individually.
The default value is false
.setUseEquals
in interface PoolConfiguration
useEquals
- set to true if the pool should use String.equals(Object)
instead of ==
when comparing method names on Connection
methodspublic void setUseLock(boolean useLock)
PoolConfiguration
setUseLock
in interface PoolConfiguration
useLock
- set to true if a lock should be used on connection operationspublic void setUsername(String username)
PoolConfiguration
setUsername
in interface PoolConfiguration
username
- The user namePoolConfiguration.getDbProperties()
public void setValidationInterval(long validationInterval)
PoolConfiguration
setValidationInterval
in interface PoolConfiguration
validationInterval
- the validation interval in millisecondspublic void setValidationQuery(String validationQuery)
PoolConfiguration
setValidationQuery
in interface PoolConfiguration
validationQuery
- the query used for validation or null if no validation is performedpublic void setValidationQueryTimeout(int validationQueryTimeout)
PoolConfiguration
setValidationQueryTimeout
in interface PoolConfiguration
validationQueryTimeout
- The timeout valuepublic void setValidatorClassName(String className)
setValidatorClassName
in interface PoolConfiguration
className
- the name of the optional validator classpublic int getSuspectTimeout()
getSuspectTimeout
in interface PoolConfiguration
public void setSuspectTimeout(int seconds)
PoolConfiguration.setRemoveAbandonedTimeout(int)
but instead of treating the connection
as abandoned, and potentially closing the connection, this simply logs the warning if
PoolConfiguration.isLogAbandoned()
returns true. If this value is equal or less than 0, no suspect
checking will be performed. Suspect checking only takes place if the timeout value is larger than 0 and
the connection was not abandoned or if abandon check is disabled. If a connection is suspect a WARN message gets
logged and a JMX notification gets sent once.setSuspectTimeout
in interface PoolConfiguration
seconds
- - the amount of time in seconds that has to pass before a connection is marked suspect.public void setDataSource(Object ds)
PoolConfiguration.getUrl()
and PoolConfiguration.getDriverClassName()
methods are ignored
and not used by the pool. If the PoolConfiguration.getUsername()
and PoolConfiguration.getPassword()
values are set, the method DataSource.getConnection(String, String)
method will be called instead of the
DataSource.getConnection()
method.
If the data source implements XADataSource
the methods
XADataSource.getXAConnection()
and XADataSource.getXAConnection(String,String)
will be invoked.setDataSource
in interface PoolConfiguration
ds
- the DataSource
to be used for creating connections to be pooled.public Object getDataSource()
Driver
getDataSource
in interface PoolConfiguration
DataSource
to be used for creating connections to be pooled or null if a Driver is used.public void setDataSourceJNDI(String jndiDS)
PoolConfiguration.setDataSource(Object)
But instead of injecting the object, specify the JNDI location.
After a successful JNDI look, the PoolConfiguration.getDataSource()
will not return null.setDataSourceJNDI
in interface PoolConfiguration
jndiDS
- -the JNDI string @TODO specify the rules here.public String getDataSourceJNDI()
getDataSourceJNDI
in interface PoolConfiguration
public boolean isAlternateUsernameAllowed()
getConnection(username,password)
is
allowed. This is used for when the pool is used by an application accessing multiple schemas.
There is a performance impact turning this option on.isAlternateUsernameAllowed
in interface PoolConfiguration
getConnection(username,password)
is honored, false if it is ignored.public void setAlternateUsernameAllowed(boolean alternateUsernameAllowed)
getConnection(username,password)
is
allowed and honored.. This is used for when the pool is used by an application accessing multiple schemas.
There is a performance impact turning this option on, even when not used due to username checks.setAlternateUsernameAllowed
in interface PoolConfiguration
alternateUsernameAllowed
- - set true if getConnection(username,password)
is honored,
false if it is to be ignored.public void setValidator(Validator validator)
setValidator
in interface PoolConfiguration
validator
- The validator objectpublic void setCommitOnReturn(boolean commitOnReturn)
PoolConfiguration.getDefaultAutoCommit()
returns falsesetCommitOnReturn
in interface PoolConfiguration
commitOnReturn
- set to true if the pool should call Connection.commit()
when a connection is returned to the pool.
Default is falsepublic boolean getCommitOnReturn()
getCommitOnReturn
in interface PoolConfiguration
true
if the pool should commit when a connection is returned to itPoolConfiguration.setCommitOnReturn(boolean)
public void setRollbackOnReturn(boolean rollbackOnReturn)
PoolConfiguration.getDefaultAutoCommit()
returns falsesetRollbackOnReturn
in interface PoolConfiguration
rollbackOnReturn
- set to true if the pool should call Connection.rollback()
when a connection is returned to the pool.
Default is falsepublic boolean getRollbackOnReturn()
getRollbackOnReturn
in interface PoolConfiguration
true
if the pool should rollback when a connection is returned to itPoolConfiguration.setRollbackOnReturn(boolean)
public void setUseDisposableConnectionFacade(boolean useDisposableConnectionFacade)
true
, the connection will be wrapped with facade that will disallow the connection to be used after
Connection.close()
is called. If set to true
, after Connection.close()
all calls except
Connection.close()
and Connection.isClosed()
will throw an exception.setUseDisposableConnectionFacade
in interface PoolConfiguration
useDisposableConnectionFacade
- true
to use a facadepublic boolean getUseDisposableConnectionFacade()
true
if this connection pool is configured to use a connection facade to prevent re-use of connection after
Connection.close()
has been invokedgetUseDisposableConnectionFacade
in interface PoolConfiguration
true
if Connection.close()
has been invoked.public void setLogValidationErrors(boolean logValidationErrors)
setLogValidationErrors
in interface PoolConfiguration
logValidationErrors
- set to true to log validation errorspublic boolean getLogValidationErrors()
getLogValidationErrors
in interface PoolConfiguration
public boolean getPropagateInterruptState()
PoolExhaustedException
getPropagateInterruptState
in interface PoolConfiguration
public void setPropagateInterruptState(boolean propagateInterruptState)
PoolExhaustedException
If set to true, this behavior will change, while the PoolExhaustedException
is still thrown, the threads interrupted state is still set.setPropagateInterruptState
in interface PoolConfiguration
propagateInterruptState
- - set to true to not clear, but propagate, a threads interrupted state.public boolean isIgnoreExceptionOnPreLoad()
isIgnoreExceptionOnPreLoad
in interface PoolConfiguration
true
to ignore exceptionsPoolConfiguration.setIgnoreExceptionOnPreLoad(boolean)
public void setIgnoreExceptionOnPreLoad(boolean ignoreExceptionOnPreLoad)
setIgnoreExceptionOnPreLoad
in interface PoolConfiguration
ignoreExceptionOnPreLoad
- set to true if you want to ignore error of connection creation while initializing the pool.public boolean getUseStatementFacade()
true
if this connection pool is configured to wrap statements in order
to enable equals() and hashCode() methods to be called on the closed statements if any
statement proxy is set.getUseStatementFacade
in interface PoolConfiguration
true
if the statements are wrappedpublic void setUseStatementFacade(boolean useStatementFacade)
setUseStatementFacade
in interface PoolConfiguration
useStatementFacade
- set to true
to wrap statementspublic void purge()
ConnectionPoolMBean.purgeOnReturn()
purge
in interface ConnectionPoolMBean
public void purgeOnReturn()
ConnectionPoolMBean.purge()
purgeOnReturn
in interface ConnectionPoolMBean
Copyright © 2000-2021 Apache Software Foundation. All Rights Reserved.