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
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:
-
Feldübersicht
Von Schnittstelle geerbte Felder org.apache.torque.adapter.Adapter
ADAPTER_KEY, AUTODETECT_ADAPTER, DRIVER_KEY -
Konstruktorübersicht
Konstruktoren -
Methodenübersicht
Modifizierer und TypMethodeBeschreibungbooleanWhether backslashes (\) should be escaped in explicit SQL strings.voidgenerateLimits(Query query, long offset, int limit) Build Derby-style query with limit or offset.getIDMethodSQL(Object obj) Returns the SQL to get the database key of the last row inserted, which in this case isVALUES IDENTITY_VAL_LOCAL().Returns the constant from theIDMethodinterface denoting which type of primary key generation method this type of RDBMS uses.ignoreCase(String str) This method is used to ignore case.voidlockTable(Connection con, String table) Locks the specified table.toUpperCase(String str) This method is used to ignore case.voidunlockTable(Connection con, String table) Unlocks the specified table.booleanWhether an escape clause in like should be used.booleanDerby supports this feature but does not report it via JDBCVon Klasse geerbte Methoden org.apache.torque.adapter.AbstractAdapter
getStringDelimiter, getUpdateLockClause, ignoreCaseInOrderBy, setCapabilities, supportsNativeLimit, supportsNativeOffset, useIlike, useMinusForExcept
-
Konstruktordetails
-
DerbyAdapter
protected DerbyAdapter()Empty constructor.
-
-
Methodendetails
-
toUpperCase
This method is used to ignore case.- Angegeben von:
toUpperCasein SchnittstelleAdapter- Angegeben von:
toUpperCasein KlasseAbstractAdapter- Parameter:
str- The string to transform to upper case.- Gibt zurück:
- The upper case string.
-
ignoreCase
This method is used to ignore case.- Angegeben von:
ignoreCasein SchnittstelleAdapter- Angegeben von:
ignoreCasein KlasseAbstractAdapter- Parameter:
str- The string whose case to ignore.- Gibt zurück:
- The string in a case that can be ignored.
-
getIDMethodType
Beschreibung aus Klasse kopiert:AbstractAdapterReturns the constant from theIDMethodinterface denoting which type of primary key generation method this type of RDBMS uses.- Angegeben von:
getIDMethodTypein SchnittstelleAdapter- Angegeben von:
getIDMethodTypein KlasseAbstractAdapter- Gibt zurück:
- IDMethod constant
- Siehe auch:
-
getIDMethodSQL
Returns the SQL to get the database key of the last row inserted, which in this case isVALUES IDENTITY_VAL_LOCAL().- Angegeben von:
getIDMethodSQLin SchnittstelleAdapter- Angegeben von:
getIDMethodSQLin KlasseAbstractAdapter- Parameter:
obj- Information used for key generation.- Gibt zurück:
- The most recently inserted database key.
- Siehe auch:
-
lockTable
Locks the specified table.- Angegeben von:
lockTablein SchnittstelleAdapter- Angegeben von:
lockTablein KlasseAbstractAdapter- 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
Unlocks the specified table.- Angegeben von:
unlockTablein SchnittstelleAdapter- Angegeben von:
unlockTablein KlasseAbstractAdapter- 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:
escapeTextin SchnittstelleAdapter- Setzt außer Kraft:
escapeTextin KlasseAbstractAdapter- 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 returnstrue.- Angegeben von:
useEscapeClauseForLikein SchnittstelleAdapter- Setzt außer Kraft:
useEscapeClauseForLikein KlasseAbstractAdapter- 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:
useGetGeneratedKeysin SchnittstelleAdapter- Setzt außer Kraft:
useGetGeneratedKeysin KlasseAbstractAdapter- Gibt zurück:
- a
booleanvalue - Siehe auch:
-
generateLimits
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:
generateLimitsin SchnittstelleAdapter- Setzt außer Kraft:
generateLimitsin KlasseAbstractAdapter- Parameter:
query- The query to modify.offset- the offset value.limit- the limit value.
-