|
| |
|
| java.lang.Object
 org.apache.torque.adapter.AbstractDBAdapter
org.apache.torque.adapter.DBOracle
| Constructor Summary | |
| protected | DBOracle()
Empty constructor. |
| DBOracle | | protected DBOracle()(Code) | | Empty constructor.
|
| escapeText | | public boolean escapeText()(Code) | | 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.
false. |
| generateLimits | | public void generateLimits(Query query, int offset, int limit)(Code) | | 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
Parameters:
query - The query to modify
Parameters:
offset - the offset Value
Parameters:
limit - the limit Value |
| getDateString | | public String getDateString(Date date)(Code) | | This method is used to format any date string.
Parameters:
date - the Date to format The date formatted String for Oracle. |
| getIDMethodSQL | | public String getIDMethodSQL(Object sequenceName)(Code) | | Returns the next key from a sequence. Uses the following
implementation:
select sequenceName.nextval from dual
Parameters:
sequenceName - The name of the sequence (should be of typeString). SQL to retreive the next database key.
See Also: org.apache.torque.adapter.DB.getIDMethodSQL(Object) |
| getLimitStyle | | public int getLimitStyle()(Code) | | This method is used to check whether the database supports
limiting the size of the resultset.
LIMIT_STYLE_ORACLE. |
| ignoreCase | | public String ignoreCase(String in)(Code) | | This method is used to ignore case.
Parameters:
in - The string whose case to ignore. The string in a case that can be ignored. |
| lockTable | | public void lockTable(Connection con, String table) throws SQLException(Code) | | Locks the specified table.
Parameters:
con - The JDBC connection to use.
Parameters:
table - The name of the table to lock.
exception:
SQLException - No Statement could be created or executed. |
| toUpperCase | | public String toUpperCase(String in)(Code) | | This method is used to ignore case.
Parameters:
in - The string to transform to upper case. The upper case string. |
| unlockTable | | public void unlockTable(Connection con, String table) throws SQLException(Code) | | Unlocks the specified table.
Parameters:
con - The JDBC connection to use.
Parameters:
table - The name of the table to unlock.
exception:
SQLException - No Statement could be created or executed. |
| useEscapeClauseForLike | | public boolean useEscapeClauseForLike()(Code) | | 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 returns
true.
whether the escape clause should be appended or not. |
|
|
|