org.firebirdsql.pool

Class AbstractPingablePooledConnection

java.lang.Object

org.firebirdsql.pool.AbstractPingablePooledConnection

All Implemented Interfaces:

javax.sql.PooledConnection, PooledObject, XStatementManager

Direct Known Subclasses:

PingablePooledConnection

Deprecated.

@Deprecated
public abstract class AbstractPingablePooledConnection
extends java.lang.Object
implements javax.sql.PooledConnection, PooledObject, XStatementManager

This class implements PooledConnection interface.

Author:

Roman Rokytskyy

Field Summary

Fields

Modifier and Type	Field and Description
protected java.sql.Connection	jdbcConnection Deprecated.

Fields inherited from interface org.firebirdsql.pool.PooledObject

INSTANT_IN_USE

Constructor Summary

Constructors

Modifier	Constructor and Description
protected	AbstractPingablePooledConnection(java.sql.Connection connection, boolean statementPooling, int maxStatements, boolean keepStatements, org.firebirdsql.pool.PooledConnectionQueue owningQueue) Deprecated.
protected	AbstractPingablePooledConnection(java.sql.Connection connection, java.lang.String pingStatement, int pingInterval, boolean statementPooling, int maxStatements, boolean keepStatements, org.firebirdsql.pool.PooledConnectionQueue owningQueue) Deprecated.

Method Summary

Modifier and Type	Method and Description
void	addConnectionEventListener(javax.sql.ConnectionEventListener listener) Deprecated. Add connection listener to be notified about connection events.
void	close() Deprecated. Close this pooled connection.
protected void	configureConnectionDefaults(java.sql.Connection connection) Deprecated. Configure default values for this connection.
void	connectionClosed(org.firebirdsql.pool.PooledConnectionHandler connection) Deprecated. Notify connection owner about invocation of the Connection.close() operation on PooledConnectionHandler instance.
void	connectionCommitted(org.firebirdsql.pool.PooledConnectionHandler connection) Deprecated. Notify this class that transaction was committed.
void	connectionErrorOccured(org.firebirdsql.pool.PooledConnectionHandler connection, java.sql.SQLException ex) Deprecated. Notify connection owner about the SQLException that happened during method invocation on the wrapped connection.
void	connectionRolledBack(org.firebirdsql.pool.PooledConnectionHandler connection) Deprecated. Notify this class that transaction was rolled back.
void	deallocate() Deprecated. Deallocate this object.
java.sql.Connection	getConnection() Deprecated. Get JDBC connection corresponding to this pooled connection instance.
long	getInstantInPool() Deprecated.
long	getLastPingTime() Deprecated. Get the time when connection was pinged last time.
protected org.firebirdsql.logging.Logger	getLogChannel() Deprecated.
org.firebirdsql.pool.PooledConnectionQueue	getOwningQueue() Deprecated.
java.sql.PreparedStatement	getPreparedStatement(java.lang.String statement, int[] keyIndexes, java.lang.String[] keyColumns) Deprecated. Prepare specified SQL statement that will return the generated keys.
java.sql.PreparedStatement	getPreparedStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency) Deprecated. Get instance of PreparedStatement for the specified SQL statement.
java.sql.PreparedStatement	getPreparedStatement(java.lang.String statement, int resultSetType, int resultSetConcurrency, int resultSetHoldability) Deprecated. Handle Connection.prepareStatement(String) method call.
protected void	internalClose() Deprecated. Close this connection.
boolean	isInPool() Deprecated. Check whether this object is currently in pool or had been released to the application.
boolean	isKeepStatements() Deprecated.
protected boolean	isRollbackAllowed() Deprecated. Is calling rollback on the physical connection allowed when the logical connection close is signalled.
boolean	isStatementPooling() Deprecated.
boolean	isValid() Deprecated. Check if this pooled connection is still valid.
boolean	isValid(org.firebirdsql.pool.PooledConnectionHandler connection) Deprecated. Check if specified connection is still valid.
boolean	ping() Deprecated. Ping connection by executing a ping statement.
org.firebirdsql.pool.XCachablePreparedStatement	prepareStatement(java.lang.String sql, int resultSetType, int resultSetConcurrency, boolean cached) Deprecated. use prepareStatement(XPreparedStatementModel, boolean) instead.
org.firebirdsql.pool.XCachablePreparedStatement	prepareStatement(XPreparedStatementModel key, boolean cached) Deprecated. Prepare the specified statement and wrap it with cache notification wrapper.
void	removeConnectionEventListener(javax.sql.ConnectionEventListener listener) Deprecated. Remove connection listener from this pooled connection.
void	setDefaultTransactionIsolation(int isolation) Deprecated.
void	setInPool(boolean inPool) Deprecated. Set the "inPool" flag to this object.
void	statementClosed(java.lang.String sql, java.lang.Object proxy) Deprecated. Notify about statement close.
void	statementClosed(XPreparedStatementModel key, java.lang.Object proxy) Deprecated. Handle Statement.close() method.

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface javax.sql.PooledConnection

