Package 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	Description
static final org.joda.time.ReadableDateTime	DB2_MAX_DATE	DB2 max date value.
static final org.joda.time.ReadableDateTime	DB2_MIN_DATE	DB2 min date value.
static final org.joda.time.ReadableDateTime	MSSQL_MAX_DATE	MSSQL max date value.
static final org.joda.time.ReadableDateTime	MSSQL_MIN_DATE	MSSQL min date value.
static final String	MSSQL_POST_FIELD_DELIM	MSSQL post Delimiter .
static final String	MSSQL_PRE_FIELD_DELIM	MSSQL Pre Delimiter .
static final String	MYSQL_FIELD_DELIM	MySQL Pre and post Delimiter .
static final org.joda.time.ReadableDateTime	MYSQL_MAX_DATE	MySQL max date value.
static final org.joda.time.ReadableDateTime	MYSQL_MIN_DATE	MySQL min date value.
static final String	ORA_POST_FIELD_DELIM	Oracle post Delimiter .
static final String	ORA_PRE_FIELD_DELIM	Oracle Pre Delimiter .
static final org.joda.time.ReadableDateTime	ORACLE_MAX_DATE	Oracle max date value.
static final org.joda.time.ReadableDateTime	ORACLE_MIN_DATE	Oracle min date value.
static final int	TYPEAND	AND.
static final int	TYPENOT	NOT.
static final int	TYPEOR	OR.

Method Summary

Modifier and Type	Method	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 Details

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 Details

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