[an error occurred while processing this directive]
PATH
Documentation > WebObjects 4.5 >
OracleEOAdaptor Reference
Inherits
from: EOSQLExpression : NSObject
Package: com.apple.yellow.oracleeoadaptorjava
Class Description
OracleSQLExpression defines how to build SQL statements for
OracleChannels.
Static Methods
public static int serverTypeIdForName(String typeName)
Returns the Oracle type code (such as OraVARCHAR2
or OraNumber) for typeName (such
as "VARCHAR2" or "NUMBER").
public static void setUseNoWaitLocks(boolean flag)
Sets according to flag whether
the lock clause of the OracleSQLExpression is "FOR UPDATE" (block until
the row is available) or "FOR UPDATE NOWAIT" (return an error
immediately if an attempt to lock a row would block). By default
OracleSQLExpression uses the clause "FOR UPDATE"-that is,
by default it does not use NOWAIT locks. This behavior is also controllable
through the EOOracleUseNoWaitLocks user
default.
public static void setUseQuotedExternalNames(boolean flag)
Sets according to flag whether
the OracleSQLExpression expects external (database) names to be enclosed
in quotation marks. This is useful if the database has table or
column names that are either reserved words or that are not all
uppercase. The default is NO. This behavior can also be controlled
through the EOOracleUseQuotedExternalNames user
default.
public static boolean useNoWaitLocks()
Returns true to indicate that the OracleSQLExpression
uses NOWAIT locks, false otherwise. The default is false.
public static boolean useQuotedExternalNames()
Returns YES to indicate that the OracleSQLExpression
uses quoted external (database) names, NO otherwise.
Instance Methods
public String lockClause()
Overrides the EOSQLExpression method lockClause to return
the SQL string used in a SELECT statement to lock selected rows.
Queries the user default EOOracleUseNoWaitLocks. If this default
is not set or if it is set to false, this method returns the string "FOR
UPDATE". If the default is set to true, this method returns "FOR
UPDATE NOWAIT".