| java.lang.Object
 org.apache.torque.adapter.AbstractDBAdapter
org.apache.torque.adapter.DBDB2App
All known Subclasses: org.apache.torque.adapter.DBDB2Net, org.apache.torque.adapter.DBDB2400,
| Constructor Summary | |
| protected | DBDB2App()
Empty constructor. |
| DBDB2App | | protected DBDB2App()(Code) | | Empty constructor.
|
| generateLimits | | public void generateLimits(Query query, int offset, int limit)(Code) | | Build DB2 (OLAP) -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.*, row_number() over() 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 |
| getLimitStyle | | public int getLimitStyle()(Code) | | This method is used to check whether the database supports
limiting the size of the resultset.
LIMIT_STYLE_DB2. |
| 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. |
|
|