|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--com.ibm.as400.access.AS400JDBCPooledConnection
The AS400JDBCPooledConnection class represents a connection object that provides hooks for connection pool management. The following example creates an AS400JDBCPooledConnection object that can be used to cache JDBC connections.
// Create a data source for making the connection. AS400JDBCConnectionPoolDataSource dataSource = new AS400JDBCConnectionPoolDataSource("myAS400"); datasource.setUser("Mickey Mouse"); datasource.setPassword("IAMNORAT"); // Get a PooledConnection and get the connection handle to the database. AS400JDBCPooledConnection pooledConnection = datasource.getPooledConnection(); Connection connection = pooledConnection.getConnection(); ... work with the connection handle. // Close the connection handle to make available for reuse (physical connection not closed). connection.close(); // Reuse the connection somewhere else. Connection reusedConnection = pooledConnection.getConnection(); ... work with the connection handle. reusedConnection.close(); // Close the physical connection. pooledConnection.close();
AS400JDBCPooledConnection objects generate the following events:
Method Summary | |
void |
addConnectionEventListener(javax.sql.ConnectionEventListener listener)
Adds a ConnectionEventListener. |
void |
close()
Closes the physical connection. |
void |
closeAll()
Closes all the Statement objects that have been opened by this PooledConnection object. |
java.sql.Connection |
getConnection()
Returns the connection handle to the database. |
long |
getInactivityTime()
Returns the elapsed time the connection has been idle waiting in the pool. |
long |
getInUseTime()
Returns the elapsed time the connection has been in use. |
long |
getLifeSpan()
Returns the elapsed time the pooled connection has been alive. |
int |
getUseCount()
Returns the number of times the pooled connection has been used. |
boolean |
isInUse()
Indicates if the pooled connection is in use. |
void |
removeConnectionEventListener(javax.sql.ConnectionEventListener listener)
Removes a ConnectionEventListener. |
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Method Detail |
public void addConnectionEventListener(javax.sql.ConnectionEventListener listener)
addConnectionEventListener
in interface javax.sql.PooledConnection
listener
- The listener.public void close() throws java.sql.SQLException
close
in interface javax.sql.PooledConnection
java.sql.SQLException
- If an error occurs closing the connection.public void closeAll() throws java.sql.SQLException
java.sql.SQLException
- Always thrown because this method is not supported.public java.sql.Connection getConnection() throws java.sql.SQLException
getConnection
in interface javax.sql.PooledConnection
java.sql.SQLException
- If a database error occurs.public long getInactivityTime()
public long getInUseTime()
public long getLifeSpan()
public int getUseCount()
public boolean isInUse()
public void removeConnectionEventListener(javax.sql.ConnectionEventListener listener)
removeConnectionEventListener
in interface javax.sql.PooledConnection
listener
- The listener to be removed.
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |