Class DriverAdapterCPDS
- All Implemented Interfaces:
Serializable
,Referenceable
,ObjectFactory
,CommonDataSource
,ConnectionPoolDataSource
An adapter for JDBC drivers that do not include an implementation of ConnectionPoolDataSource
, but
still include a DriverManager
implementation. ConnectionPoolDataSource
s are not used
within general applications. They are used by DataSource
implementations that pool
Connection
s, such as SharedPoolDataSource
. A J2EE container
will normally provide some method of initializing the ConnectionPoolDataSource
whose attributes are
presented as bean getters/setters and then deploying it via JNDI. It is then available as a source of physical
connections to the database, when the pooling DataSource
needs to create a new physical connection.
Although normally used within a JNDI environment, the DriverAdapterCPDS can be instantiated and initialized as any
bean and then attached directly to a pooling DataSource
. Jdbc2PoolDataSource
can use the
ConnectionPoolDataSource
with or without the use of JNDI.
The DriverAdapterCPDS also provides PreparedStatement
pooling which is not generally available in jdbc2
ConnectionPoolDataSource
implementation, but is addressed within the jdbc3 specification. The
PreparedStatement
pool in DriverAdapterCPDS has been in the dbcp package for some time, but it has not
undergone extensive testing in the configuration used here. It should be considered experimental and can be toggled
with the poolPreparedStatements attribute.
The package documentation contains an example using catalina and JNDI. The
datasources package documentation shows how to use
DriverAdapterCPDS
as a source for Jdbc2PoolDataSource
without the use of JNDI.
- Since:
- 2.0
- See Also:
-
Constructor Summary
-
Method Summary
Modifier and TypeMethodDescriptionGets the connection properties passed to the JDBC driver.Gets the value of description.Gets the driver class name.int
Gets the maximum time in seconds that this data source can wait while attempting to connect to a database.Gets the log writer for this data source.int
Gets the maximum number of statements that can remain idle in the pool, without extra ones being released, or negative for no limit.int
Gets the maximum number of prepared statements.int
Gets the minimum amount of time a statement may sit idle in the pool before it is eligible for eviction by the idle object evictor (if any).int
Gets the number of statements to examine during each run of the idle object evictor thread (if any.)getObjectInstance
(Object refObj, Name name, Context context, Hashtable<?, ?> env) ImplementsObjectFactory
to create an instance of this classGets the value of password for the default user.char[]
Gets the value of password for the default user.Attempts to establish a database connection using the default user and password.getPooledConnection
(String pooledUserName, String pooledUserPassword) Attempts to establish a database connection.ImplementsReferenceable
.long
Gets the number of milliseconds to sleep between runs of the idle object evictor thread.getUrl()
Gets the value of url used to locate the database for this datasource.getUser()
Gets the value of default user (login or user name).boolean
Returns the value of the accessToUnderlyingConnectionAllowed property.boolean
Whether to toggle the pooling ofPreparedStatement
svoid
setAccessToUnderlyingConnectionAllowed
(boolean allow) Sets the value of the accessToUnderlyingConnectionAllowed property.void
Sets the connection properties passed to the JDBC driver.void
setDescription
(String description) Sets the value of description.void
Sets the driver class name.void
setLoginTimeout
(int seconds) Sets the maximum time in seconds that this data source will wait while attempting to connect to a database.void
setLogWriter
(PrintWriter logWriter) Sets the log writer for this data source.void
setMaxIdle
(int maxIdle) Gets the maximum number of statements that can remain idle in the pool, without extra ones being released, or negative for no limit.void
setMaxPreparedStatements
(int maxPreparedStatements) Sets the maximum number of prepared statements.void
setMinEvictableIdleTimeMillis
(int minEvictableIdleTimeMillis) Sets the minimum amount of time a statement may sit idle in the pool before it is eligible for eviction by the idle object evictor (if any).void
setNumTestsPerEvictionRun
(int numTestsPerEvictionRun) Sets the number of statements to examine during each run of the idle object evictor thread (if any).void
setPassword
(char[] userPassword) Sets the value of password for the default user.void
setPassword
(String userPassword) Sets the value of password for the default user.void
setPoolPreparedStatements
(boolean poolPreparedStatements) Whether to toggle the pooling ofPreparedStatement
svoid
setTimeBetweenEvictionRunsMillis
(long timeBetweenEvictionRunsMillis) Sets the number of milliseconds to sleep between runs of the idle object evictor thread.void
Sets the value of URL string used to locate the database for this datasource.void
Sets the value of default user (login or user name).toString()
Does not print the userName and userPassword field nor the 'user' or 'password' in the connectionProperties.Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
Methods inherited from interface javax.sql.CommonDataSource
createShardingKeyBuilder
Methods inherited from interface javax.sql.ConnectionPoolDataSource
createPooledConnectionBuilder
-
Constructor Details
-
DriverAdapterCPDS
public DriverAdapterCPDS()Default no-arg constructor for Serialization
-
-
Method Details
-
getConnectionProperties
Gets the connection properties passed to the JDBC driver.- Returns:
- the JDBC connection properties used when creating connections.
-
getDescription
Gets the value of description. This property is here for use by the code which will deploy this datasource. It is not used internally.- Returns:
- value of description, may be null.
- See Also:
-
getDriver
Gets the driver class name.- Returns:
- value of driver.
-
getLoginTimeout
public int getLoginTimeout()Gets the maximum time in seconds that this data source can wait while attempting to connect to a database. NOT USED.- Specified by:
getLoginTimeout
in interfaceCommonDataSource
- Specified by:
getLoginTimeout
in interfaceConnectionPoolDataSource
-
getLogWriter
Gets the log writer for this data source. NOT USED.- Specified by:
getLogWriter
in interfaceCommonDataSource
- Specified by:
getLogWriter
in interfaceConnectionPoolDataSource
-
getMaxIdle
public int getMaxIdle()Gets the maximum number of statements that can remain idle in the pool, without extra ones being released, or negative for no limit.- Returns:
- the value of maxIdle
-
getMaxPreparedStatements
public int getMaxPreparedStatements()Gets the maximum number of prepared statements.- Returns:
- maxPrepartedStatements value
-
getMinEvictableIdleTimeMillis
public int getMinEvictableIdleTimeMillis()Gets the minimum amount of time a statement may sit idle in the pool before it is eligible for eviction by the idle object evictor (if any).- Returns:
- the minimum amount of time a statement may sit idle in the pool.
- See Also:
-
getNumTestsPerEvictionRun
public int getNumTestsPerEvictionRun()Gets the number of statements to examine during each run of the idle object evictor thread (if any.)- Returns:
- the number of statements to examine during each run of the idle object evictor thread (if any.)
- See Also:
-
getObjectInstance
public Object getObjectInstance(Object refObj, Name name, Context context, Hashtable<?, ?> env) throws ExceptionImplementsObjectFactory
to create an instance of this class- Specified by:
getObjectInstance
in interfaceObjectFactory
- Throws:
Exception
-
getParentLogger
- Specified by:
getParentLogger
in interfaceCommonDataSource
- Throws:
SQLFeatureNotSupportedException
-
getPassword
Gets the value of password for the default user.- Returns:
- value of password.
-
getPasswordCharArray
public char[] getPasswordCharArray()Gets the value of password for the default user.- Returns:
- value of password.
- Since:
- 2.4.0
-
getPooledConnection
Attempts to establish a database connection using the default user and password.- Specified by:
getPooledConnection
in interfaceConnectionPoolDataSource
- Throws:
SQLException
-
getPooledConnection
public PooledConnection getPooledConnection(String pooledUserName, String pooledUserPassword) throws SQLException Attempts to establish a database connection.- Specified by:
getPooledConnection
in interfaceConnectionPoolDataSource
- Parameters:
pooledUserName
- name to be used for the connectionpooledUserPassword
- password to be used fur the connection- Throws:
SQLException
-
getReference
ImplementsReferenceable
.- Specified by:
getReference
in interfaceReferenceable
- Throws:
NamingException
-
getTimeBetweenEvictionRunsMillis
public long getTimeBetweenEvictionRunsMillis()Gets the number of milliseconds to sleep between runs of the idle object evictor thread. When non-positive, no idle object evictor thread will be run.- Returns:
- the value of the evictor thread timer
- See Also:
-
getUrl
Gets the value of url used to locate the database for this datasource.- Returns:
- value of url.
-
getUser
Gets the value of default user (login or user name).- Returns:
- value of user.
-
isAccessToUnderlyingConnectionAllowed
public boolean isAccessToUnderlyingConnectionAllowed()Returns the value of the accessToUnderlyingConnectionAllowed property.- Returns:
- true if access to the underlying is allowed, false otherwise.
-
isPoolPreparedStatements
public boolean isPoolPreparedStatements()Whether to toggle the pooling ofPreparedStatement
s- Returns:
- value of poolPreparedStatements.
-
setAccessToUnderlyingConnectionAllowed
public void setAccessToUnderlyingConnectionAllowed(boolean allow) Sets the value of the accessToUnderlyingConnectionAllowed property. It controls if the PoolGuard allows access to the underlying connection. (Default: false)- Parameters:
allow
- Access to the underlying connection is granted when true.
-
setConnectionProperties
Sets the connection properties passed to the JDBC driver.If
props
contains "user" and/or "password" properties, the corresponding instance properties are set. If these properties are not present, they are filled in usinggetUser()
,getPassword()
whengetPooledConnection()
is called, or using the actual parameters to the method call whengetPooledConnection(String, String)
is called. Calls tosetUser(String)
orsetPassword(String)
overwrite the values of these properties ifconnectionProperties
is not null.- Parameters:
props
- Connection properties to use when creating new connections.- Throws:
IllegalStateException
- ifgetPooledConnection()
has been called
-
setDescription
Sets the value of description. This property is here for use by the code which will deploy this datasource. It is not used internally.- Parameters:
description
- Value to assign to description.
-
setDriver
Sets the driver class name. Setting the driver class name cause the driver to be registered with the DriverManager.- Parameters:
driver
- Value to assign to driver.- Throws:
IllegalStateException
- ifgetPooledConnection()
has been calledClassNotFoundException
- if the class cannot be located
-
setLoginTimeout
public void setLoginTimeout(int seconds) Sets the maximum time in seconds that this data source will wait while attempting to connect to a database. NOT USED.- Specified by:
setLoginTimeout
in interfaceCommonDataSource
- Specified by:
setLoginTimeout
in interfaceConnectionPoolDataSource
-
setLogWriter
Sets the log writer for this data source. NOT USED.- Specified by:
setLogWriter
in interfaceCommonDataSource
- Specified by:
setLogWriter
in interfaceConnectionPoolDataSource
-
setMaxIdle
public void setMaxIdle(int maxIdle) Gets the maximum number of statements that can remain idle in the pool, without extra ones being released, or negative for no limit.- Parameters:
maxIdle
- The maximum number of statements that can remain idle- Throws:
IllegalStateException
- ifgetPooledConnection()
has been called
-
setMaxPreparedStatements
public void setMaxPreparedStatements(int maxPreparedStatements) Sets the maximum number of prepared statements.- Parameters:
maxPreparedStatements
- the new maximum number of prepared statements
-
setMinEvictableIdleTimeMillis
public void setMinEvictableIdleTimeMillis(int minEvictableIdleTimeMillis) Sets the minimum amount of time a statement may sit idle in the pool before it is eligible for eviction by the idle object evictor (if any). When non-positive, no objects will be evicted from the pool due to idle time alone.- Parameters:
minEvictableIdleTimeMillis
- minimum time to set (in ms)- Throws:
IllegalStateException
- ifgetPooledConnection()
has been called- See Also:
-
setNumTestsPerEvictionRun
public void setNumTestsPerEvictionRun(int numTestsPerEvictionRun) Sets the number of statements to examine during each run of the idle object evictor thread (if any).When a negative value is supplied,
ceil(
tests will be run. I.e., when the value is -n, roughly one nth of the idle objects will be tested per run.BasicDataSource.getNumIdle()
)/abs(getNumTestsPerEvictionRun()
)- Parameters:
numTestsPerEvictionRun
- number of statements to examine per run- Throws:
IllegalStateException
- ifgetPooledConnection()
has been called- See Also:
-
setPassword
public void setPassword(char[] userPassword) Sets the value of password for the default user.- Parameters:
userPassword
- Value to assign to password.- Throws:
IllegalStateException
- ifgetPooledConnection()
has been called
-
setPassword
Sets the value of password for the default user.- Parameters:
userPassword
- Value to assign to password.- Throws:
IllegalStateException
- ifgetPooledConnection()
has been called
-
setPoolPreparedStatements
public void setPoolPreparedStatements(boolean poolPreparedStatements) Whether to toggle the pooling ofPreparedStatement
s- Parameters:
poolPreparedStatements
- true to pool statements.- Throws:
IllegalStateException
- ifgetPooledConnection()
has been called
-
setTimeBetweenEvictionRunsMillis
public void setTimeBetweenEvictionRunsMillis(long timeBetweenEvictionRunsMillis) Sets the number of milliseconds to sleep between runs of the idle object evictor thread. When non-positive, no idle object evictor thread will be run.- Parameters:
timeBetweenEvictionRunsMillis
- The number of milliseconds to sleep between runs of the idle object evictor thread. When non-positive, no idle object evictor thread will be run.- Throws:
IllegalStateException
- ifgetPooledConnection()
has been called- See Also:
-
setUrl
Sets the value of URL string used to locate the database for this datasource.- Parameters:
url
- Value to assign to url.- Throws:
IllegalStateException
- ifgetPooledConnection()
has been called
-
setUser
Sets the value of default user (login or user name).- Parameters:
userName
- Value to assign to user.- Throws:
IllegalStateException
- ifgetPooledConnection()
has been called
-
toString
Does not print the userName and userPassword field nor the 'user' or 'password' in the connectionProperties.
-