addStatementEventListener, removeStatementEventListener

Field Detail

jdbcConnection

protected java.sql.Connection jdbcConnection

Deprecated.

Constructor Detail

AbstractPingablePooledConnection

protected AbstractPingablePooledConnection(java.sql.Connection connection,
                                           boolean statementPooling,
                                           int maxStatements,
                                           boolean keepStatements,
                                           org.firebirdsql.pool.PooledConnectionQueue owningQueue)
                                    throws java.sql.SQLException

Deprecated.

Throws:

java.sql.SQLException

AbstractPingablePooledConnection

protected AbstractPingablePooledConnection(java.sql.Connection connection,
                                           java.lang.String pingStatement,
                                           int pingInterval,
                                           boolean statementPooling,
                                           int maxStatements,
                                           boolean keepStatements,
                                           org.firebirdsql.pool.PooledConnectionQueue owningQueue)
                                    throws java.sql.SQLException

Deprecated.

Throws:

java.sql.SQLException

Method Detail

getLogChannel

protected org.firebirdsql.logging.Logger getLogChannel()

Deprecated.

setDefaultTransactionIsolation

public void setDefaultTransactionIsolation(int isolation)

Deprecated.

getLastPingTime

public long getLastPingTime()

Deprecated.

Get the time when connection was pinged last time.

Returns:

time when connection was pinged last time.

isStatementPooling

public boolean isStatementPooling()

Deprecated.

isKeepStatements

public boolean isKeepStatements()

Deprecated.

ping

public boolean ping()

Deprecated.

Ping connection by executing a ping statement.

Returns:

true if connection was successfully pinged.

isValid

public boolean isValid()

Deprecated.

Check if this pooled connection is still valid.

Specified by:

isValid in interface PooledObject

Returns:

true if this pooled connection is still valid.

isInPool

public boolean isInPool()

Deprecated.

Check whether this object is currently in pool or had been released to the application.

Specified by:

isInPool in interface PooledObject

Returns:

true if the object is currently in pool.

setInPool

public void setInPool(boolean inPool)

Deprecated.

Set the "inPool" flag to this object. This method should be called only by the pool implementation.

Specified by:

setInPool in interface PooledObject

Parameters:

inPool - true if object is in pool, otherwise false.

getInstantInPool

public long getInstantInPool()

Deprecated.

Specified by:

getInstantInPool in interface PooledObject

Returns:

The instant in time when this object was last used, or PooledObject.INSTANT_IN_USE when object is currently in use.

addConnectionEventListener

public void addConnectionEventListener(javax.sql.ConnectionEventListener listener)

Deprecated.

Add connection listener to be notified about connection events.

Specified by:

addConnectionEventListener in interface javax.sql.PooledConnection

Parameters:

listener - listener to add.

removeConnectionEventListener

public void removeConnectionEventListener(javax.sql.ConnectionEventListener listener)

Deprecated.

Remove connection listener from this pooled connection.

