Package org.apache.torque.adapter

# Klasse PostgresAdapter

java.lang.Object
org.apache.torque.adapter.AbstractAdapter
org.apache.torque.adapter.PostgresAdapter

Alle implementierten Schnittstellen:
  `Serializable`, `Adapter`

public class PostgresAdapter extends AbstractAdapter
This is used to connect to PostgresQL databases. http://www.postgresql.org/

Version:
  $Id: PostgresAdapter.java 1848527 2018-12-09 16:27:22Z tv $
Autor:
  Hakan Tandogan, Henning P. Schmiedehausen
Siehe auch:
  - Serialisierte Form

- ## Feldübersicht

  ### Von Schnittstelle geerbte Felder org.apache.torque.adapter.Adapter

  `ADAPTER_KEY, AUTODETECT_ADAPTER, DRIVER_KEY`

- ## Konstruktorübersicht

  Konstruktoren
  Modifizierer
  Konstruktor
  Beschreibung
  `protected`
  `PostgresAdapter()`
  Empty constructor.

- ## Methodenübersicht

  Modifizierer und Typ
  Methode
  Beschreibung
  `void`
  `generateLimits(Query query, long offset, int limit)`
  Generate a LIMIT limit OFFSET offset clause if offset > 0 or an LIMIT limit clause if limit is > 0 and offset is 0.
  `String`
  `getIDMethodSQL(Object name)`
  Returns SQL used to get the most recently inserted primary key.
  `IDMethod`
  `getIDMethodType()`
  Returns the constant from the `IDMethod` interface denoting which type of primary key generation method this type of RDBMS uses.
  `String`
  `ignoreCase(String in)`
  This method is used to ignore case.
  `void`
  `lockTable(Connection con, String table)`
  Locks the specified table.
  `String`
  `toUpperCase(String in)`
  This method is used to ignore case.
  `void`
  `unlockTable(Connection con, String table)`
  Unlocks the specified table.
  `boolean`
  `useIlike()`
  Whether ILIKE should be used for case insensitive like clauses.

  ### Von Klasse geerbte Methoden org.apache.torque.adapter.AbstractAdapter

  `escapeText, getStringDelimiter, getUpdateLockClause, ignoreCaseInOrderBy, setCapabilities, supportsNativeLimit, supportsNativeOffset, useEscapeClauseForLike, useGetGeneratedKeys, useMinusForExcept`

  ### Von Klasse geerbte Methoden java.lang.Object

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

- ## Konstruktordetails

  - ### PostgresAdapter

    protected PostgresAdapter()
    Empty constructor.

- ## Methodendetails

  - ### toUpperCase

    public String toUpperCase(String in)
    This method is used to ignore case.
    Angegeben von:
      `toUpperCase` in Schnittstelle `Adapter`
    Angegeben von:
      `toUpperCase` in Klasse `AbstractAdapter`
    Parameter:
      `in` - The string to transform to upper case.
    Gibt zurück:
      The upper case string.

  - ### ignoreCase

    public String ignoreCase(String in)
    This method is used to ignore case.
    Angegeben von:
      `ignoreCase` in Schnittstelle `Adapter`
    Angegeben von:
      `ignoreCase` in Klasse `AbstractAdapter`
    Parameter:
      `in` - The string whose case to ignore.
    Gibt zurück:
      The string in a case that can be ignored.

  - ### getIDMethodType

    public IDMethod getIDMethodType()
    Beschreibung aus Klasse kopiert: `AbstractAdapter`
    Returns the constant from the `IDMethod` interface denoting which type of primary key generation method this type of RDBMS uses.
    Angegeben von:
      `getIDMethodType` in Schnittstelle `Adapter`
    Angegeben von:
      `getIDMethodType` in Klasse `AbstractAdapter`
    Gibt zurück:
      IDMethod constant
    Siehe auch:
      - `Adapter.getIDMethodType()`

  - ### getIDMethodSQL

    public String getIDMethodSQL(Object name)
    Beschreibung aus Klasse kopiert: `AbstractAdapter`
    Returns SQL used to get the most recently inserted primary key. Databases which have no support for this return `null`.
    Angegeben von:
      `getIDMethodSQL` in Schnittstelle `Adapter`
    Angegeben von:
      `getIDMethodSQL` in Klasse `AbstractAdapter`
    Parameter:
      `name` - The name of the field (should be of type `String`).
    Gibt zurück:
      SQL to retreive the next database key.
    Siehe auch:
      - `Adapter.getIDMethodSQL(Object)`

  - ### lockTable

    public void lockTable(Connection con, String table) throws SQLException
    Locks the specified table.
    Angegeben von:
      `lockTable` in Schnittstelle `Adapter`
    Angegeben von:
      `lockTable` in Klasse `AbstractAdapter`
    Parameter:
      `con` - The JDBC connection to use.
      `table` - The name of the table to lock.
    Löst aus:
      `SQLException` - No Statement could be created or executed.

  - ### unlockTable

    public void unlockTable(Connection con, String table) throws SQLException
    Unlocks the specified table.
    Angegeben von:
      `unlockTable` in Schnittstelle `Adapter`
    Angegeben von:
      `unlockTable` in Klasse `AbstractAdapter`
    Parameter:
      `con` - The JDBC connection to use.
      `table` - The name of the table to unlock.
    Löst aus:
      `SQLException` - No Statement could be created or executed.

  - ### generateLimits

    public void generateLimits(Query query, long offset, int limit)
    Generate a LIMIT limit OFFSET offset clause if offset > 0 or an LIMIT limit clause if limit is > 0 and offset is 0.
    Angegeben von:
      `generateLimits` in Schnittstelle `Adapter`
    Setzt außer Kraft:
      `generateLimits` in Klasse `AbstractAdapter`
    Parameter:
      `query` - The query to modify
      `offset` - the offset Value
      `limit` - the limit Value

  - ### useIlike

    public boolean useIlike()
    Whether ILIKE should be used for case insensitive like clauses. As postgres uses ILIKE, this mimplementation returns true.
    Angegeben von:
      `useIlike` in Schnittstelle `Adapter`
    Setzt außer Kraft:
      `useIlike` in Klasse `AbstractAdapter`
    Gibt zurück:
      true if ilike should be used for case insensitive likes, false if ignoreCase should be applied to the compared strings.