Package org.apache.torque.adapter

# Klasse DerbyAdapter

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

Alle implementierten Schnittstellen:
  `Serializable`, `Adapter`

public class DerbyAdapter extends AbstractAdapter
This is used to connect to an embedded Apache Derby Database using the supplied JDBC driver.

Version:
  $Id: DerbyAdapter.java 1850591 2019-01-06 19:00:34Z tv $
Autor:
  Henning P. Schmiedehausen, tins
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`
  `DerbyAdapter()`
  Empty constructor.

- ## Methodenübersicht

  Modifizierer und Typ
  Methode
  Beschreibung
  `boolean`
  `escapeText()`
  Whether backslashes (\) should be escaped in explicit SQL strings.
  `void`
  `generateLimits(Query query, long offset, int limit)`
  Build Derby-style query with limit or offset.
  `String`
  `getIDMethodSQL(Object obj)`
  Returns the SQL to get the database key of the last row inserted, which in this case is `VALUES IDENTITY_VAL_LOCAL()`.
  `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 str)`
  This method is used to ignore case.
  `void`
  `lockTable(Connection con, String table)`
  Locks the specified table.
  `String`
  `toUpperCase(String str)`
  This method is used to ignore case.
  `void`
  `unlockTable(Connection con, String table)`
  Unlocks the specified table.
  `boolean`
  `useEscapeClauseForLike()`
  Whether an escape clause in like should be used.
  `boolean`
  `useGetGeneratedKeys()`
  Derby supports this feature but does not report it via JDBC

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

  `getStringDelimiter, getUpdateLockClause, ignoreCaseInOrderBy, setCapabilities, supportsNativeLimit, supportsNativeOffset, useIlike, useMinusForExcept`

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

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

- ## Konstruktordetails

  - ### DerbyAdapter

    protected DerbyAdapter()
    Empty constructor.

- ## Methodendetails

  - ### toUpperCase

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

  - ### ignoreCase

    public String ignoreCase(String str)
    This method is used to ignore case.
    Angegeben von:
      `ignoreCase` in Schnittstelle `Adapter`
    Angegeben von:
      `ignoreCase` in Klasse `AbstractAdapter`
    Parameter:
      `str` - 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 obj)
    Returns the SQL to get the database key of the last row inserted, which in this case is `VALUES IDENTITY_VAL_LOCAL()`.
    Angegeben von:
      `getIDMethodSQL` in Schnittstelle `Adapter`
    Angegeben von:
      `getIDMethodSQL` in Klasse `AbstractAdapter`
    Parameter:
      `obj` - Information used for key generation.
    Gibt zurück:
      The most recently inserted database key.
    Siehe auch:
      - `Adapter.getIDMethodSQL(Object obj)`

  - ### 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.

  - ### escapeText

    public boolean escapeText()
    Whether backslashes (\) should be escaped in explicit SQL strings. If true is returned, a BACKSLASH will be changed to "\\". If false is returned, a BACKSLASH will be left as "\". As derby does not need escaping of Backslashes, this method always returns false.
    Angegeben von:
      `escapeText` in Schnittstelle `Adapter`
    Setzt außer Kraft:
      `escapeText` in Klasse `AbstractAdapter`
    Gibt zurück:
      true if the database needs to escape backslashes in SqlExpressions.

  - ### useEscapeClauseForLike

    public boolean useEscapeClauseForLike()
    Whether an escape clause in like should be used. Example : select * from AUTHOR where AUTHOR.NAME like '\_%' ESCAPE '\'; Derby needs this, so this implementation always returns `true`.
    Angegeben von:
      `useEscapeClauseForLike` in Schnittstelle `Adapter`
    Setzt außer Kraft:
      `useEscapeClauseForLike` in Klasse `AbstractAdapter`
    Gibt zurück:
      whether the escape clause should be appended or not.

  - ### useGetGeneratedKeys

    public boolean useGetGeneratedKeys()
    Derby supports this feature but does not report it via JDBC
    Angegeben von:
      `useGetGeneratedKeys` in Schnittstelle `Adapter`
    Setzt außer Kraft:
      `useGetGeneratedKeys` in Klasse `AbstractAdapter`
    Gibt zurück:
      a `boolean` value
    Siehe auch:
      - `AbstractAdapter.useGetGeneratedKeys()`

  - ### generateLimits

    public void generateLimits(Query query, long offset, int limit)
    Build Derby-style query with limit or offset. The resulting query may look like this:

          select * from TABLENAME fetch next 3 rows only;
          select * from TABLENAME offset 3 rows fetch next 3 rows only;

    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.