org.apache.torque.adapter
Class DBOracle

java.lang.Object
  extended byorg.apache.torque.adapter.DB
      extended byorg.apache.torque.adapter.DBOracle
All Implemented Interfaces:
IDMethod, java.io.Serializable

public class DBOracle
extends DB

This code should be used for an Oracle database pool.

Version:
$Id: DBOracle.java 239636 2005-08-24 12:38:09Z henning $
Author:
Jon S. Stevens, Brett McLaughlin, Bill Schneider, Daniel Rall
See Also:
Serialized Form

Field Summary
 
Fields inherited from class org.apache.torque.adapter.DB
ADAPTER_KEY, LIMIT_STYLE_DB2, LIMIT_STYLE_MYSQL, LIMIT_STYLE_NONE, LIMIT_STYLE_ORACLE, LIMIT_STYLE_POSTGRES, LIMIT_STYLE_SYBASE
 
Fields inherited from interface org.apache.torque.adapter.IDMethod
AUTO_INCREMENT, ID_BROKER, NATIVE, NO_ID_METHOD, SEQUENCE
 
Constructor Summary
protected DBOracle()
          Empty constructor.
 
Method Summary
 boolean escapeText()
          This method is for the SqlExpression.quoteAndEscape rules.
 java.lang.String getDateString(java.util.Date date)
          This method is used to format any date string.
 java.lang.String getIDMethodSQL(java.lang.Object sequenceName)
          Returns the next key from a sequence.
 java.lang.String getIDMethodType()
          Returns the constant from the IDMethod interface denoting which type of primary key generation method this type of RDBMS uses.
 int getLimitStyle()
          This method is used to check whether the database supports limiting the size of the resultset.
 java.lang.String ignoreCase(java.lang.String in)
          This method is used to ignore case.
 void lockTable(java.sql.Connection con, java.lang.String table)
          Locks the specified table.
 boolean supportsNativeLimit()
          This method is used to check whether the database natively supports limiting the size of the resultset.
 java.lang.String toUpperCase(java.lang.String in)
          This method is used to ignore case.
 void unlockTable(java.sql.Connection con, java.lang.String table)
          Unlocks the specified table.
 
Methods inherited from class org.apache.torque.adapter.DB
getBooleanString, getStringDelimiter, ignoreCaseInOrderBy, supportsNativeOffset
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

DBOracle

protected DBOracle()
Empty constructor.

Method Detail

toUpperCase

public java.lang.String toUpperCase(java.lang.String in)
This method is used to ignore case.

Specified by:
toUpperCase in class DB
Parameters:
in - The string to transform to upper case.
Returns:
The upper case string.

ignoreCase

public java.lang.String ignoreCase(java.lang.String in)
This method is used to ignore case.

Specified by:
ignoreCase in class DB
Parameters:
in - The string whose case to ignore.
Returns:
The string in a case that can be ignored.

getDateString

public java.lang.String getDateString(java.util.Date date)
This method is used to format any date string.

Overrides:
getDateString in class DB
Parameters:
date - the Date to format
Returns:
The date formatted String for Oracle.

getIDMethodType

public java.lang.String getIDMethodType()
Description copied from class: DB
Returns the constant from the IDMethod interface denoting which type of primary key generation method this type of RDBMS uses.

Specified by:
getIDMethodType in class DB
Returns:
IDMethod constant
See Also:
DB.getIDMethodType()

getIDMethodSQL

public java.lang.String getIDMethodSQL(java.lang.Object sequenceName)
Returns the next key from a sequence. Uses the following implementation:
 select sequenceName.nextval from dual
 

Specified by:
getIDMethodSQL in class DB
Parameters:
sequenceName - The name of the sequence (should be of type String).
Returns:
SQL to retreive the next database key.
See Also:
DB.getIDMethodSQL(Object)

lockTable

public void lockTable(java.sql.Connection con,
                      java.lang.String table)
               throws java.sql.SQLException
Locks the specified table.

Specified by:
lockTable in class DB
Parameters:
con - The JDBC connection to use.
table - The name of the table to lock.
Throws:
java.sql.SQLException - No Statement could be created or executed.

unlockTable

public void unlockTable(java.sql.Connection con,
                        java.lang.String table)
                 throws java.sql.SQLException
Unlocks the specified table.

Specified by:
unlockTable in class DB
Parameters:
con - The JDBC connection to use.
table - The name of the table to unlock.
Throws:
java.sql.SQLException - No Statement could be created or executed.

supportsNativeLimit

public boolean supportsNativeLimit()
This method is used to check whether the database natively supports limiting the size of the resultset.

Overrides:
supportsNativeLimit in class DB
Returns:
True.

getLimitStyle

public int getLimitStyle()
This method is used to check whether the database supports limiting the size of the resultset.

Overrides:
getLimitStyle in class DB
Returns:
LIMIT_STYLE_ORACLE.

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.

Overrides:
escapeText in class DB
Returns:
false.


Copyright © 2000-2006 Apache Software Foundation. All Rights Reserved.