|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object org.pentaho.di.core.database.BaseDatabaseMeta org.pentaho.di.core.database.NeoviewDatabaseMeta
public class NeoviewDatabaseMeta
Contains HP Neoview specific information through static final members
Field Summary |
---|
Constructor Summary | |
---|---|
NeoviewDatabaseMeta()
|
Method Summary | |
---|---|
int[] |
getAccessTypeList()
Get the list of possible access types for a database. |
String |
getAddColumnStatement(String tablename,
ValueMetaInterface v,
String tk,
boolean use_autoinc,
String pk,
boolean semicolon)
Generates the SQL statement to add a column to the specified table |
int |
getDefaultDatabasePort()
|
String |
getDriverClass()
Obtain the name of the JDBC driver class that we need to use! |
String |
getDropColumnStatement(String tablename,
ValueMetaInterface v,
String tk,
boolean use_autoinc,
String pk,
boolean semicolon)
Generates the SQL statement to drop a column from the specified table |
String |
getExtraOptionsHelpText()
|
String |
getFieldDefinition(ValueMetaInterface v,
String tk,
String pk,
boolean use_autoinc,
boolean add_fieldname,
boolean add_cr)
Describe a Value as a field in the database. |
String |
getLimitClause(int nrRows)
|
int |
getMaxVARCHARLength()
Get the maximum length of a text field (VARCHAR) for this database connection. |
String |
getModifyColumnStatement(String tablename,
ValueMetaInterface v,
String tk,
boolean use_autoinc,
String pk,
boolean semicolon)
Generates the SQL statement to modify a column in the specified table |
String[] |
getReservedWords()
|
String |
getSQLColumnExists(String columnname,
String tablename)
|
String |
getSQLLockTables(String[] tableNames)
|
String |
getSQLQueryColumnFields(String columnname,
String tableName)
|
String |
getSQLQueryFields(String tableName)
Returns the minimal SQL to launch in order to determine the layout of the resultset for a given database table |
String |
getSQLTableExists(String tablename)
|
String |
getSQLUnlockTables(String[] tableNames)
|
String |
getTruncateTableStatement(String tableName)
|
String |
getURL(String hostname,
String port,
String databaseName)
|
String[] |
getUsedLibraries()
|
Object |
getValueFromResultSet(ResultSet rs,
ValueMetaInterface val,
int i)
This method allows a database dialect to convert database specific data types to Kettle data types. |
boolean |
needsToLockAllTables()
|
boolean |
supportsAutoInc()
|
boolean |
supportsBitmapIndex()
|
boolean |
supportsOptionsInURL()
Neoview supports options in the URL. |
boolean |
supportsRepository()
|
boolean |
supportsSynonyms()
|
boolean |
useSchemaNameForTableList()
|
Methods inherited from class java.lang.Object |
---|
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Constructor Detail |
---|
public NeoviewDatabaseMeta()
Method Detail |
---|
public int[] getAccessTypeList()
DatabaseInterface
getAccessTypeList
in interface DatabaseInterface
getAccessTypeList
in class BaseDatabaseMeta
public int getDefaultDatabasePort()
getDefaultDatabasePort
in interface DatabaseInterface
getDefaultDatabasePort
in class BaseDatabaseMeta
public boolean supportsAutoInc()
supportsAutoInc
in interface DatabaseInterface
supportsAutoInc
in class BaseDatabaseMeta
public String getLimitClause(int nrRows)
getLimitClause
in interface DatabaseInterface
getLimitClause
in class BaseDatabaseMeta
nrRows
- The number of rows to which we want to limit the result of the query.
DatabaseInterface.getLimitClause(int)
public String getSQLQueryFields(String tableName)
getSQLQueryFields
in interface DatabaseInterface
getSQLQueryFields
in class BaseDatabaseMeta
tableName
- The name of the table to determine the layout for
public String getSQLTableExists(String tablename)
getSQLTableExists
in interface DatabaseInterface
getSQLTableExists
in class BaseDatabaseMeta
tablename
- The table to verify the existance for
public String getSQLColumnExists(String columnname, String tablename)
getSQLColumnExists
in interface DatabaseInterface
getSQLColumnExists
in class BaseDatabaseMeta
tablename
- The table to verify the existance for
public String getSQLQueryColumnFields(String columnname, String tableName)
public boolean needsToLockAllTables()
needsToLockAllTables
in interface DatabaseInterface
needsToLockAllTables
in class BaseDatabaseMeta
public String getDriverClass()
DatabaseInterface
getDriverClass
in interface DatabaseInterface
public String getURL(String hostname, String port, String databaseName) throws KettleDatabaseException
getURL
in interface DatabaseInterface
hostname
- the hostnameport
- the port as a stringdatabaseName
- the database name
KettleDatabaseException
- in case a configuration error is detected.public boolean supportsOptionsInURL()
supportsOptionsInURL
in interface DatabaseInterface
supportsOptionsInURL
in class BaseDatabaseMeta
public boolean useSchemaNameForTableList()
useSchemaNameForTableList
in interface DatabaseInterface
useSchemaNameForTableList
in class BaseDatabaseMeta
public boolean supportsSynonyms()
supportsSynonyms
in interface DatabaseInterface
supportsSynonyms
in class BaseDatabaseMeta
public String getAddColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean use_autoinc, String pk, boolean semicolon)
getAddColumnStatement
in interface DatabaseInterface
tablename
- The table to addv
- The column defined as a valuetk
- the name of the technical key fielduse_autoinc
- whether or not this field uses auto incrementpk
- the name of the primary key fieldsemicolon
- whether or not to add a semi-colon behind the statement.
public String getDropColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean use_autoinc, String pk, boolean semicolon)
getDropColumnStatement
in interface DatabaseInterface
getDropColumnStatement
in class BaseDatabaseMeta
tablename
- The table to addv
- The column defined as a valuetk
- the name of the technical key fielduse_autoinc
- whether or not this field uses auto incrementpk
- the name of the primary key fieldsemicolon
- whether or not to add a semi-colon behind the statement.
public String getModifyColumnStatement(String tablename, ValueMetaInterface v, String tk, boolean use_autoinc, String pk, boolean semicolon)
getModifyColumnStatement
in interface DatabaseInterface
tablename
- The table to addv
- The column defined as a valuetk
- the name of the technical key fielduse_autoinc
- whether or not this field uses auto incrementpk
- the name of the primary key fieldsemicolon
- whether or not to add a semi-colon behind the statement.
public String getFieldDefinition(ValueMetaInterface v, String tk, String pk, boolean use_autoinc, boolean add_fieldname, boolean add_cr)
DatabaseInterface
getFieldDefinition
in interface DatabaseInterface
v
- The value to describetk
- The field that's going to be the technical keypk
- The field that's going to be the primary keyuse_autoinc
- Use autoincrement or notadd_fieldname
- Add the fieldname to the definition or notadd_cr
- Add a cariage return at the end of the definition or not.
public String[] getReservedWords()
getReservedWords
in interface DatabaseInterface
getReservedWords
in class BaseDatabaseMeta
public String getSQLLockTables(String[] tableNames)
getSQLLockTables
in interface DatabaseInterface
getSQLLockTables
in class BaseDatabaseMeta
tableNames
- The names of the tables to lock
public String getSQLUnlockTables(String[] tableNames)
getSQLUnlockTables
in interface DatabaseInterface
getSQLUnlockTables
in class BaseDatabaseMeta
tableNames
- The names of the tables to unlock
public String getExtraOptionsHelpText()
getExtraOptionsHelpText
in interface DatabaseInterface
getExtraOptionsHelpText
in class BaseDatabaseMeta
public String[] getUsedLibraries()
getUsedLibraries
in interface DatabaseInterface
public boolean supportsBitmapIndex()
supportsBitmapIndex
in interface DatabaseInterface
supportsBitmapIndex
in class BaseDatabaseMeta
public int getMaxVARCHARLength()
BaseDatabaseMeta
getMaxVARCHARLength
in interface DatabaseInterface
getMaxVARCHARLength
in class BaseDatabaseMeta
public boolean supportsRepository()
supportsRepository
in interface DatabaseInterface
supportsRepository
in class BaseDatabaseMeta
public String getTruncateTableStatement(String tableName)
getTruncateTableStatement
in interface DatabaseInterface
getTruncateTableStatement
in class BaseDatabaseMeta
tableName
- The table to be truncated.
public Object getValueFromResultSet(ResultSet rs, ValueMetaInterface val, int i) throws KettleDatabaseException
getValueFromResultSet
in interface DatabaseInterface
getValueFromResultSet
in class BaseDatabaseMeta
resultSet
- The result set to usevalueMeta
- The description of the value to retrieveindex
- the index on which we need to retrieve the value, 0-based.
KettleDatabaseException
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |