Class AbstractPoolBackedDataSource

java.lang.Object

com.mchange.v2.c3p0.impl.AbstractIdentityTokenized

com.mchange.v2.c3p0.impl.IdentityTokenResolvable

com.mchange.v2.c3p0.impl.PoolBackedDataSourceBase

com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource

All Implemented Interfaces:

IdentityTokenized, PooledDataSource, Serializable, AutoCloseable, Wrapper, Referenceable, CommonDataSource, DataSource

Direct Known Subclasses:

AbstractComboPooledDataSource, PoolBackedDataSource

public abstract class AbstractPoolBackedDataSource
extends PoolBackedDataSourceBase
implements PooledDataSource

See Also:

• Serialized Form

Field Summary

Fields inherited from class PoolBackedDataSourceBase

pcs, vcs

Constructor Summary

Constructors

Modifier	Constructor	Description
protected	AbstractPoolBackedDataSource(boolean autoregister)

Method Summary

Modifier and Type	Method	Description
void	close()	C3P0 pooled DataSources use no resources before they are actually used in a VM, and they close themselves in their finalize() method.
void	close(boolean force_destroy)	Deprecated. the force_destroy argument is now meaningless, as pools are no longer potentially shared between multiple DataSources.
Collection	getAllUsers()
Connection	getConnection()
Connection	getConnection(String username, String password)
String	getDataSourceName()
float	getEffectivePropertyCycle(String username, String password)
float	getEffectivePropertyCycleDefaultUser()
Throwable	getLastAcquisitionFailure(String username, String password)
Throwable	getLastAcquisitionFailureDefaultUser()
Throwable	getLastCheckinFailure(String username, String password)
Throwable	getLastCheckinFailureDefaultUser()
Throwable	getLastCheckoutFailure(String username, String password)
Throwable	getLastCheckoutFailureDefaultUser()
Throwable	getLastConnectionTestFailure(String username, String password)
Throwable	getLastConnectionTestFailureDefaultUser()
Throwable	getLastIdleTestFailure(String username, String password)
Throwable	getLastIdleTestFailureDefaultUser()
int	getLoginTimeout()
PrintWriter	getLogWriter()
int	getNumBusyConnections()
int	getNumBusyConnections(String username, String password)
int	getNumBusyConnectionsAllUsers()
int	getNumBusyConnectionsDefaultUser()
int	getNumConnections()
int	getNumConnections(String username, String password)
int	getNumConnectionsAllUsers()
int	getNumConnectionsDefaultUser()
long	getNumFailedCheckins(String username, String password)
long	getNumFailedCheckinsDefaultUser()
long	getNumFailedCheckouts(String username, String password)
long	getNumFailedCheckoutsDefaultUser()
long	getNumFailedIdleTests(String username, String password)
long	getNumFailedIdleTestsDefaultUser()
int	getNumIdleConnections()
int	getNumIdleConnections(String username, String password)
int	getNumIdleConnectionsAllUsers()
int	getNumIdleConnectionsDefaultUser()
int	getNumThreadsAwaitingCheckout(String username, String password)
int	getNumThreadsAwaitingCheckoutDefaultUser()
int	getNumUnclosedOrphanedConnections()
int	getNumUnclosedOrphanedConnections(String username, String password)
int	getNumUnclosedOrphanedConnectionsAllUsers()
int	getNumUnclosedOrphanedConnectionsDefaultUser()
int	getNumUserPools()
long	getStartTimeMillis(String username, String password)
long	getStartTimeMillisDefaultUser()
int	getStatementCacheNumCheckedOut(String username, String password)
int	getStatementCacheNumCheckedOutDefaultUser()
int	getStatementCacheNumCheckedOutStatementsAllUsers()
int	getStatementCacheNumConnectionsWithCachedStatements(String username, String password)
int	getStatementCacheNumConnectionsWithCachedStatementsAllUsers()
int	getStatementCacheNumConnectionsWithCachedStatementsDefaultUser()
int	getStatementCacheNumStatements(String username, String password)
int	getStatementCacheNumStatementsAllUsers()
int	getStatementCacheNumStatementsDefaultUser()
int	getStatementDestroyerNumActiveThreads()
int	getStatementDestroyerNumConnectionsInUse(String username, String password)
int	getStatementDestroyerNumConnectionsInUseAllUsers()
int	getStatementDestroyerNumConnectionsInUseDefaultUser()
int	getStatementDestroyerNumConnectionsWithDeferredDestroyStatements(String username, String password)
int	getStatementDestroyerNumConnectionsWithDeferredDestroyStatementsAllUsers()
int	getStatementDestroyerNumConnectionsWithDeferredDestroyStatementsDefaultUser()
int	getStatementDestroyerNumDeferredDestroyStatements(String username, String password)
int	getStatementDestroyerNumDeferredDestroyStatementsAllUsers()
int	getStatementDestroyerNumDeferredDestroyStatementsDefaultUser()
int	getStatementDestroyerNumIdleThreads()
int	getStatementDestroyerNumTasksPending()
int	getStatementDestroyerNumThreads()
int	getThreadPoolNumActiveThreads()
int	getThreadPoolNumIdleThreads()
int	getThreadPoolNumTasksPending()
int	getThreadPoolSize()
long	getUpTimeMillis(String username, String password)
long	getUpTimeMillisDefaultUser()
void	hardReset()	Destroys all pooled and checked-out Connections associated with this DataSource immediately.
protected void	initializeNamedConfig(String configName, boolean shouldBindUserOverridesAsString)
boolean	isWrapperFor(Class<?> iface)
protected final boolean	isWrapperForThis(Class<?> iface)
void	resetPoolManager()
void	resetPoolManager(boolean close_checked_out_connections)
String	sampleLastAcquisitionFailureStackTrace(String username, String password)
String	sampleLastAcquisitionFailureStackTraceDefaultUser()
String	sampleLastCheckinFailureStackTrace(String username, String password)
String	sampleLastCheckinFailureStackTraceDefaultUser()
String	sampleLastCheckoutFailureStackTrace(String username, String password)
String	sampleLastCheckoutFailureStackTraceDefaultUser()
String	sampleLastConnectionTestFailureStackTrace(String username, String password)
String	sampleLastConnectionTestFailureStackTraceDefaultUser()
String	sampleLastIdleTestFailureStackTrace(String username, String password)
String	sampleLastIdleTestFailureStackTraceDefaultUser()
String	sampleStatementCacheStatus(String username, String password)
String	sampleStatementCacheStatusDefaultUser()
String	sampleStatementDestroyerStackTraces()
String	sampleStatementDestroyerStatus()
String	sampleThreadPoolStackTraces()
String	sampleThreadPoolStatus()
void	setLoginTimeout(int seconds)
void	setLogWriter(PrintWriter out)
void	softReset(String username, String password)	Discards all Connections managed by the PooledDataSource with the specified authentication credentials and reacquires new Connections to populate.
void	softResetAllUsers()	Discards all Connections managed by the PooledDataSource and reacquires new Connections to populate.
void	softResetDefaultUser()	Discards all Connections managed by the PooledDataSource's default-authentication pool and reacquires new Connections to populate.
abstract String	toString(boolean show_config)
<T> T	unwrap(Class<T> iface)

