com.mchange.v2.c3p0
Interface PooledDataSource

All Superinterfaces:

javax.sql.DataSource

All Known Implementing Classes:

AbstractPoolBackedDataSource, ComboPooledDataSource, PoolBackedDataSource

public interface PooledDataSource
extends javax.sql.DataSource

Most clients need never use or know about this interface -- c3p0 pooled DataSources can be treated like any other DataSource.

The functionality in this interface will be only be of interest if 1) for administrative reasons you like to keep close track of the number and status of all Connections your application is using; 2) to work around problems encountered while managing a DataSource whose clients are poorly coded applications that leak Connections, but which you are not permitted to fix; or 3) to work around problems that may occur if an underlying jdbc driver / DBMS system is unreliable. In the third case, most users will be better off not using the present interface at all, and using the DataSources' maxIdleTime, idleConnectionTestPeriod, or testConnectionOnCheckout parameters to help your DataSources "automatically" heal. But for those who prefer a more direct, manual approach, this interface is for you. It is anticipated that the methods of this interface will primarily be of use to administrators managing c3p0 PooledDataSources via JMX MBeans.

Method Names & Per-User Pools

To understand this interface, you need to realize that a c3p0 PooledDataSource may represent not just one pool of Connections, but many, if users call the method Connection getConnection(String username, String password) rather than the no-argument getConnection() method. If users make use of non-default username, password combinations, there will be a separate pool for each set of authentification criteria supplied.

Many methods in this interface have three variants:

1. <method-name>DefaultUser()
2. <method-name>(String username, String password)
3. <method-name>AllUsers()

The first variant makes use of the pool maintained for the default user -- Connections created by calls to the no argument getConnection(), the second variant lets you keeps track of pools created by calling getConnection( username, password ), and the third variant provides aggregate information or performs operation on all pools.

Under most circumstances, non-default authentication credentials will not be used, and methods of the first variant are sufficient to manage the DataSource.

Soft and Hard Resets

A properly configured PooledDataSource whose applications are careful to close all checked-out Connections would never need to use these methods. But, sometimes applications are untrustworthy and leak Connections, or database administrators suspect that Connections may be corrupt or invalid, and would like to force a pool to flush and acquire fresh Connections. This interface provides two ways to do so.

1. hardReset() immediately closes all Connections managed by the DataSource, including those that are currently checked out, bringing the DataSource back to the state it was in before the first client called getConnection(). This method is obviously disruptive, and should be with great care. Administrators who need to work around client applications that leak Connections, can periodically poll for pool exhaustion (using the methods of this class, or by attempting to retrieve a Connection and timing out) and use this method clean-up all Connections and start over. But calling this method risks breaking Connections in current use by valid applications.
   
   
2. softResetDefaultUser(), softReset( username, password ) and softResetAllUsers() asks the DataSource to flush its current pool of Connections and reacquire without invalidating currently checked-out Connections. Currently checked out Connections are logically removed from the pool, but their destruction is deferred until a client attempts to close() / check-in the Connection. Administrators who suspect that some Connections in the pool may be invalid, but who do not wish to rely upon c3p0's automatic testing and detection mechanisms to resolve the problem, may call these methods to force a refresh without disrupting current clients. Administrators who suspect that clients may be leaking Connections may minimize disruptive hardReset() calls by using softReset() until the number of unclosed orphaned connections reaches an unacceptable level. (See above to understand why there are three variants of this method.)

Understanding Connection Counts

For each per-user pool, four different statistics are available:

1. numConnections represents the total number of Connections in the pool.
   
   
2. numIdleConnections represents the number of Connections in the pool that are currently available for checkout.
   
   
3. numBusyConnections represents the number of Connections in the pool that are currently checked out. The invariant numIdleConnections + numBusyConnections == numConnections should always hold.
   
   
4. numUnclosedOrphanedConnections will only be non-zero following a call to softReset(). It represents the number of Connections that were checked out when a soft reset occurred and were therefore silently excluded from the pool, and which remain unclosed by the client application.

Method Summary

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_destory) Deprecated. the force_destroy argument is now meaningless, as pools are no longer potentially shared between multiple DataSources.
java.util.Collection	getAllUsers()
java.lang.String	getDataSourceName()
float	getEffectivePropertyCycle(java.lang.String username, java.lang.String password)
float	getEffectivePropertyCycleDefaultUser()
java.lang.String	getIdentityToken()
java.lang.Throwable	getLastAcquisitionFailure(java.lang.String username, java.lang.String password)
java.lang.Throwable	getLastAcquisitionFailureDefaultUser()
java.lang.Throwable	getLastCheckinFailure(java.lang.String username, java.lang.String password)
java.lang.Throwable	getLastCheckinFailureDefaultUser()
java.lang.Throwable	getLastCheckoutFailure(java.lang.String username, java.lang.String password)
java.lang.Throwable	getLastCheckoutFailureDefaultUser()
java.lang.Throwable	getLastConnectionTestFailure(java.lang.String username, java.lang.String password)
java.lang.Throwable	getLastConnectionTestFailureDefaultUser()
java.lang.Throwable	getLastIdleTestFailure(java.lang.String username, java.lang.String password)
java.lang.Throwable	getLastIdleTestFailureDefaultUser()
int	getNumBusyConnections() Deprecated. use getNumBusyConnectionsDefaultUser()
int	getNumBusyConnections(java.lang.String username, java.lang.String password)
int	getNumBusyConnectionsAllUsers()
int	getNumBusyConnectionsDefaultUser()
int	getNumConnections() Deprecated. use getNumConnectionsDefaultUser()
int	getNumConnections(java.lang.String username, java.lang.String password)
int	getNumConnectionsAllUsers()
int	getNumConnectionsDefaultUser()
long	getNumFailedCheckinsDefaultUser()
long	getNumFailedCheckoutsDefaultUser()
long	getNumFailedIdleTestsDefaultUser()
int	getNumHelperThreads()
int	getNumIdleConnections() Deprecated. use getNumIdleConnectionsDefaultUser()
int	getNumIdleConnections(java.lang.String username, java.lang.String password)
int	getNumIdleConnectionsAllUsers()
int	getNumIdleConnectionsDefaultUser()
int	getNumThreadsAwaitingCheckout(java.lang.String username, java.lang.String password)
int	getNumThreadsAwaitingCheckoutDefaultUser()
int	getNumUnclosedOrphanedConnections() Deprecated. use getNumUnclosedOrphanedConnectionsDefaultUser()
int	getNumUnclosedOrphanedConnections(java.lang.String username, java.lang.String password)
int	getNumUnclosedOrphanedConnectionsAllUsers()
int	getNumUnclosedOrphanedConnectionsDefaultUser()
int	getNumUserPools()
long	getStartTimeMillisDefaultUser()
int	getStatementCacheNumCheckedOut(java.lang.String username, java.lang.String password)
int	getStatementCacheNumCheckedOutDefaultUser()
int	getStatementCacheNumCheckedOutStatementsAllUsers()
int	getStatementCacheNumConnectionsWithCachedStatements(java.lang.String username, java.lang.String password)
int	getStatementCacheNumConnectionsWithCachedStatementsAllUsers()
int	getStatementCacheNumConnectionsWithCachedStatementsDefaultUser()
int	getStatementCacheNumStatements(java.lang.String username, java.lang.String password)
int	getStatementCacheNumStatementsAllUsers()
int	getStatementCacheNumStatementsDefaultUser()
int	getStatementDestroyerNumActiveThreads()
int	getStatementDestroyerNumConnectionsInUse(java.lang.String username, java.lang.String password)
int	getStatementDestroyerNumConnectionsInUseAllUsers()
int	getStatementDestroyerNumConnectionsInUseDefaultUser()
int	getStatementDestroyerNumConnectionsWithDeferredDestroyStatements(java.lang.String username, java.lang.String password)
int	getStatementDestroyerNumConnectionsWithDeferredDestroyStatementsAllUsers()
int	getStatementDestroyerNumConnectionsWithDeferredDestroyStatementsDefaultUser()
int	getStatementDestroyerNumDeferredDestroyStatements(java.lang.String username, java.lang.String password)
int	getStatementDestroyerNumDeferredDestroyStatementsAllUsers()
int	getStatementDestroyerNumDeferredDestroyStatementsDefaultUser()
int	getStatementDestroyerNumIdleThreads()
int	getStatementDestroyerNumTasksPending()
int	getStatementDestroyerNumThreads()
int	getThreadPoolNumActiveThreads()
int	getThreadPoolNumIdleThreads()
int	getThreadPoolNumTasksPending()
int	getThreadPoolSize()
long	getUpTimeMillisDefaultUser()
void	hardReset() Destroys all pooled and checked-out Connections associated with this DataSource immediately.
java.lang.String	sampleLastAcquisitionFailureStackTrace(java.lang.String username, java.lang.String password)
java.lang.String	sampleLastAcquisitionFailureStackTraceDefaultUser()
java.lang.String	sampleLastCheckinFailureStackTrace(java.lang.String username, java.lang.String password)
java.lang.String	sampleLastCheckinFailureStackTraceDefaultUser()
java.lang.String	sampleLastCheckoutFailureStackTrace(java.lang.String username, java.lang.String password)
java.lang.String	sampleLastCheckoutFailureStackTraceDefaultUser()
java.lang.String	sampleLastConnectionTestFailureStackTrace(java.lang.String username, java.lang.String password)
java.lang.String	sampleLastConnectionTestFailureStackTraceDefaultUser()
java.lang.String	sampleLastIdleTestFailureStackTrace(java.lang.String username, java.lang.String password)
java.lang.String	sampleLastIdleTestFailureStackTraceDefaultUser()
java.lang.String	sampleStatementCacheStatus(java.lang.String username, java.lang.String password)
java.lang.String	sampleStatementCacheStatusDefaultUser()
java.lang.String	sampleStatementDestroyerStackTraces()
java.lang.String	sampleStatementDestroyerStatus()
java.lang.String	sampleThreadPoolStackTraces()
java.lang.String	sampleThreadPoolStatus()
void	setDataSourceName(java.lang.String dataSourceName)
void	softReset(java.lang.String username, java.lang.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.

Methods inherited from interface javax.sql.DataSource

getConnection, getConnection, getLoginTimeout, getLogWriter, setLoginTimeout, setLogWriter

Method Detail

getIdentityToken

java.lang.String getIdentityToken()

getDataSourceName

java.lang.String getDataSourceName()

setDataSourceName

void setDataSourceName(java.lang.String dataSourceName)

getNumConnections

int getNumConnections()
                      throws java.sql.SQLException

Deprecated. use getNumConnectionsDefaultUser()

Throws:

java.sql.SQLException

getNumIdleConnections

int getNumIdleConnections()
                          throws java.sql.SQLException

Deprecated. use getNumIdleConnectionsDefaultUser()

Throws:

java.sql.SQLException

getNumBusyConnections

int getNumBusyConnections()
                          throws java.sql.SQLException

Deprecated. use getNumBusyConnectionsDefaultUser()

Throws:

java.sql.SQLException

getNumUnclosedOrphanedConnections

int getNumUnclosedOrphanedConnections()
                                      throws java.sql.SQLException

Deprecated. use getNumUnclosedOrphanedConnectionsDefaultUser()

Throws:

java.sql.SQLException

getNumConnectionsDefaultUser

int getNumConnectionsDefaultUser()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getNumIdleConnectionsDefaultUser

int getNumIdleConnectionsDefaultUser()
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getNumBusyConnectionsDefaultUser

int getNumBusyConnectionsDefaultUser()
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getNumUnclosedOrphanedConnectionsDefaultUser

int getNumUnclosedOrphanedConnectionsDefaultUser()
                                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementCacheNumStatementsDefaultUser

int getStatementCacheNumStatementsDefaultUser()
                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementCacheNumCheckedOutDefaultUser

int getStatementCacheNumCheckedOutDefaultUser()
                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementCacheNumConnectionsWithCachedStatementsDefaultUser

int getStatementCacheNumConnectionsWithCachedStatementsDefaultUser()
                                                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getStartTimeMillisDefaultUser

long getStartTimeMillisDefaultUser()
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getUpTimeMillisDefaultUser

long getUpTimeMillisDefaultUser()
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

getNumFailedCheckinsDefaultUser

long getNumFailedCheckinsDefaultUser()
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getNumFailedCheckoutsDefaultUser

long getNumFailedCheckoutsDefaultUser()
                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getNumFailedIdleTestsDefaultUser

long getNumFailedIdleTestsDefaultUser()
                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getEffectivePropertyCycleDefaultUser

float getEffectivePropertyCycleDefaultUser()
                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getNumThreadsAwaitingCheckoutDefaultUser

int getNumThreadsAwaitingCheckoutDefaultUser()
                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

softResetDefaultUser

void softResetDefaultUser()
                          throws java.sql.SQLException

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).

