wt.dataservice
Class Oracle

java.lang.Object
  wt.dataservice.AbstractDatastore
      wt.dataservice.Oracle

All Implemented Interfaces:

Datastore

Direct Known Subclasses:

OracleEnterprise, OracleStandard

public class Oracle

extends AbstractDatastore

Field Summary

private static String	DATE_JAVA_FORMAT
private static String	DATE_SQL_FORMAT
private static String	DATEFORMAT
private static HashMap	functionnameMap
private static HashMap	infixMap
private static int	MAXSQLSTRINGSIZE
private static int	ORACLE_8_0_BLOB_TYPE
private static String	TIME_JAVA_FORMAT
private static String	TIME_SQL_FORMAT
private static HashMap	timeFormatMap
private static String	TIMESTAMP_JAVA_FORMAT
private static String	TIMESTAMP_SQL_FORMAT
private static String	UTIL_DATE_JAVA_PARSE

Constructor Summary

Oracle()

Method Summary

protected String	getCreateTemporaryTableDDLPrefix() This method returns the intial portion of the Create Temporary Table DDL statement.
String	getDateFormat()
String	getDateJavaFormat()
Object	getDateSQLFormat()
int	getMaxLength(int a_sqlType) This method returns the maximum length allowable for the specified java.sql.Types value.
String	getSQLFunctionName(String a_funcName) This method returns a the datastore specific function name for the given function name constant.
String	getSQLTypeString(int sqltype, int stringLength) This method returns a java.lang.String value that the specified javaType maps to.
String	getTimeJavaFormat()
Object	getTimeSQLFormat()
String	getTimeStampJavaFormat()
Object	getTimeStampSQLFormat()
String	getUserDefinedNameExpression(String a_expression) This method converts the UserDefined SQL Functions in the expression with datastore format.
String	getUtilDateJavaParse()
boolean	isInfix(String a_FunctionName) This method returns true if the function is infix otherwise false.
static boolean	isSqlTypeLob(int sql_type) This method returns true if sql type is blob otherwise false.

Methods inherited from class wt.dataservice.AbstractDatastore

buildCreateTemporaryTableDDL, getDatastoreColumnNameExpression, getInFixExpression, getType

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

DATEFORMAT

private static final String DATEFORMAT

See Also:

Constant Field Values

DATE_JAVA_FORMAT

private static final String DATE_JAVA_FORMAT

See Also:

Constant Field Values

TIME_JAVA_FORMAT

private static final String TIME_JAVA_FORMAT

See Also:

Constant Field Values

TIMESTAMP_JAVA_FORMAT

private static final String TIMESTAMP_JAVA_FORMAT

See Also:

Constant Field Values

DATE_SQL_FORMAT

private static final String DATE_SQL_FORMAT

See Also:

Constant Field Values

TIME_SQL_FORMAT

private static final String TIME_SQL_FORMAT

See Also:

Constant Field Values

TIMESTAMP_SQL_FORMAT

private static final String TIMESTAMP_SQL_FORMAT

See Also:

Constant Field Values

UTIL_DATE_JAVA_PARSE

private static final String UTIL_DATE_JAVA_PARSE

See Also:

Constant Field Values

MAXSQLSTRINGSIZE

private static final int MAXSQLSTRINGSIZE

ORACLE_8_0_BLOB_TYPE

private static final int ORACLE_8_0_BLOB_TYPE

See Also:

Constant Field Values

functionnameMap

private static HashMap functionnameMap

timeFormatMap

private static HashMap timeFormatMap

infixMap

private static HashMap infixMap

Constructor Detail

Oracle

public Oracle()

Method Detail

getSQLFunctionName

public String getSQLFunctionName(String a_funcName)

This method returns a the datastore specific function name for the given function name constant.

Supported API: false

Parameters:

a_funcName - a function name constant.

Returns:

datastore specific function name.

isInfix

public boolean isInfix(String a_FunctionName)

This method returns true if the function is infix otherwise false.

Supported API: false

Parameters:

a_FunctionName - function name

Returns:

java.lang.boolean true if the function is infix otherwise false.

getUserDefinedNameExpression

public String getUserDefinedNameExpression(String a_expression)

This method converts the UserDefined SQL Functions in the expression with datastore format. For Oracle it just returns the same string.

Supported API: false

Parameters:

a_expression - column name expression

Returns:

java.lang.String datastore specific expression.

getDateFormat

public String getDateFormat()

getUtilDateJavaParse

public String getUtilDateJavaParse()

getDateJavaFormat

public String getDateJavaFormat()

getDateSQLFormat

public Object getDateSQLFormat()

getTimeJavaFormat

public String getTimeJavaFormat()

getTimeSQLFormat

public Object getTimeSQLFormat()

getTimeStampJavaFormat

public String getTimeStampJavaFormat()

getTimeStampSQLFormat

public Object getTimeStampSQLFormat()

getSQLTypeString

public String getSQLTypeString(int sqltype,
                               int stringLength)

This method returns a java.lang.String value that the specified javaType maps to.

Supported API: false

Parameters:

sqltype - The java type to get the SQL mapping for.

stringLength - max length of the sql type.

Returns:

java.lang.String sql type indicating the mapping.

isSqlTypeLob

public static boolean isSqlTypeLob(int sql_type)

This method returns true if sql type is blob otherwise false.

Supported API: false

Returns:

boolean true if sql type is blob otherwise false.

getMaxLength

public int getMaxLength(int a_sqlType)

This method returns the maximum length allowable for the specified java.sql.Types value. If there is not maximum, then 0 is returned.

Supported API: false

Parameters:

a_sqlType - The SQL type to return the maximum length for.

Returns:

Maximum length or 0 if there is no maximum.

getCreateTemporaryTableDDLPrefix

protected String getCreateTemporaryTableDDLPrefix()

This method returns the intial portion of the Create Temporary Table DDL statement.

Supported API: false

Specified by:

getCreateTemporaryTableDDLPrefix in class AbstractDatastore