Methods inherited from class PoolBackedDataSourceBase

addPropertyChangeListener, addPropertyChangeListener, addVetoableChangeListener, extraToStringInfo, getConnectionPoolDataSource, getExtensions, getFactoryClassLocation, getIdentityToken, getNumHelperThreads, getParentLogger, getPropertyChangeListeners, getPropertyChangeSupport, getReference, getVetoableChangeListeners, getVetoableChangeSupport, removePropertyChangeListener, removePropertyChangeListener, removeVetoableChangeListener, setConnectionPoolDataSource, setDataSourceName, setExtensions, setFactoryClassLocation, setIdentityToken, setNumHelperThreads, toString

Methods inherited from class IdentityTokenResolvable

doResolve, readResolve, verifyResolve

Methods inherited from class AbstractIdentityTokenized

equals, hashCode

Methods inherited from class Object

clone, finalize, getClass, notify, notifyAll, wait, wait, wait

Methods inherited from interface CommonDataSource

createShardingKeyBuilder, getParentLogger

Methods inherited from interface DataSource

createConnectionBuilder

Methods inherited from interface PooledDataSource

getExtensions, getIdentityToken, getNumHelperThreads, setDataSourceName, setExtensions

Constructor Details

AbstractPoolBackedDataSource

protected AbstractPoolBackedDataSource(boolean autoregister)

