/** * Returns max VARCHAR length depending on db interface */ protected int getRepoStringLength() { return database.getDatabaseMeta().getDatabaseInterface().getMaxVARCHARLength() - 1 > 0 ? database.getDatabaseMeta() .getDatabaseInterface().getMaxVARCHARLength() - 1 : KettleDatabaseRepository.REP_ORACLE_STRING_LENGTH; }
public static final int getPortForDBType( String strtype, String straccess ) { try { DatabaseInterface di = getDatabaseInterface( strtype ); di.setAccessType( getAccessType( straccess ) ); return di.getDefaultDatabasePort(); } catch ( KettleDatabaseException kde ) { return -1; } }
/** * @param tableName * The tablename to be truncated * @return The SQL statement to remove all rows from the specified statement, if possible without using transactions */ public String getTruncateTableStatement( String schema, String tableName ) { return databaseInterface.getTruncateTableStatement( getQuotedSchemaTableCombination( schema, tableName ) ); }
/** * Add a list of common options for some databases. * */ public void addOptions() { databaseInterface.addDefaultOptions(); setSupportsBooleanDataType( true ); setSupportsTimestampDataType( true ); }
@Override public boolean isMySQLVariant() { if ( databaseDialect != null ) { return databaseDialect.isMySQLVariant(); } return super.isMySQLVariant(); }
@Override public boolean isExplorable() { if ( databaseDialect != null ) { return databaseDialect.isExplorable(); } return super.isExplorable(); }
/** * @see DatabaseInterface#getNotFoundTK(boolean) */ @Override public int getNotFoundTK( boolean use_autoinc ) { if ( supportsAutoInc() && use_autoinc ) { return 0; } return super.getNotFoundTK( use_autoinc ); }
/** * @see DatabaseInterface#getNotFoundTK(boolean) */ @Override public int getNotFoundTK( boolean use_autoinc ) { if ( supportsAutoInc() && use_autoinc ) { return 1; } return super.getNotFoundTK( use_autoinc ); }
@Override public String[] getReservedWords() { if ( databaseDialect != null ) { return databaseDialect.getReservedWords(); } return super.getReservedWords(); }
@Override public String getCreateTableStatement() { if ( databaseDialect != null ) { return databaseDialect.getCreateTableStatement(); } return super.getCreateTableStatement(); }
@Override public void setSupportsTimestampDataType( boolean b ) { if ( databaseDialect != null ) { databaseDialect.setSupportsTimestampDataType( b ); } super.setSupportsTimestampDataType( b ); }
@Override public ValueMetaInterface customizeValueFromSQLType( ValueMetaInterface v, java.sql.ResultSetMetaData rm, int index ) throws SQLException { if ( databaseDialect != null ) { return databaseDialect.customizeValueFromSQLType( v, rm, index ); } return super.customizeValueFromSQLType( v, rm, index ); }
@Override public boolean supportsNewLinesInSQL() { if ( databaseDialect != null ) { return databaseDialect.supportsNewLinesInSQL(); } return super.supportsNewLinesInSQL(); }
@Override public boolean isQuoteAllFields() { if ( databaseDialect != null ) { return databaseDialect.isQuoteAllFields(); } return super.isQuoteAllFields(); }
@Override public void setStreamingResults( boolean useStreaming ) { if ( databaseDialect != null ) { databaseDialect.setStreamingResults( useStreaming ); } super.setStreamingResults( useStreaming ); }
@Override public boolean needsToLockAllTables() { if ( databaseDialect != null ) { return databaseDialect.needsToLockAllTables(); } return super.needsToLockAllTables(); }
@Override public boolean preserveReservedCase() { if ( databaseDialect != null ) { return databaseDialect.preserveReservedCase(); } return super.preserveReservedCase(); }
@Override public String[] getSynonymTypes() { if ( databaseDialect != null ) { return databaseDialect.getSynonymTypes(); } return super.getSynonymTypes(); }
@Override public String[] getViewTypes() { if ( databaseDialect != null ) { return databaseDialect.getViewTypes(); } return super.getViewTypes(); }
@Override public String getStartQuote() { if ( databaseDialect != null ) { return databaseDialect.getStartQuote(); } return super.getStartQuote(); }