com.saperion.constants

Class SaSQLConstants

java.lang.Object

com.saperion.constants.SaSQLConstants

public final class SaSQLConstants
extends Object

Database specific constants.

Field Summary

Fields

Modifier and Type	Field and Description
static org.joda.time.ReadableDateTime	DB2_MAX_DATE DB2 max date value.
static org.joda.time.ReadableDateTime	DB2_MIN_DATE DB2 min date value.
static org.joda.time.ReadableDateTime	MSSQL_MAX_DATE MSSQL max date value.
static org.joda.time.ReadableDateTime	MSSQL_MIN_DATE MSSQL min date value.
static String	MSSQL_POST_FIELD_DELIM MSSQL post Delimiter .
static String	MSSQL_PRE_FIELD_DELIM MSSQL Pre Delimiter .
static String	MYSQL_FIELD_DELIM MySQL Pre and post Delimiter .
static org.joda.time.ReadableDateTime	MYSQL_MAX_DATE MySQL max date value.
static org.joda.time.ReadableDateTime	MYSQL_MIN_DATE MySQL min date value.
static String	ORA_POST_FIELD_DELIM Oracle post Delimiter .
static String	ORA_PRE_FIELD_DELIM Oracle Pre Delimiter .
static org.joda.time.ReadableDateTime	ORACLE_MAX_DATE Oracle max date value.
static org.joda.time.ReadableDateTime	ORACLE_MIN_DATE Oracle min date value.
static int	TYPEAND AND.
static int	TYPENOT NOT.
static int	TYPEOR OR.

Method Summary

Methods

Modifier and Type	Method and Description
static org.joda.time.ReadableDateTime	getMaxDateForDB(String database) Returns the minimum date value for the specified database or null, if database is unknown.
static org.joda.time.ReadableDateTime	getMinDateForDB(String database) Returns the minimum date value for the specified database or null, if database is unknown.

Methods inherited from class java.lang.Object

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

Field Detail

MSSQL_PRE_FIELD_DELIM

public static final String MSSQL_PRE_FIELD_DELIM

MSSQL Pre Delimiter .

See Also:

Constant Field Values

MSSQL_POST_FIELD_DELIM

public static final String MSSQL_POST_FIELD_DELIM

MSSQL post Delimiter .

See Also:

Constant Field Values

MYSQL_FIELD_DELIM

public static final String MYSQL_FIELD_DELIM

MySQL Pre and post Delimiter .

See Also:

Constant Field Values

ORA_PRE_FIELD_DELIM

public static final String ORA_PRE_FIELD_DELIM

Oracle Pre Delimiter .

See Also:

Constant Field Values

ORA_POST_FIELD_DELIM

public static final String ORA_POST_FIELD_DELIM

Oracle post Delimiter .

See Also:

Constant Field Values

TYPEAND

public static final int TYPEAND

AND.

See Also:

Constant Field Values

TYPEOR

public static final int TYPEOR

OR.

See Also:

Constant Field Values

TYPENOT

public static final int TYPENOT

NOT.

See Also:

Constant Field Values

MSSQL_MIN_DATE

public static final org.joda.time.ReadableDateTime MSSQL_MIN_DATE

MSSQL min date value.

ORACLE_MIN_DATE

public static final org.joda.time.ReadableDateTime ORACLE_MIN_DATE

Oracle min date value.

MYSQL_MIN_DATE

public static final org.joda.time.ReadableDateTime MYSQL_MIN_DATE

MySQL min date value.

DB2_MIN_DATE

public static final org.joda.time.ReadableDateTime DB2_MIN_DATE

DB2 min date value.

MSSQL_MAX_DATE

public static final org.joda.time.ReadableDateTime MSSQL_MAX_DATE

MSSQL max date value.

ORACLE_MAX_DATE

public static final org.joda.time.ReadableDateTime ORACLE_MAX_DATE

Oracle max date value.

MYSQL_MAX_DATE

public static final org.joda.time.ReadableDateTime MYSQL_MAX_DATE

MySQL max date value.

DB2_MAX_DATE

public static final org.joda.time.ReadableDateTime DB2_MAX_DATE

DB2 max date value.

Method Detail

getMinDateForDB

public static org.joda.time.ReadableDateTime getMinDateForDB(String database)

Returns the minimum date value for the specified database or null, if database is unknown.

Parameters:

database - database name

Returns:

minimum date value for the specified databse

See Also:

SaConstants.MSSQL, SaConstants.MYSQL, SaConstants.ORACLE, SaConstants.DB2

getMaxDateForDB

public static org.joda.time.ReadableDateTime getMaxDateForDB(String database)

Returns the minimum date value for the specified database or null, if database is unknown.

Parameters:

database - database name

Returns:

minimum date value for the specified databse

See Also:

SaConstants.MSSQL, SaConstants.MYSQL, SaConstants.ORACLE, SaConstants.DB2