Method Details

initializeNamedConfig

protected void initializeNamedConfig(String configName,
 boolean shouldBindUserOverridesAsString)

getDataSourceName

public String getDataSourceName()

Specified by:

getDataSourceName in interface PooledDataSource

Overrides:

getDataSourceName in class PoolBackedDataSourceBase

getConnection

public Connection getConnection()
                         throws SQLException

Specified by:

getConnection in interface DataSource

Throws:

SQLException

getConnection

public Connection getConnection(String username,
 String password)
                         throws SQLException

Specified by:

getConnection in interface DataSource

Throws:

SQLException

getLogWriter

public PrintWriter getLogWriter()
                         throws SQLException

Specified by:

getLogWriter in interface CommonDataSource

Specified by:

getLogWriter in interface DataSource

Throws:

SQLException

setLogWriter

public void setLogWriter(PrintWriter out)
                  throws SQLException

Specified by:

setLogWriter in interface CommonDataSource

Specified by:

setLogWriter in interface DataSource

Throws:

SQLException

getLoginTimeout

public int getLoginTimeout()
                    throws SQLException

Specified by:

getLoginTimeout in interface CommonDataSource

Specified by:

getLoginTimeout in interface DataSource

Throws:

SQLException

setLoginTimeout

public void setLoginTimeout(int seconds)
                     throws SQLException

Specified by:

setLoginTimeout in interface CommonDataSource

Specified by:

setLoginTimeout in interface DataSource

Throws:

SQLException

getNumConnections

public int getNumConnections()
                      throws SQLException

Specified by:

getNumConnections in interface PooledDataSource

Throws:

SQLException

getNumIdleConnections

public int getNumIdleConnections()
                          throws SQLException

Specified by:

getNumIdleConnections in interface PooledDataSource

Throws:

SQLException

getNumBusyConnections

public int getNumBusyConnections()
                          throws SQLException

Specified by:

getNumBusyConnections in interface PooledDataSource

Throws:

SQLException

getNumUnclosedOrphanedConnections

public int getNumUnclosedOrphanedConnections()
                                      throws SQLException

Specified by:

getNumUnclosedOrphanedConnections in interface PooledDataSource

Throws:

SQLException

getNumConnectionsDefaultUser

public int getNumConnectionsDefaultUser()
                                 throws SQLException

Specified by:

getNumConnectionsDefaultUser in interface PooledDataSource

Throws:

SQLException

getNumIdleConnectionsDefaultUser

public int getNumIdleConnectionsDefaultUser()
                                     throws SQLException

Specified by:

getNumIdleConnectionsDefaultUser in interface PooledDataSource

Throws:

SQLException

getNumBusyConnectionsDefaultUser

public int getNumBusyConnectionsDefaultUser()
                                     throws SQLException

Specified by:

getNumBusyConnectionsDefaultUser in interface PooledDataSource

Throws:

SQLException

getNumUnclosedOrphanedConnectionsDefaultUser

public int getNumUnclosedOrphanedConnectionsDefaultUser()
                                                 throws SQLException

Specified by:

getNumUnclosedOrphanedConnectionsDefaultUser in interface PooledDataSource

Throws:

SQLException

getStatementCacheNumStatementsDefaultUser

public int getStatementCacheNumStatementsDefaultUser()
                                              throws SQLException

Specified by:

getStatementCacheNumStatementsDefaultUser in interface PooledDataSource

Throws:

SQLException

getStatementCacheNumCheckedOutDefaultUser

public int getStatementCacheNumCheckedOutDefaultUser()
                                              throws SQLException

Specified by:

getStatementCacheNumCheckedOutDefaultUser in interface PooledDataSource

Throws:

SQLException

getStatementCacheNumConnectionsWithCachedStatementsDefaultUser

public int getStatementCacheNumConnectionsWithCachedStatementsDefaultUser()
                                                                   throws SQLException

Specified by:

getStatementCacheNumConnectionsWithCachedStatementsDefaultUser in interface PooledDataSource

Throws:

SQLException

getEffectivePropertyCycleDefaultUser

public float getEffectivePropertyCycleDefaultUser()
                                           throws SQLException

