Class VectorwiseDialect

  • All Implemented Interfaces:
    Dialect

    public class VectorwiseDialect
    extends IngresDialect
    Implementation of Dialect for the Vertica database.
    Since:
    Sept 11, 2009
    Author:
    LBoudreau
    • Constructor Detail

      • VectorwiseDialect

        public VectorwiseDialect​(java.sql.Connection connection)
                          throws java.sql.SQLException
        Creates a VectorwiseDialect.
        Parameters:
        connection - Connection
        Throws:
        java.sql.SQLException
    • Method Detail

      • supportsResultSetConcurrency

        public boolean supportsResultSetConcurrency​(int type,
                                                    int concurrency)
        Description copied from interface: Dialect
        Returns whether this Dialect supports the given concurrency type in combination with the given result set type.

        The result is similar to DatabaseMetaData.supportsResultSetConcurrency(int, int), except that the JdbcOdbc bridge in JDK 1.6 overstates its abilities. See bug 1690406.

        Specified by:
        supportsResultSetConcurrency in interface Dialect
        Overrides:
        supportsResultSetConcurrency in class JdbcDialectImpl
        Parameters:
        type - defined in ResultSet
        concurrency - type defined in ResultSet
        Returns:
        true if so; false otherwise
      • requiresHavingAlias

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

        For example, in such a dialect,

        SELECT CONCAT(x) as foo FROM t HAVING CONCAT(x) LIKE "%"
        would be illegal, but
        SELECT CONCAT(x) as foo FROM t HAVING foo LIKE "%"
        would be legal.

        MySQL is an example of such dialects.

        Specified by:
        requiresHavingAlias in interface Dialect
        Overrides:
        requiresHavingAlias in class JdbcDialectImpl
        Returns:
        Whether this Dialect can include expressions in the HAVING clause only by adding an expression to the SELECT clause and using its alias