Class PStmtKey

java.lang.Object
org.apache.commons.dbcp2.PStmtKey
Direct Known Subclasses:
PStmtKeyCPDS

public class PStmtKey extends Object
A key uniquely identifying PreparedStatements.
Since:
2.0
  • Constructor Details

    • PStmtKey

      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
    • PStmtKey

      @Deprecated public PStmtKey(String sql, int resultSetType, int resultSetConcurrency)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      resultSetType - A result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE.
      resultSetConcurrency - A concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE.
    • PStmtKey

      @Deprecated public PStmtKey(String sql, String catalog)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
    • PStmtKey

      @Deprecated public PStmtKey(String sql, String catalog, int autoGeneratedKeys)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      autoGeneratedKeys - A flag indicating whether auto-generated keys should be returned; one of Statement.RETURN_GENERATED_KEYS or Statement.NO_GENERATED_KEYS.
    • PStmtKey

      @Deprecated public PStmtKey(String sql, String catalog, int resultSetType, int resultSetConcurrency)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      resultSetType - A result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE.
      resultSetConcurrency - A concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE.
    • PStmtKey

      @Deprecated public PStmtKey(String sql, String catalog, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      resultSetType - a result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE.
      resultSetConcurrency - A concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE
      resultSetHoldability - One of the following ResultSet constants: ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT.
    • PStmtKey

      @Deprecated public PStmtKey(String sql, String catalog, int resultSetType, int resultSetConcurrency, int resultSetHoldability, PoolingConnection.StatementType statementType)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      resultSetType - a result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
      resultSetConcurrency - A concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE.
      resultSetHoldability - One of the following ResultSet constants: ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT.
      statementType - The SQL statement type, prepared or callable.
    • PStmtKey

      @Deprecated public PStmtKey(String sql, String catalog, int resultSetType, int resultSetConcurrency, PoolingConnection.StatementType statementType)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      resultSetType - A result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE.
      resultSetConcurrency - A concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE.
      statementType - The SQL statement type, prepared or callable.
    • PStmtKey

      @Deprecated public PStmtKey(String sql, String catalog, int[] columnIndexes)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      columnIndexes - An array of column indexes indicating the columns that should be returned from the inserted row or rows.
    • PStmtKey

      @Deprecated public PStmtKey(String sql, String catalog, PoolingConnection.StatementType statementType)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      statementType - The SQL statement type, prepared or callable.
    • PStmtKey

      @Deprecated public PStmtKey(String sql, String catalog, PoolingConnection.StatementType statementType, Integer autoGeneratedKeys)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      statementType - The SQL statement type, prepared or callable.
      autoGeneratedKeys - A flag indicating whether auto-generated keys should be returned; one of Statement.RETURN_GENERATED_KEYS or Statement.NO_GENERATED_KEYS.
    • PStmtKey

      public PStmtKey(String sql, String catalog, String schema)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      schema - The schema
      Since:
      2.5.0
    • PStmtKey

      public PStmtKey(String sql, String catalog, String schema, int autoGeneratedKeys)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      schema - The schema
      autoGeneratedKeys - A flag indicating whether auto-generated keys should be returned; one of Statement.RETURN_GENERATED_KEYS or Statement.NO_GENERATED_KEYS.
      Since:
      2.5.0
    • PStmtKey

      public PStmtKey(String sql, String catalog, String schema, int resultSetType, int resultSetConcurrency)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      schema - The schema
      resultSetType - A result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE.
      resultSetConcurrency - A concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE.
    • PStmtKey

      public PStmtKey(String sql, String catalog, String schema, int resultSetType, int resultSetConcurrency, int resultSetHoldability)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      schema - The schema
      resultSetType - a result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE.
      resultSetConcurrency - A concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE
      resultSetHoldability - One of the following ResultSet constants: ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT.
      Since:
      2.5.0
    • PStmtKey

      public PStmtKey(String sql, String catalog, String schema, int resultSetType, int resultSetConcurrency, int resultSetHoldability, PoolingConnection.StatementType statementType)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      schema - The schema.
      resultSetType - a result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
      resultSetConcurrency - A concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE.
      resultSetHoldability - One of the following ResultSet constants: ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT.
      statementType - The SQL statement type, prepared or callable.
      Since:
      2.5.0
    • PStmtKey

      public PStmtKey(String sql, String catalog, String schema, int resultSetType, int resultSetConcurrency, PoolingConnection.StatementType statementType)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      schema - The schema.
      resultSetType - A result set type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE.
      resultSetConcurrency - A concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE.
      statementType - The SQL statement type, prepared or callable.
      Since:
      2.5.0
    • PStmtKey

      public PStmtKey(String sql, String catalog, String schema, int[] columnIndexes)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      schema - The schema.
      columnIndexes - An array of column indexes indicating the columns that should be returned from the inserted row or rows.
    • PStmtKey

      public PStmtKey(String sql, String catalog, String schema, PoolingConnection.StatementType statementType)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      schema - The schema.
      statementType - The SQL statement type, prepared or callable.
      Since:
      2.5.0
    • PStmtKey

      public PStmtKey(String sql, String catalog, String schema, PoolingConnection.StatementType statementType, Integer autoGeneratedKeys)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      schema - The schema.
      statementType - The SQL statement type, prepared or callable.
      autoGeneratedKeys - A flag indicating whether auto-generated keys should be returned; one of Statement.RETURN_GENERATED_KEYS or Statement.NO_GENERATED_KEYS.
      Since:
      2.5.0
    • PStmtKey

      public PStmtKey(String sql, String catalog, String schema, String[] columnNames)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      schema - The schema.
      columnNames - An array of column names indicating the columns that should be returned from the inserted row or rows.
      Since:
      2.5.0
    • PStmtKey

      @Deprecated public PStmtKey(String sql, String catalog, String[] columnNames)
      Constructs a key to uniquely identify a prepared statement.
      Parameters:
      sql - The SQL statement.
      catalog - The catalog.
      columnNames - An array of column names indicating the columns that should be returned from the inserted row or rows.
  • Method Details

    • createStatement

      public Statement createStatement(Connection connection) throws SQLException
      Creates a new Statement from the given Connection.
      Parameters:
      connection - The Connection to use to create the statement.
      Returns:
      The statement.
      Throws:
      SQLException - Thrown when there is a problem creating the statement.
    • equals

      public boolean equals(Object obj)
      Overrides:
      equals in class Object
    • getAutoGeneratedKeys

      Gets a flag indicating whether auto-generated keys should be returned; one of Statement.RETURN_GENERATED_KEYS or Statement.NO_GENERATED_KEYS.
      Returns:
      a flag indicating whether auto-generated keys should be returned.
    • getCatalog

      public String getCatalog()
      Gets the catalog.
      Returns:
      The catalog.
    • getColumnIndexes

      public int[] getColumnIndexes()
      Gets an array of column indexes indicating the columns that should be returned from the inserted row or rows.
      Returns:
      An array of column indexes.
    • getColumnNames

      public String[] getColumnNames()
      Gets an array of column names indicating the columns that should be returned from the inserted row or rows.
      Returns:
      An array of column names.
    • getResultSetConcurrency

      Gets the result set concurrency type; one of ResultSet.CONCUR_READ_ONLY or ResultSet.CONCUR_UPDATABLE.
      Returns:
      The result set concurrency type.
    • getResultSetHoldability

      Gets the result set holdability, one of the following ResultSet constants: ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT.
      Returns:
      The result set holdability.
    • getResultSetType

      Gets the result set type, one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE.
      Returns:
      the result set type.
    • getSchema

      public String getSchema()
      Gets the schema.
      Returns:
      The catalog.
    • getSql

      public String getSql()
      Gets the SQL statement.
      Returns:
      the SQL statement.
    • getStmtType

      Gets the SQL statement type.
      Returns:
      The SQL statement type.
    • hashCode

      public int hashCode()
      Overrides:
      hashCode in class Object
    • toString

      public String toString()
      Overrides:
      toString in class Object