Specified by:

getEffectivePropertyCycleDefaultUser in interface PooledDataSource

Throws:

SQLException

getStartTimeMillisDefaultUser

public long getStartTimeMillisDefaultUser()
                                   throws SQLException

Specified by:

getStartTimeMillisDefaultUser in interface PooledDataSource

Throws:

SQLException

getUpTimeMillisDefaultUser

public long getUpTimeMillisDefaultUser()
                                throws SQLException

Specified by:

getUpTimeMillisDefaultUser in interface PooledDataSource

Throws:

SQLException

getNumFailedCheckinsDefaultUser

public long getNumFailedCheckinsDefaultUser()
                                     throws SQLException

Specified by:

getNumFailedCheckinsDefaultUser in interface PooledDataSource

Throws:

SQLException

getNumFailedCheckoutsDefaultUser

public long getNumFailedCheckoutsDefaultUser()
                                      throws SQLException

Specified by:

getNumFailedCheckoutsDefaultUser in interface PooledDataSource

Throws:

SQLException

getNumFailedIdleTestsDefaultUser

public long getNumFailedIdleTestsDefaultUser()
                                      throws SQLException

Specified by:

getNumFailedIdleTestsDefaultUser in interface PooledDataSource

Throws:

SQLException

getNumThreadsAwaitingCheckoutDefaultUser

public int getNumThreadsAwaitingCheckoutDefaultUser()
                                             throws SQLException

Specified by:

getNumThreadsAwaitingCheckoutDefaultUser in interface PooledDataSource

Throws:

SQLException

getThreadPoolSize

public int getThreadPoolSize()
                      throws SQLException

Specified by:

getThreadPoolSize in interface PooledDataSource

Throws:

SQLException

getThreadPoolNumActiveThreads

public int getThreadPoolNumActiveThreads()
                                  throws SQLException

Specified by:

getThreadPoolNumActiveThreads in interface PooledDataSource

Throws:

SQLException

getThreadPoolNumIdleThreads

public int getThreadPoolNumIdleThreads()
                                throws SQLException

Specified by:

getThreadPoolNumIdleThreads in interface PooledDataSource

Throws:

SQLException

getThreadPoolNumTasksPending

public int getThreadPoolNumTasksPending()
                                 throws SQLException

Specified by:

getThreadPoolNumTasksPending in interface PooledDataSource

Throws:

SQLException

sampleThreadPoolStackTraces

public String sampleThreadPoolStackTraces()
                                   throws SQLException

Specified by:

sampleThreadPoolStackTraces in interface PooledDataSource

Throws:

SQLException

sampleThreadPoolStatus

public String sampleThreadPoolStatus()
                              throws SQLException

Specified by:

sampleThreadPoolStatus in interface PooledDataSource

Throws:

SQLException

sampleStatementCacheStatusDefaultUser

public String sampleStatementCacheStatusDefaultUser()
                                             throws SQLException

Specified by:

sampleStatementCacheStatusDefaultUser in interface PooledDataSource

Throws:

SQLException

sampleStatementCacheStatus

public String sampleStatementCacheStatus(String username,
 String password)
                                  throws SQLException

Specified by:

sampleStatementCacheStatus in interface PooledDataSource

Throws:

SQLException

getLastAcquisitionFailureDefaultUser

public Throwable getLastAcquisitionFailureDefaultUser()
                                               throws SQLException

Specified by:

getLastAcquisitionFailureDefaultUser in interface PooledDataSource

Throws:

SQLException

getLastCheckinFailureDefaultUser

public Throwable getLastCheckinFailureDefaultUser()
                                           throws SQLException

Specified by:

getLastCheckinFailureDefaultUser in interface PooledDataSource

Throws:

SQLException

getLastCheckoutFailureDefaultUser

public Throwable getLastCheckoutFailureDefaultUser()
                                            throws SQLException

Specified by:

getLastCheckoutFailureDefaultUser in interface PooledDataSource

Throws:

SQLException

getLastIdleTestFailureDefaultUser

public Throwable getLastIdleTestFailureDefaultUser()
                                            throws SQLException

Specified by:

getLastIdleTestFailureDefaultUser in interface PooledDataSource

Throws:

SQLException

getLastConnectionTestFailureDefaultUser

public Throwable getLastConnectionTestFailureDefaultUser()
                                                  throws SQLException

Specified by:

getLastConnectionTestFailureDefaultUser in interface PooledDataSource

Throws:

SQLException

getLastAcquisitionFailure

public Throwable getLastAcquisitionFailure(String username,
 String password)
                                    throws SQLException

Specified by:

getLastAcquisitionFailure in interface PooledDataSource

Throws:

SQLException

getLastCheckinFailure

public Throwable getLastCheckinFailure(String username,
 String password)
                                throws SQLException

Specified by:

getLastCheckinFailure in interface PooledDataSource

Throws:

SQLException

getLastCheckoutFailure

public Throwable getLastCheckoutFailure(String username,
 String password)
                                 throws SQLException

Specified by:

getLastCheckoutFailure in interface PooledDataSource

Throws:

SQLException

getLastIdleTestFailure

public Throwable getLastIdleTestFailure(String username,
 String password)
                                 throws SQLException

Specified by:

getLastIdleTestFailure in interface PooledDataSource

Throws:

SQLException

getLastConnectionTestFailure

public Throwable getLastConnectionTestFailure(String username,
 String password)
                                       throws SQLException

Specified by:

getLastConnectionTestFailure in interface PooledDataSource

Throws:

SQLException

getNumThreadsAwaitingCheckout

public int getNumThreadsAwaitingCheckout(String username,
 String password)
                                  throws SQLException

Specified by:

getNumThreadsAwaitingCheckout in interface PooledDataSource

Throws:

SQLException

sampleLastAcquisitionFailureStackTraceDefaultUser

public String sampleLastAcquisitionFailureStackTraceDefaultUser()
                                                         throws SQLException

Specified by:

sampleLastAcquisitionFailureStackTraceDefaultUser in interface PooledDataSource

Throws:

SQLException

sampleLastCheckinFailureStackTraceDefaultUser

public String sampleLastCheckinFailureStackTraceDefaultUser()
                                                     throws SQLException

Specified by:

sampleLastCheckinFailureStackTraceDefaultUser in interface PooledDataSource

Throws:

SQLException

sampleLastCheckoutFailureStackTraceDefaultUser

public String sampleLastCheckoutFailureStackTraceDefaultUser()
                                                      throws SQLException

Specified by:

sampleLastCheckoutFailureStackTraceDefaultUser in interface PooledDataSource

Throws:

SQLException

sampleLastIdleTestFailureStackTraceDefaultUser

public String sampleLastIdleTestFailureStackTraceDefaultUser()
                                                      throws SQLException

Specified by:

sampleLastIdleTestFailureStackTraceDefaultUser in interface PooledDataSource

Throws:

SQLException

sampleLastConnectionTestFailureStackTraceDefaultUser

public String sampleLastConnectionTestFailureStackTraceDefaultUser()
                                                            throws SQLException

Specified by:

sampleLastConnectionTestFailureStackTraceDefaultUser in interface PooledDataSource

Throws:

SQLException

sampleLastAcquisitionFailureStackTrace

public String sampleLastAcquisitionFailureStackTrace(String username,
 String password)
                                              throws SQLException

Specified by:

sampleLastAcquisitionFailureStackTrace in interface PooledDataSource

Throws:

SQLException

sampleLastCheckinFailureStackTrace

public String sampleLastCheckinFailureStackTrace(String username,
 String password)
                                          throws SQLException

Specified by:

sampleLastCheckinFailureStackTrace in interface PooledDataSource

Throws:

SQLException

sampleLastCheckoutFailureStackTrace

public String sampleLastCheckoutFailureStackTrace(String username,
 String password)
                                           throws SQLException

Specified by:

sampleLastCheckoutFailureStackTrace in interface PooledDataSource

Throws:

SQLException

sampleLastIdleTestFailureStackTrace

public String sampleLastIdleTestFailureStackTrace(String username,
 String password)
                                           throws SQLException

Specified by:

sampleLastIdleTestFailureStackTrace in interface PooledDataSource

Throws:

SQLException

sampleLastConnectionTestFailureStackTrace

public String sampleLastConnectionTestFailureStackTrace(String username,
 String password)
                                                 throws SQLException

Specified by:

sampleLastConnectionTestFailureStackTrace in interface PooledDataSource

Throws:

SQLException

softResetDefaultUser

public void softResetDefaultUser()
                          throws SQLException

Description copied from interface: PooledDataSource

Discards all Connections managed by the PooledDataSource's default-authentication pool and reacquires new Connections to populate. Current checked out Connections will still be valid, and should still be checked into the PooledDataSource (so the PooledDataSource can destroy them).

Specified by:

softResetDefaultUser in interface PooledDataSource

Throws:

SQLException

getNumConnections

public int getNumConnections(String username,
 String password)
                      throws SQLException

Specified by:

getNumConnections in interface PooledDataSource

Throws:

SQLException

getNumIdleConnections

public int getNumIdleConnections(String username,
 String password)
                          throws SQLException

Specified by:

getNumIdleConnections in interface PooledDataSource

Throws:

SQLException

getNumBusyConnections

public int getNumBusyConnections(String username,
 String password)
                          throws SQLException

Specified by:

getNumBusyConnections in interface PooledDataSource

Throws:

SQLException

getNumUnclosedOrphanedConnections

public int getNumUnclosedOrphanedConnections(String username,
 String password)
                                      throws SQLException

Specified by:

getNumUnclosedOrphanedConnections in interface PooledDataSource

Throws:

SQLException

getStatementCacheNumStatements

public int getStatementCacheNumStatements(String username,
 String password)
                                   throws SQLException

Specified by:

getStatementCacheNumStatements in interface PooledDataSource

Throws:

SQLException

getStatementCacheNumCheckedOut

public int getStatementCacheNumCheckedOut(String username,
 String password)
                                   throws SQLException

Specified by:

getStatementCacheNumCheckedOut in interface PooledDataSource

Throws:

SQLException

getStatementCacheNumConnectionsWithCachedStatements

public int getStatementCacheNumConnectionsWithCachedStatements(String username,
 String password)
                                                        throws SQLException

Specified by:

getStatementCacheNumConnectionsWithCachedStatements in interface PooledDataSource

Throws:

SQLException

getEffectivePropertyCycle

public float getEffectivePropertyCycle(String username,
 String password)
                                throws SQLException

Specified by:

getEffectivePropertyCycle in interface PooledDataSource

Throws:

SQLException

getStartTimeMillis

public long getStartTimeMillis(String username,
 String password)
                        throws SQLException

Throws:

SQLException

getUpTimeMillis

public long getUpTimeMillis(String username,
 String password)
                     throws SQLException

Throws:

SQLException

getNumFailedCheckins

public long getNumFailedCheckins(String username,
 String password)
                          throws SQLException

Throws:

SQLException

getNumFailedCheckouts

public long getNumFailedCheckouts(String username,
 String password)
                           throws SQLException

Throws:

SQLException

getNumFailedIdleTests

public long getNumFailedIdleTests(String username,
 String password)
                           throws SQLException

Throws:

SQLException

softReset

public void softReset(String username,
 String password)
               throws SQLException

Description copied from interface: PooledDataSource

Discards all Connections managed by the PooledDataSource with the specified authentication credentials and reacquires new Connections to populate. Current checked out Connections will still be valid, and should still be checked into the PooledDataSource (so the PooledDataSource can destroy them).

Specified by:

softReset in interface PooledDataSource

Throws:

SQLException

getNumBusyConnectionsAllUsers

public int getNumBusyConnectionsAllUsers()
                                  throws SQLException

Specified by:

getNumBusyConnectionsAllUsers in interface PooledDataSource

Throws:

SQLException

getNumIdleConnectionsAllUsers

public int getNumIdleConnectionsAllUsers()
                                  throws SQLException

Specified by:

getNumIdleConnectionsAllUsers in interface PooledDataSource

Throws:

SQLException

getNumConnectionsAllUsers

public int getNumConnectionsAllUsers()
                              throws SQLException

Specified by:

getNumConnectionsAllUsers in interface PooledDataSource

Throws:

SQLException

getNumUnclosedOrphanedConnectionsAllUsers

public int getNumUnclosedOrphanedConnectionsAllUsers()
                                              throws SQLException

Specified by:

getNumUnclosedOrphanedConnectionsAllUsers in interface PooledDataSource

