org.firebirdsql.pool
Class AbstractPingablePooledConnection

java.lang.Object
  extended by 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
protected  java.sql.Connection jdbcConnection
          Deprecated.  
 
Fields inherited from interface org.firebirdsql.pool.PooledObject
INSTANT_IN_USE
 
Constructor Summary
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
 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:

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


Copyright © 2001-2019 Jaybird (Firebird JDBC/JCA) team. All rights reserved.