Specified by:

removeConnectionEventListener in interface javax.sql.PooledConnection

Parameters:

listener - listener to remove.

close

public void close()
           throws java.sql.SQLException

Deprecated.

Close this pooled connection. This operation closes physical connection to the database. Should not be called by applications directly.

Specified by:

close in interface javax.sql.PooledConnection

Throws:

java.sql.SQLException

internalClose

protected void internalClose()
                      throws java.sql.SQLException

Deprecated.

Close this connection.

Throws:

java.sql.SQLException - if something went wrong.

deallocate

public void deallocate()

Deprecated.

Deallocate this object.

Specified by:

deallocate in interface PooledObject

getConnection

public java.sql.Connection getConnection()
                                  throws java.sql.SQLException

Deprecated.

Get JDBC connection corresponding to this pooled connection instance.

Specified by:

getConnection in interface javax.sql.PooledConnection

Returns:

instance of Connection

Throws:

java.sql.SQLException - if some error happened.

configureConnectionDefaults

protected void configureConnectionDefaults(java.sql.Connection connection)
                                    throws java.sql.SQLException

Deprecated.

Configure default values for this connection.

Parameters:

connection - instance of Connection to configure.

Throws:

java.sql.SQLException - if something went wrong.

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement(java.lang.String statement,
                                                       int resultSetType,
                                                       int resultSetConcurrency,
                                                       int resultSetHoldability)
                                                throws java.sql.SQLException

Deprecated.

Handle Connection.prepareStatement(String) method call. This method check internal cache first and returns prepared statement if found. Otherwise, it prepares statement and caches it.

Parameters:

statement - statement to prepare.

resultSetType - result set type.

resultSetConcurrency - result set concurrency.

resultSetHoldability - result set holdability.

Returns:

instance of PreparedStatement corresponding to the statement.

Throws:

java.sql.SQLException - if there was problem preparing statement.

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement(java.lang.String sql,
                                                       int resultSetType,
                                                       int resultSetConcurrency)
                                                throws java.sql.SQLException

Deprecated.

Get instance of PreparedStatement for the specified SQL statement. Default implementation would call Connection.prepareStatement(String, int, int) on physical connection. However it is also possible to implement prepared statement pooling for increased performance.

Parameters:

sql - SQL statement for which prepared statement must be constructed.

resultSetType - type of the result set.

resultSetConcurrency - result set concurrency.

Returns:

instance of PreparedStatement corresponding to the specified SQL statement.

Throws:

java.sql.SQLException - if prepared statement cannot be obtained.

getPreparedStatement

public java.sql.PreparedStatement getPreparedStatement(java.lang.String statement,
                                                       int[] keyIndexes,
                                                       java.lang.String[] keyColumns)
                                                throws java.sql.SQLException

Deprecated.

Prepare specified SQL statement that will return the generated keys. This method should call corresponding methods on physical JDBC connection:

• Connection.prepareStatement(String, int)
• Connection.prepareStatement(String, int[])
• Connection.prepareStatement(String, String[])

Parameters:

statement - SQL statement for which prepared statement must be constructed.

keyIndexes - - array of key column indexes if they were specified or null in other cases.

keyColumns - - array of key column names if they were specified or null in other cases.

Returns:

instance of PreparedStatement corresponding to the specified SQL statement.

Throws:

java.sql.SQLException - if prepared statement cannot be obtained.

prepareStatement

public org.firebirdsql.pool.XCachablePreparedStatement prepareStatement(XPreparedStatementModel key,
                                                                        boolean cached)
                                                                 throws java.sql.SQLException

Deprecated.

Prepare the specified statement and wrap it with cache notification wrapper.

Specified by:

prepareStatement in interface XStatementManager

Parameters:

key - Statement model of the statement to prepare

cached - true if prepared statement will be cached

Returns:

prepared and wrapped statement.

Throws:

java.sql.SQLException - if underlying connection threw this exception.

See Also:

Connection.prepareStatement(java.lang.String, int, int, int)