Throws:

java.sql.SQLException

getNumConnections

int getNumConnections(java.lang.String username,
                      java.lang.String password)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getNumIdleConnections

int getNumIdleConnections(java.lang.String username,
                          java.lang.String password)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getNumBusyConnections

int getNumBusyConnections(java.lang.String username,
                          java.lang.String password)
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getNumUnclosedOrphanedConnections

int getNumUnclosedOrphanedConnections(java.lang.String username,
                                      java.lang.String password)
                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementCacheNumStatements

int getStatementCacheNumStatements(java.lang.String username,
                                   java.lang.String password)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementCacheNumCheckedOut

int getStatementCacheNumCheckedOut(java.lang.String username,
                                   java.lang.String password)
                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementCacheNumConnectionsWithCachedStatements

int getStatementCacheNumConnectionsWithCachedStatements(java.lang.String username,
                                                        java.lang.String password)
                                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getEffectivePropertyCycle

float getEffectivePropertyCycle(java.lang.String username,
                                java.lang.String password)
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

getNumThreadsAwaitingCheckout

int getNumThreadsAwaitingCheckout(java.lang.String username,
                                  java.lang.String password)
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

softReset

void softReset(java.lang.String username,
               java.lang.String password)
               throws java.sql.SQLException

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).

