Package com.saperion.constants

Class SaSQLConstants

  • public final class SaSQLConstants
extends java.lang.Object
    Database specific constants.

    • Method Summary

      All Methods Static Methods Concrete Methods 
      Modifier and Type Method Description
      static org.joda.time.ReadableDateTime getMaxDateForDB​(java.lang.String database)
      Returns the minimum date value for the specified database or null, if database is unknown.
      static org.joda.time.ReadableDateTime getMinDateForDB​(java.lang.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 java.lang.String MSSQL_PRE_FIELD_DELIM
        MSSQL Pre Delimiter .
        See Also:
        Constant Field Values

      • MSSQL_POST_FIELD_DELIM

        public static final java.lang.String MSSQL_POST_FIELD_DELIM
        MSSQL post Delimiter .
        See Also:
        Constant Field Values

      • MYSQL_FIELD_DELIM

        public static final java.lang.String MYSQL_FIELD_DELIM
        MySQL Pre and post Delimiter .
        See Also:
        Constant Field Values

      • ORA_PRE_FIELD_DELIM

        public static final java.lang.String ORA_PRE_FIELD_DELIM
        Oracle Pre Delimiter .
        See Also:
        Constant Field Values

      • ORA_POST_FIELD_DELIM

        public static final java.lang.String ORA_POST_FIELD_DELIM
        Oracle post Delimiter .
        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​(java.lang.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​(java.lang.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