prepareStatement

public org.firebirdsql.pool.XCachablePreparedStatement prepareStatement(java.lang.String sql,
                                                                        int resultSetType,
                                                                        int resultSetConcurrency,
                                                                        boolean cached)
                                                                 throws java.sql.SQLException

Deprecated. use prepareStatement(XPreparedStatementModel, boolean) instead.

Prepare specified SQL statement. This method should call Connection.prepareStatement(String) method on physical JDBC connection.

Specified by:

prepareStatement in interface XStatementManager

Parameters:

sql - SQL statement to prepare.

resultSetType - type of result set

resultSetConcurrency - result set concurrency

cached - true if prepared statement will be cached.

Returns:

instance of PreparedStatement corresponding to the specified SQL statement.

Throws:

java.sql.SQLException - if something went wrong.

See Also:

Connection.prepareStatement(java.lang.String, int, int)

statementClosed

public void statementClosed(java.lang.String sql,
                            java.lang.Object proxy)
                     throws java.sql.SQLException

Deprecated.

Description copied from interface: XStatementManager

Notify about statement close.

Specified by:

statementClosed in interface XStatementManager

Parameters:

sql - SQL statement of an object that is being closed.

proxy - proxy on which Statement.close() method was called.

Throws:

java.sql.SQLException - if something went wrong.

statementClosed

public void statementClosed(XPreparedStatementModel key,
                            java.lang.Object proxy)
                     throws java.sql.SQLException

Deprecated.

Handle Statement.close() method. This implementation dereferences proxy in cache.

Specified by:

statementClosed in interface XStatementManager

Parameters:

key - Statement model of the statement to prepare

proxy - proxy wrapping the connection.

Throws:

java.sql.SQLException - if prepared statement cannot be added to the pool.

isRollbackAllowed

protected boolean isRollbackAllowed()

Deprecated.

Is calling rollback on the physical connection allowed when the logical connection close is signalled.

Reason to return false is when the physical connection is participating in a distributed connection.

Returns:

true when calling rollback is allowed, false otherwise

connectionClosed

public void connectionClosed(org.firebirdsql.pool.PooledConnectionHandler connection)
                      throws java.sql.SQLException

Deprecated.

Notify connection owner about invocation of the Connection.close() operation on PooledConnectionHandler instance.

Parameters:

connection - instance of PooledConnectionHandler that initiated the call.

Throws:

java.sql.SQLException

connectionErrorOccured

public void connectionErrorOccured(org.firebirdsql.pool.PooledConnectionHandler connection,
                                   java.sql.SQLException ex)

Deprecated.

Notify connection owner about the SQLException that happened during method invocation on the wrapped connection.

Parameters:

connection - instance of PooledConnectionHandler that catched exception.

ex - instance of SQLException that was thrown.

isValid

public boolean isValid(org.firebirdsql.pool.PooledConnectionHandler connection)

Deprecated.

Check if specified connection is still valid.

Parameters:

connection - instance of PooledConnectionHandler to check.

Returns:

true if connection owner is still valid, false otherwise.

connectionCommitted

public void connectionCommitted(org.firebirdsql.pool.PooledConnectionHandler connection)
                         throws java.sql.SQLException

Deprecated.

Notify this class that transaction was committed.

Parameters:

connection - connection that was commited.

Throws:

java.sql.SQLException

See Also:

XConnectionManager.connectionCommitted(PooledConnectionHandler)

connectionRolledBack

public void connectionRolledBack(org.firebirdsql.pool.PooledConnectionHandler connection)
                          throws java.sql.SQLException

Deprecated.

Notify this class that transaction was rolled back.

Parameters:

connection - connection that was commited.

Throws:

java.sql.SQLException

See Also:

XConnectionManager.connectionRolledBack(PooledConnectionHandler)

getOwningQueue

public org.firebirdsql.pool.PooledConnectionQueue getOwningQueue()

Deprecated.

Specified by:

getOwningQueue in interface PooledObject