Throws:

java.sql.SQLException

getNumBusyConnectionsAllUsers

int getNumBusyConnectionsAllUsers()
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

getNumIdleConnectionsAllUsers

int getNumIdleConnectionsAllUsers()
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

getNumConnectionsAllUsers

int getNumConnectionsAllUsers()
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getNumUnclosedOrphanedConnectionsAllUsers

int getNumUnclosedOrphanedConnectionsAllUsers()
                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementCacheNumStatementsAllUsers

int getStatementCacheNumStatementsAllUsers()
                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementCacheNumCheckedOutStatementsAllUsers

int getStatementCacheNumCheckedOutStatementsAllUsers()
                                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementCacheNumConnectionsWithCachedStatementsAllUsers

int getStatementCacheNumConnectionsWithCachedStatementsAllUsers()
                                                                throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementDestroyerNumConnectionsInUseAllUsers

int getStatementDestroyerNumConnectionsInUseAllUsers()
                                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementDestroyerNumConnectionsWithDeferredDestroyStatementsAllUsers

int getStatementDestroyerNumConnectionsWithDeferredDestroyStatementsAllUsers()
                                                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementDestroyerNumDeferredDestroyStatementsAllUsers

int getStatementDestroyerNumDeferredDestroyStatementsAllUsers()
                                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getThreadPoolSize

int getThreadPoolSize()
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getThreadPoolNumActiveThreads

int getThreadPoolNumActiveThreads()
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

getThreadPoolNumIdleThreads

int getThreadPoolNumIdleThreads()
                                throws java.sql.SQLException

Throws:

java.sql.SQLException

getThreadPoolNumTasksPending

int getThreadPoolNumTasksPending()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementDestroyerNumThreads

int getStatementDestroyerNumThreads()
                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementDestroyerNumActiveThreads

int getStatementDestroyerNumActiveThreads()
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementDestroyerNumIdleThreads

int getStatementDestroyerNumIdleThreads()
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementDestroyerNumTasksPending

int getStatementDestroyerNumTasksPending()
                                         throws java.sql.SQLException

Throws:

java.sql.SQLException

sampleThreadPoolStackTraces

java.lang.String sampleThreadPoolStackTraces()
                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

sampleThreadPoolStatus

java.lang.String sampleThreadPoolStatus()
                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

sampleStatementDestroyerStackTraces

java.lang.String sampleStatementDestroyerStackTraces()
                                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

sampleStatementDestroyerStatus

java.lang.String sampleStatementDestroyerStatus()
                                                throws java.sql.SQLException

Throws:

java.sql.SQLException

sampleStatementCacheStatusDefaultUser

java.lang.String sampleStatementCacheStatusDefaultUser()
                                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

sampleStatementCacheStatus

java.lang.String sampleStatementCacheStatus(java.lang.String username,
                                            java.lang.String password)
                                            throws java.sql.SQLException

Throws:

java.sql.SQLException

getLastAcquisitionFailureDefaultUser

java.lang.Throwable getLastAcquisitionFailureDefaultUser()
                                                         throws java.sql.SQLException

Throws:

java.sql.SQLException

getLastCheckinFailureDefaultUser

java.lang.Throwable getLastCheckinFailureDefaultUser()
                                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getLastCheckoutFailureDefaultUser

java.lang.Throwable getLastCheckoutFailureDefaultUser()
                                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getLastIdleTestFailureDefaultUser

java.lang.Throwable getLastIdleTestFailureDefaultUser()
                                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

getLastConnectionTestFailureDefaultUser

java.lang.Throwable getLastConnectionTestFailureDefaultUser()
                                                            throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementDestroyerNumConnectionsInUseDefaultUser

int getStatementDestroyerNumConnectionsInUseDefaultUser()
                                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementDestroyerNumConnectionsWithDeferredDestroyStatementsDefaultUser