Throws:

SQLException

getStatementCacheNumStatementsAllUsers

public int getStatementCacheNumStatementsAllUsers()
                                           throws SQLException

Specified by:

getStatementCacheNumStatementsAllUsers in interface PooledDataSource

Throws:

SQLException

getStatementCacheNumCheckedOutStatementsAllUsers

public int getStatementCacheNumCheckedOutStatementsAllUsers()
                                                     throws SQLException

Specified by:

getStatementCacheNumCheckedOutStatementsAllUsers in interface PooledDataSource

Throws:

SQLException

getStatementCacheNumConnectionsWithCachedStatementsAllUsers

public int getStatementCacheNumConnectionsWithCachedStatementsAllUsers()
                                                                throws SQLException

Specified by:

getStatementCacheNumConnectionsWithCachedStatementsAllUsers in interface PooledDataSource

Throws:

SQLException

getStatementDestroyerNumConnectionsInUseAllUsers

public int getStatementDestroyerNumConnectionsInUseAllUsers()
                                                     throws SQLException

Specified by:

getStatementDestroyerNumConnectionsInUseAllUsers in interface PooledDataSource

Throws:

SQLException

getStatementDestroyerNumConnectionsWithDeferredDestroyStatementsAllUsers

public int getStatementDestroyerNumConnectionsWithDeferredDestroyStatementsAllUsers()
                                                                             throws SQLException

Specified by:

getStatementDestroyerNumConnectionsWithDeferredDestroyStatementsAllUsers in interface PooledDataSource

Throws:

SQLException

getStatementDestroyerNumDeferredDestroyStatementsAllUsers

public int getStatementDestroyerNumDeferredDestroyStatementsAllUsers()
                                                              throws SQLException

Specified by:

getStatementDestroyerNumDeferredDestroyStatementsAllUsers in interface PooledDataSource

Throws:

SQLException

getStatementDestroyerNumConnectionsInUseDefaultUser

public int getStatementDestroyerNumConnectionsInUseDefaultUser()
                                                        throws SQLException

Specified by:

getStatementDestroyerNumConnectionsInUseDefaultUser in interface PooledDataSource

Throws:

SQLException

getStatementDestroyerNumConnectionsWithDeferredDestroyStatementsDefaultUser

public int getStatementDestroyerNumConnectionsWithDeferredDestroyStatementsDefaultUser()
                                                                                throws SQLException

Specified by:

getStatementDestroyerNumConnectionsWithDeferredDestroyStatementsDefaultUser in interface PooledDataSource

Throws:

SQLException

getStatementDestroyerNumDeferredDestroyStatementsDefaultUser

public int getStatementDestroyerNumDeferredDestroyStatementsDefaultUser()
                                                                 throws SQLException

Specified by:

getStatementDestroyerNumDeferredDestroyStatementsDefaultUser in interface PooledDataSource

Throws:

SQLException

getStatementDestroyerNumThreads

public int getStatementDestroyerNumThreads()
                                    throws SQLException

Specified by:

getStatementDestroyerNumThreads in interface PooledDataSource

Throws:

SQLException

getStatementDestroyerNumActiveThreads

public int getStatementDestroyerNumActiveThreads()
                                          throws SQLException

Specified by:

getStatementDestroyerNumActiveThreads in interface PooledDataSource

Throws:

SQLException

getStatementDestroyerNumIdleThreads

public int getStatementDestroyerNumIdleThreads()
                                        throws SQLException

Specified by:

getStatementDestroyerNumIdleThreads in interface PooledDataSource

Throws:

SQLException

getStatementDestroyerNumTasksPending

public int getStatementDestroyerNumTasksPending()
                                         throws SQLException

Specified by:

getStatementDestroyerNumTasksPending in interface PooledDataSource

Throws:

SQLException

getStatementDestroyerNumConnectionsInUse

public int getStatementDestroyerNumConnectionsInUse(String username,
 String password)
                                             throws SQLException

Specified by:

getStatementDestroyerNumConnectionsInUse in interface PooledDataSource

Throws:

SQLException

getStatementDestroyerNumConnectionsWithDeferredDestroyStatements

public int getStatementDestroyerNumConnectionsWithDeferredDestroyStatements(String username,
 String password)
                                                                     throws SQLException

