PooledConnection interface

The following table lists the methods of the PooledConnection interface.

Table 18-60 PooledConnection interface methods

Subsection	Method	Function
(a)	getConnection()	Establishes a physical connection when one is needed and returns a Connection object. There is a one-to-one correspondence between a Connection object and a physical connection with the HiRDB server.
(b)	addConnectionEventListener(ConnectionEventListener listener)	Registers a specified event listener so that events that occur in this PooledConnection object will be reported.
(c)	close()	Closes the physical connection.
(d)	removeConnectionEventListener(ConnectionEventListener listener)	Deletes from the component list a specified event listener that reports on events that occur in this PooledConnection object.

Function: Establishes a physical connection when one is needed and returns a Connection object. There is a one-to-one correspondence between a Connection object and a physical connection with the HiRDB server.

Format

 
public synchronized Connection getConnection() throws SQLException

Functional detail: This method establishes a physical connection when one is needed and returns a Connection object. There is a one-to-one correspondence between a Connection object and a physical connection with the HiRDB server. Once established, a physical connection is not closed until this class object is closed. This class object maintains the physical connection even if the close method is executed on the Connection object. This physical connection can then be used again the next time a connection request is issued by calling this method (the wait time specified in setLoginTimeout or the PDCONNECTWAITTIME client environment definition does not apply).

Exceptions

The JDBC driver throws an SQLException in the following cases:

Function: Registers a specified event listener so that events that occur in this PooledConnection object will be reported.

Format

 
public synchronized void addConnectionEventListener(ConnectionEventListener listener)

Arguments

ConnectionEventListener listener: Component that implements the ConnectionEventListener interface, so that if the connection is closed or an error occurs, that event will be reported. Normally, this is a connection pool management program.

Functional detail: This method registers a specified event listener so that events that occur in this PooledConnection object will be reported. If the listener to be added is null, this method does not register a listener.; This driver's method cannot be called from the event listener registered by the addConnectionEventListener method. If an attempt is made to call the driver's method, the driver might stop responding (due to a deadlock).

Format

 
public synchronized void close()

Functional detail: This method closes the physical connection for all pooled connections. The method attempts to close the physical connection by executing PooledConnection.close() even if a Connection object has been acquired and the database is being accessed.

Function: Deletes from the component list a specified event listener that reports on events that occur in this PooledConnection object.

Format

 
public synchronized void removeConnectionEventListener(ConnectionEventListener listener)

Arguments

ConnectionEventListenerlistener: Component registered as a listener by implementing the ConnectionEventListener interface. Normally, this is a connection pool management program.