Class NeoviewDialect

  • All Implemented Interfaces:
    Dialect

    public class NeoviewDialect
    extends JdbcDialectImpl
    Implementation of Dialect for the Neoview database.
    Since:
    Dec 4, 2009
    Author:
    jhyde
    • Constructor Detail

    • Method Detail

      • _supportsOrderByNullsLast

        public boolean _supportsOrderByNullsLast()
      • requiresOrderByAlias

        public boolean requiresOrderByAlias()
        Description copied from interface: Dialect
        Returns true if this Dialect can include expressions in the ORDER BY clause only by adding an expression to the SELECT clause and using its alias.

        For example, in such a dialect,

        SELECT x FROM t ORDER BY x + y
        would be illegal, but
        SELECT x, x + y AS z FROM t ORDER BY z
        would be legal.

        MySQL, DB2 and Ingres are examples of such dialects.

        Specified by:
        requiresOrderByAlias in interface Dialect
        Overrides:
        requiresOrderByAlias in class JdbcDialectImpl
        Returns:
        Whether this Dialect can include expressions in the ORDER BY clause only by adding an expression to the SELECT clause and using its alias
      • allowsDdl

        public boolean allowsDdl()
        Description copied from interface: Dialect
        Returns whether this dialect supports common SQL Data Definition Language (DDL) statements such as CREATE TABLE and DROP INDEX.

        Access seems to allow DDL iff the .mdb file is writeable.

        Specified by:
        allowsDdl in interface Dialect
        Overrides:
        allowsDdl in class JdbcDialectImpl
        Returns:
        whether this Dialect supports DDL
        See Also:
        DatabaseMetaData.isReadOnly()
      • supportsGroupByExpressions

        public boolean supportsGroupByExpressions()
        Description copied from interface: Dialect
        Returns whether this Dialect supports expressions in the GROUP BY clause. Derby/Cloudscape and Infobright do not.
        Specified by:
        supportsGroupByExpressions in interface Dialect
        Overrides:
        supportsGroupByExpressions in class JdbcDialectImpl
        Returns:
        Whether this Dialect allows expressions in the GROUP BY clause
      • generateInline

        public String generateInline​(List<String> columnNames,
                                     List<String> columnTypes,
                                     List<String[]> valueList)
        Description copied from interface: Dialect
        Generates a SQL statement to represent an inline dataset.

        For example, for Oracle, generates

         SELECT 1 AS FOO, 'a' AS BAR FROM dual
         UNION ALL
         SELECT 2 AS FOO, 'b' AS BAR FROM dual
         

        For ANSI SQL, generates:

         VALUES (1, 'a'), (2, 'b')
         
        Specified by:
        generateInline in interface Dialect
        Overrides:
        generateInline in class JdbcDialectImpl
        Parameters:
        columnNames - List of column names
        columnTypes - List of column types ("String" or "Numeric")
        valueList - List of rows values
        Returns:
        SQL string