Specified by:

getStatementDestroyerNumConnectionsWithDeferredDestroyStatements in interface PooledDataSource

Throws:

SQLException

getStatementDestroyerNumDeferredDestroyStatements

public int getStatementDestroyerNumDeferredDestroyStatements(String username,
 String password)
                                                      throws SQLException

Specified by:

getStatementDestroyerNumDeferredDestroyStatements in interface PooledDataSource

Throws:

SQLException

sampleStatementDestroyerStackTraces

public String sampleStatementDestroyerStackTraces()
                                           throws SQLException

Specified by:

sampleStatementDestroyerStackTraces in interface PooledDataSource

Throws:

SQLException

sampleStatementDestroyerStatus

public String sampleStatementDestroyerStatus()
                                      throws SQLException

Specified by:

sampleStatementDestroyerStatus in interface PooledDataSource

Throws:

SQLException

softResetAllUsers

public void softResetAllUsers()
                       throws SQLException

Description copied from interface: PooledDataSource

Discards all Connections managed by the PooledDataSource and reacquires new Connections to populate. Current checked out Connections will still be valid, and should still be checked into the PooledDataSource (so the PooledDataSource can destroy them).

Specified by:

softResetAllUsers in interface PooledDataSource

Throws:

SQLException

getNumUserPools

public int getNumUserPools()
                    throws SQLException

Specified by:

getNumUserPools in interface PooledDataSource

Throws:

SQLException

getAllUsers

public Collection getAllUsers()
                       throws SQLException

Specified by:

getAllUsers in interface PooledDataSource

Throws:

SQLException

hardReset

public void hardReset()

Description copied from interface: PooledDataSource

Destroys all pooled and checked-out Connections associated with this DataSource immediately. The PooledDataSource is reset to its initial state prior to first Connection acquisition, with no pools yet active, but ready for requests.

Specified by:

hardReset in interface PooledDataSource

close

public void close()

Description copied from interface: PooledDataSource

C3P0 pooled DataSources use no resources before they are actually used in a VM, and they close themselves in their finalize() method. When they are active and pooling, they may have open database connections and their pool may spawn several threads for its maintenance. You can use this method to clean these resource methods up quickly when you will no longer be using this DataSource. The resources will actually be cleaned up only if no other DataSources are sharing the same pool.

You can equivalently use the static method destroy() in the DataSources class to clean-up these resources.

This is equivalent to calling close( false ).

Specified by:

close in interface AutoCloseable

Specified by:

close in interface PooledDataSource

See Also:

• DataSources.destroy(DataSource)

close

public void close(boolean force_destroy)

Deprecated.

the force_destroy argument is now meaningless, as pools are no longer potentially shared between multiple DataSources.

Description copied from interface: PooledDataSource

Should be used only with great caution. If force_destroy is set to true, this immediately destroys any pool and cleans up all resources this DataSource may be using, even if other DataSources are sharing that pool! In general, it is difficult to know whether a pool is being shared by multiple DataSources. It may depend upon whether or not a JNDI implementation returns a single instance or multiple copies upon lookup (which is undefined by the JNDI spec).

In general, this method should be used only when you wish to wind down all c3p0 pools in a ClassLoader. For example, when shutting down and restarting a web application that uses c3p0, you may wish to kill all threads making use of classes loaded by a web-app specific ClassLoader, so that the ClassLoader can be cleanly garbage collected. In this case, you may wish to use force destroy. Otherwise, it is much safer to use the simple destroy() method, which will not shut down pools that may still be in use.

To close a pool normally, use the no argument close method, or set force_destroy to false.

Specified by:

close in interface PooledDataSource

See Also:

• PooledDataSource.close()

resetPoolManager

public void resetPoolManager()

resetPoolManager

public void resetPoolManager(boolean close_checked_out_connections)

toString

public abstract String toString(boolean show_config)

isWrapperForThis

protected final boolean isWrapperForThis(Class<?> iface)

isWrapperFor

public boolean isWrapperFor(Class<?> iface)
                     throws SQLException

Specified by:

isWrapperFor in interface Wrapper

Throws:

SQLException

unwrap

public <T> T unwrap(Class<T> iface)
             throws SQLException

Specified by:

unwrap in interface Wrapper

Throws:

SQLException