int getStatementDestroyerNumConnectionsWithDeferredDestroyStatementsDefaultUser()
                                                                                throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementDestroyerNumDeferredDestroyStatementsDefaultUser

int getStatementDestroyerNumDeferredDestroyStatementsDefaultUser()
                                                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getLastAcquisitionFailure

java.lang.Throwable getLastAcquisitionFailure(java.lang.String username,
                                              java.lang.String password)
                                              throws java.sql.SQLException

Throws:

java.sql.SQLException

getLastCheckinFailure

java.lang.Throwable getLastCheckinFailure(java.lang.String username,
                                          java.lang.String password)
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

getLastCheckoutFailure

java.lang.Throwable getLastCheckoutFailure(java.lang.String username,
                                           java.lang.String password)
                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getLastIdleTestFailure

java.lang.Throwable getLastIdleTestFailure(java.lang.String username,
                                           java.lang.String password)
                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

getLastConnectionTestFailure

java.lang.Throwable getLastConnectionTestFailure(java.lang.String username,
                                                 java.lang.String password)
                                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementDestroyerNumConnectionsInUse

int getStatementDestroyerNumConnectionsInUse(java.lang.String username,
                                             java.lang.String password)
                                             throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementDestroyerNumConnectionsWithDeferredDestroyStatements

int getStatementDestroyerNumConnectionsWithDeferredDestroyStatements(java.lang.String username,
                                                                     java.lang.String password)
                                                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

getStatementDestroyerNumDeferredDestroyStatements

int getStatementDestroyerNumDeferredDestroyStatements(java.lang.String username,
                                                      java.lang.String password)
                                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

sampleLastAcquisitionFailureStackTraceDefaultUser

java.lang.String sampleLastAcquisitionFailureStackTraceDefaultUser()
                                                                   throws java.sql.SQLException

Throws:

java.sql.SQLException

sampleLastCheckinFailureStackTraceDefaultUser

java.lang.String sampleLastCheckinFailureStackTraceDefaultUser()
                                                               throws java.sql.SQLException

Throws:

java.sql.SQLException

sampleLastCheckoutFailureStackTraceDefaultUser

java.lang.String sampleLastCheckoutFailureStackTraceDefaultUser()
                                                                throws java.sql.SQLException

Throws:

java.sql.SQLException

sampleLastIdleTestFailureStackTraceDefaultUser

java.lang.String sampleLastIdleTestFailureStackTraceDefaultUser()
                                                                throws java.sql.SQLException

Throws:

java.sql.SQLException

sampleLastConnectionTestFailureStackTraceDefaultUser

java.lang.String sampleLastConnectionTestFailureStackTraceDefaultUser()
                                                                      throws java.sql.SQLException

Throws:

java.sql.SQLException

sampleLastAcquisitionFailureStackTrace

java.lang.String sampleLastAcquisitionFailureStackTrace(java.lang.String username,
                                                        java.lang.String password)
                                                        throws java.sql.SQLException

Throws:

java.sql.SQLException

sampleLastCheckinFailureStackTrace

java.lang.String sampleLastCheckinFailureStackTrace(java.lang.String username,
                                                    java.lang.String password)
                                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

sampleLastCheckoutFailureStackTrace

java.lang.String sampleLastCheckoutFailureStackTrace(java.lang.String username,
                                                     java.lang.String password)
                                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

sampleLastIdleTestFailureStackTrace

java.lang.String sampleLastIdleTestFailureStackTrace(java.lang.String username,
                                                     java.lang.String password)
                                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

sampleLastConnectionTestFailureStackTrace

java.lang.String sampleLastConnectionTestFailureStackTrace(java.lang.String username,
                                                           java.lang.String password)
                                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

softResetAllUsers

void softResetAllUsers()
                       throws java.sql.SQLException

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).

Throws:

java.sql.SQLException

getNumUserPools

int getNumUserPools()
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

getNumHelperThreads

int getNumHelperThreads()
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

getAllUsers

java.util.Collection getAllUsers()
                                 throws java.sql.SQLException

Throws:

java.sql.SQLException

hardReset

void hardReset()
               throws java.sql.SQLException

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.

Throws:

java.sql.SQLException

close

void close()
           throws java.sql.SQLException

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 ).

Throws:

java.sql.SQLException

See Also:

DataSources.destroy(javax.sql.DataSource)

close

void close(boolean force_destory)
           throws java.sql.SQLException

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

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.

Throws:

java.sql.SQLException

See Also:

close()