Package org.pentaho.di.core.database

Class VectorWiseDatabaseMeta

java.lang.Object
org.pentaho.di.core.database.BaseDatabaseMeta
org.pentaho.di.core.database.IngresDatabaseMeta
org.pentaho.di.core.database.VectorWiseDatabaseMeta
All Implemented Interfaces:
Cloneable, DatabaseInterface, DatabaseInterfaceExtended
public class VectorWiseDatabaseMeta extends IngresDatabaseMeta implements DatabaseInterface
Contains Computer Associates Ingres specific information through static final members
Since:
11-mrt-2005
Author:
Matt

  • Constructor Details

    • VectorWiseDatabaseMeta

      public VectorWiseDatabaseMeta()

  • Method Details

    • getURL

      public String getURL(String hostname, String port, String databaseName)
      Specified by:
      getURL in interface DatabaseInterface
      Overrides:
      getURL in class IngresDatabaseMeta
      Parameters:
      hostname - the hostname
      port - the port as a string
      databaseName - the database name
      Returns:
      the URL to use for connecting to the database.

    • getAddColumnStatement

      public String getAddColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean useAutoinc, String pk, boolean semicolon)
      Generates the SQL statement to add a column to the specified table
      Specified by:
      getAddColumnStatement in interface DatabaseInterface
      Overrides:
      getAddColumnStatement in class IngresDatabaseMeta
      Parameters:
      tablename - The table to add
      v - The column defined as a value
      tk - the name of the technical key field
      useAutoinc - whether or not this field uses auto increment
      pk - the name of the primary key field
      semicolon - whether or not to add a semi-colon behind the statement.
      Returns:
      the SQL statement to add a column to the specified table

    • getModifyColumnStatement

      public String getModifyColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean useAutoinc, String pk, boolean semicolon)
      Generates the SQL statement to modify a column in the specified table
      Specified by:
      getModifyColumnStatement in interface DatabaseInterface
      Overrides:
      getModifyColumnStatement in class IngresDatabaseMeta
      Parameters:
      tablename - The table to add
      v - The column defined as a value
      tk - the name of the technical key field
      useAutoinc - whether or not this field uses auto increment
      pk - the name of the primary key field
      semicolon - whether or not to add a semi-colon behind the statement.
      Returns:
      the SQL statement to modify a column in the specified table

    • getDropColumnStatement

      public String getDropColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean useAutoinc, String pk, boolean semicolon)
      Generates the SQL statement to drop a column from the specified table
      Specified by:
      getDropColumnStatement in interface DatabaseInterface
      Overrides:
      getDropColumnStatement in class IngresDatabaseMeta
      Parameters:
      tablename - The table to add
      v - The column defined as a value
      tk - the name of the technical key field
      useAutoinc - whether or not this field uses auto increment
      pk - the name of the primary key field
      semicolon - whether or not to add a semi-colon behind the statement.
      Returns:
      the SQL statement to drop a column from the specified table

    • getFieldDefinition

      public String getFieldDefinition(ValueMetaInterface v, String tk, String pk, boolean useAutoinc, boolean addFieldName, boolean addCr)
      Description copied from interface: DatabaseInterface
      Describe a Value as a field in the database.
      Specified by:
      getFieldDefinition in interface DatabaseInterface
      Overrides:
      getFieldDefinition in class IngresDatabaseMeta
      Parameters:
      v - The value to describe
      tk - The field that's going to be the technical key
      pk - The field that's going to be the primary key
      useAutoinc - Use autoincrement or not
      addFieldName - Add the fieldname to the definition or not
      addCr - Add a cariage return at the end of the definition or not.
      Returns:
      a value described as a field in this database.

    • getTruncateTableStatement

      public String getTruncateTableStatement(String tableName)
      Specified by:
      getTruncateTableStatement in interface DatabaseInterface
      Overrides:
      getTruncateTableStatement in class IngresDatabaseMeta
      Parameters:
      tableName - The table to be truncated.
      Returns:
      The SQL statement to truncate a table: remove all rows from it without a transaction

    • getUsedLibraries

      public String[] getUsedLibraries()
      Specified by:
      getUsedLibraries in interface DatabaseInterface
      Overrides:
      getUsedLibraries in class IngresDatabaseMeta
      Returns:
      the required libraries (in lib) for this database connection.

    • supportsGetBlob

      public boolean supportsGetBlob()
      Specified by:
      supportsGetBlob in interface DatabaseInterface
      Overrides:
      supportsGetBlob in class IngresDatabaseMeta
      Returns:
      true if the database JDBC driver supports getBlob on the resultset. If not we must use getBytes() to get the data.