/** * Check whether the sequence exists, Oracle only! * * @param sequenceName The name of the sequence * @return true if the sequence exists. */ public boolean checkSequenceExists( String sequenceName ) throws KettleDatabaseException { return checkSequenceExists( null, sequenceName ); }
try { db.connect(); if ( db.checkSequenceExists( transMeta.environmentSubstitute( schemaName ), transMeta .environmentSubstitute( sequenceName ) ) ) { cr =
if ( db.checkSequenceExists( sequenceFrom ) ) { error_message = BaseMessages
if ( db.checkSequenceExists( sequenceName ) ) { error_message = BaseMessages.getString( PKG, "DimensionLookupMeta.CheckResult.SequenceExists", sequenceName );
@Override public SQLStatement getSQLStatements( TransMeta transMeta, StepMeta stepMeta, RowMetaInterface prev, Repository repository, IMetaStore metaStore ) { SQLStatement retval = new SQLStatement( stepMeta.getName(), database, null ); // default: nothing to do! if ( useDatabase ) { // Otherwise, don't bother! if ( database != null ) { Database db = new Database( loggingObject, database ); db.shareVariablesWith( transMeta ); try { db.connect(); if ( !db.checkSequenceExists( schemaName, sequenceName ) ) { String cr_table = db.getCreateSequenceStatement( sequenceName, startAt, incrementBy, maxValue, true ); retval.setSQL( cr_table ); } else { retval.setSQL( null ); // Empty string means: nothing to do: set it to null... } } catch ( KettleException e ) { retval.setError( BaseMessages.getString( PKG, "AddSequenceMeta.ErrorMessage.UnableToConnectDB" ) + Const.CR + e.getMessage() ); } finally { db.disconnect(); } } else { retval.setError( BaseMessages.getString( PKG, "AddSequenceMeta.ErrorMessage.NoConnectionDefined" ) ); } } return retval; }
if ( !db.checkSequenceExists( schemaName, sequenceName ) ) { sql += db.getCreateSequenceStatement( schemaName, sequenceName, 1L, 1L, -1L, true );
if ( !db.checkSequenceExists( schemaName, sequenceFrom ) ) { cr_seq += db.getCreateSequenceStatement( schemaName, sequenceFrom, 1L, 1L, -1L, true ); cr_seq += Const.CR;