Package org.apache.torque.adapter
Klasse OracleAdapter
java.lang.Object
org.apache.torque.adapter.AbstractAdapter
org.apache.torque.adapter.OracleAdapter
- Alle implementierten Schnittstellen:
Serializable,Adapter
This code should be used for an Oracle database pool.
- Version:
- $Id: OracleAdapter.java 1917245 2024-04-21 14:06:23Z tv $
- Autor:
- Jon S. Stevens, Brett McLaughlin, Bill Schneider, Daniel Rall
- 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 TypMethodeBeschreibungbooleanThis method is for the SqlExpression.quoteAndEscape rules.voidgenerateLimits(Query query, long offset, int limit) Build Oracle-style query with limit or offset.getIDMethodSQL(Object sequenceName) Returns SQL used to get the most recently inserted primary key.Returns the constant from theIDMethodinterface denoting which type of primary key generation method this type of RDBMS uses.ignoreCase(String in) This method is used to ignore case.voidlockTable(Connection con, String table) Locks the specified table.toUpperCase(String in) 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.booleanWhether to use the MINUS operator instead of the EXCEPT operator.Von Klasse geerbte Methoden org.apache.torque.adapter.AbstractAdapter
getStringDelimiter, getUpdateLockClause, ignoreCaseInOrderBy, setCapabilities, supportsNativeLimit, supportsNativeOffset, useGetGeneratedKeys, useIlike
-
Konstruktordetails
-
OracleAdapter
protected OracleAdapter()Empty constructor.
-
-
Methodendetails
-
toUpperCase
This method is used to ignore case.- Angegeben von:
toUpperCasein SchnittstelleAdapter- Angegeben von:
toUpperCasein KlasseAbstractAdapter- Parameter:
in- 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:
in- 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
Beschreibung aus Klasse kopiert:AbstractAdapterReturns SQL used to get the most recently inserted primary key. Databases which have no support for this returnnull.- Angegeben von:
getIDMethodSQLin SchnittstelleAdapter- Angegeben von:
getIDMethodSQLin KlasseAbstractAdapter- Parameter:
sequenceName- The name of the sequence (should be of typeString).- Gibt zurück:
- SQL to retrieve the next 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.
-
generateLimits
Build Oracle-style query with limit or offset. If the original SQL is in variable: query then the requlting SQL looks like this:SELECT B.* FROM ( SELECT A.*, rownum as TORQUE$ROWNUM FROM ( query ) A ) B WHERE B.TORQUE$ROWNUM > offset AND B.TORQUE$ROWNUM <= offset + limit- Angegeben von:
generateLimitsin SchnittstelleAdapter- Setzt außer Kraft:
generateLimitsin KlasseAbstractAdapter- Parameter:
query- The query to modifyoffset- the offset Valuelimit- the limit Value
-
escapeText
public boolean escapeText()This method is for the SqlExpression.quoteAndEscape rules. The rule is, any string in a SqlExpression with a BACKSLASH will either be changed to "\\" or left as "\". SapDB does not need the escape character.- Angegeben von:
escapeTextin SchnittstelleAdapter- Setzt außer Kraft:
escapeTextin KlasseAbstractAdapter- Gibt zurück:
- false.
-
useEscapeClauseForLike
public boolean useEscapeClauseForLike()Whether an escape clause in like should be used. Example : select * from AUTHOR where AUTHOR.NAME like '\_%' ESCAPE '\'; Oracle 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.
-
useMinusForExcept
public boolean useMinusForExcept()Whether to use the MINUS operator instead of the EXCEPT operator. Oracle needs this, so this implementation always returnstrue.- Angegeben von:
useMinusForExceptin SchnittstelleAdapter- Setzt außer Kraft:
useMinusForExceptin KlasseAbstractAdapter- Gibt zurück:
- whether to use the MINUS operator instead of the EXCEPT operator.
-