-
- All Known Subinterfaces:
- XAConnection
public interface PooledConnection
An object that provides hooks for connection pool management. APooledConnection
object represents a physical connection to a data source. The connection can be recycled rather than being closed when an application is finished with it, thus reducing the number of connections that need to be made.An application programmer does not use the
PooledConnection
interface directly; rather, it is used by a middle tier infrastructure that manages the pooling of connections.When an application calls the method
DataSource.getConnection
, it gets back aConnection
object. If connection pooling is being done, thatConnection
object is actually a handle to aPooledConnection
object, which is a physical connection.The connection pool manager, typically the application server, maintains a pool of
PooledConnection
objects. If there is aPooledConnection
object available in the pool, the connection pool manager returns aConnection
object that is a handle to that physical connection. If noPooledConnection
object is available, the connection pool manager calls theConnectionPoolDataSource
methodgetPoolConnection
to create a new physical connection. The JDBC driver implementingConnectionPoolDataSource
creates a newPooledConnection
object and returns a handle to it.When an application closes a connection, it calls the
Connection
methodclose
. When connection pooling is being done, the connection pool manager is notified because it has registered itself as aConnectionEventListener
object using theConnectionPool
methodaddConnectionEventListener
. The connection pool manager deactivates the handle to thePooledConnection
object and returns thePooledConnection
object to the pool of connections so that it can be used again. Thus, when an application closes its connection, the underlying physical connection is recycled rather than being closed.The physical connection is not closed until the connection pool manager calls the
PooledConnection
methodclose
. This method is generally called to have an orderly shutdown of the server or if a fatal error has made the connection unusable.A connection pool manager is often also a statement pool manager, maintining a pool of
PreparedStatement
objects. When an application closes a prepared statement, it calls thePreparedStatement
methodclose
. WhenStatement
pooling is being done, the pool manager is notified because it has registered itself as aStatementEventListener
object using theConnectionPool
methodaddStatementEventListener
. Thus, when an application closes itsPreparedStatement
, the underlying prepared statement is recycled rather than being closed.- Since:
- 1.4
-
-
Method Summary
Methods Modifier and Type Method and Description void
addConnectionEventListener(ConnectionEventListener listener)
Registers the given event listener so that it will be notified when an event occurs on thisPooledConnection
object.void
addStatementEventListener(StatementEventListener listener)
Registers aStatementEventListener
with thisPooledConnection
object.void
close()
Closes the physical connection that thisPooledConnection
object represents.Connection
getConnection()
Creates and returns aConnection
object that is a handle for the physical connection that thisPooledConnection
object represents.void
removeConnectionEventListener(ConnectionEventListener listener)
Removes the given event listener from the list of components that will be notified when an event occurs on thisPooledConnection
object.void
removeStatementEventListener(StatementEventListener listener)
Removes the specifiedStatementEventListener
from the list of components that will be notified when the driver detects that aPreparedStatement
has been closed or is invalid.
-
-
-
Method Detail
-
getConnection
Connection getConnection() throws SQLException
Creates and returns aConnection
object that is a handle for the physical connection that thisPooledConnection
object represents. The connection pool manager calls this method when an application has called the methodDataSource.getConnection
and there are noPooledConnection
objects available. See theinterface description
for more information.- Returns:
- a
Connection
object that is a handle to thisPooledConnection
object - Throws:
SQLException
- if a database access error occursSQLFeatureNotSupportedException
- if the JDBC driver does not support this method- Since:
- 1.4
-
close
void close() throws SQLException
Closes the physical connection that thisPooledConnection
object represents. An application never calls this method directly; it is called by the connection pool module, or manager.See the
interface description
for more information.- Throws:
SQLException
- if a database access error occursSQLFeatureNotSupportedException
- if the JDBC driver does not support this method- Since:
- 1.4
-
addConnectionEventListener
void addConnectionEventListener(ConnectionEventListener listener)
Registers the given event listener so that it will be notified when an event occurs on thisPooledConnection
object.- Parameters:
listener
- a component, usually the connection pool manager, that has implemented theConnectionEventListener
interface and wants to be notified when the connection is closed or has an error- See Also:
removeConnectionEventListener(javax.sql.ConnectionEventListener)
-
removeConnectionEventListener
void removeConnectionEventListener(ConnectionEventListener listener)
Removes the given event listener from the list of components that will be notified when an event occurs on thisPooledConnection
object.- Parameters:
listener
- a component, usually the connection pool manager, that has implemented theConnectionEventListener
interface and been registered with thisPooledConnection
object as a listener- See Also:
addConnectionEventListener(javax.sql.ConnectionEventListener)
-
addStatementEventListener
void addStatementEventListener(StatementEventListener listener)
Registers aStatementEventListener
with thisPooledConnection
object. Components that wish to be notified whenPreparedStatement
s created by the connection are closed or are detected to be invalid may use this method to register aStatementEventListener
with thisPooledConnection
object.- Parameters:
listener
- an component which implements theStatementEventListener
interface that is to be registered with thisPooledConnection
object- Since:
- 1.6
-
removeStatementEventListener
void removeStatementEventListener(StatementEventListener listener)
Removes the specifiedStatementEventListener
from the list of components that will be notified when the driver detects that aPreparedStatement
has been closed or is invalid.- Parameters:
listener
- the component which implements theStatementEventListener
interface that was previously registered with thisPooledConnection
object- Since:
- 1.6
-
-
Deutsche Übersetzung
Sie haben gebeten, diese Seite auf Deutsch zu besuchen. Momentan ist nur die Oberfläche übersetzt, aber noch nicht der gesamte Inhalt.Wenn Sie mir bei Übersetzungen helfen wollen, ist Ihr Beitrag willkommen. Alles, was Sie tun müssen, ist, sich auf der Website zu registrieren und mir eine Nachricht zu schicken, in der Sie gebeten werden, Sie der Gruppe der Übersetzer hinzuzufügen, die Ihnen die Möglichkeit gibt, die gewünschten Seiten zu übersetzen. Ein Link am Ende jeder übersetzten Seite zeigt an, dass Sie der Übersetzer sind und einen Link zu Ihrem Profil haben.
Vielen Dank im Voraus.
Dokument erstellt 11/06/2005, zuletzt geändert 04/03/2020
Quelle des gedruckten Dokuments:https://www.gaudry.be/de/java-api-rf-javax/sql/pooledconnection.html
Die Infobro ist eine persönliche Seite, deren Inhalt in meiner alleinigen Verantwortung liegt. Der Text ist unter der CreativeCommons-Lizenz (BY-NC-SA) verfügbar. Weitere Informationen auf die Nutzungsbedingungen und dem Autor.
Referenzen
Diese Verweise und Links verweisen auf Dokumente, die während des Schreibens dieser Seite konsultiert wurden, oder die zusätzliche Informationen liefern können, aber die Autoren dieser Quellen können nicht für den Inhalt dieser Seite verantwortlich gemacht werden.
Der Autor Diese Website ist allein dafür verantwortlich, wie die verschiedenen Konzepte und Freiheiten, die mit den Nachschlagewerken gemacht werden, hier dargestellt werden. Denken Sie daran, dass Sie mehrere Quellinformationen austauschen müssen, um das Risiko von Fehlern zu reduzieren.