/*! ******************************************************************************
*
* Pentaho Data Integration
*
* Copyright (C) 2002-2016 by Pentaho : http://www.pentaho.com
*
*******************************************************************************
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with
* the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*
******************************************************************************/
package org.pentaho.di.ui.trans.steps.addsequence;
import org.eclipse.swt.SWT;
import org.eclipse.swt.custom.CCombo;
import org.eclipse.swt.events.ModifyEvent;
import org.eclipse.swt.events.ModifyListener;
import org.eclipse.swt.events.SelectionAdapter;
import org.eclipse.swt.events.SelectionEvent;
import org.eclipse.swt.events.ShellAdapter;
import org.eclipse.swt.events.ShellEvent;
import org.eclipse.swt.layout.FormAttachment;
import org.eclipse.swt.layout.FormData;
import org.eclipse.swt.layout.FormLayout;
import org.eclipse.swt.widgets.Button;
import org.eclipse.swt.widgets.Display;
import org.eclipse.swt.widgets.Event;
import org.eclipse.swt.widgets.Group;
import org.eclipse.swt.widgets.Label;
import org.eclipse.swt.widgets.Listener;
import org.eclipse.swt.widgets.MessageBox;
import org.eclipse.swt.widgets.Shell;
import org.eclipse.swt.widgets.Text;
import org.pentaho.di.core.Const;
import org.pentaho.di.core.util.Utils;
import org.pentaho.di.core.database.Database;
import org.pentaho.di.core.database.DatabaseMeta;
import org.pentaho.di.i18n.BaseMessages;
import org.pentaho.di.trans.TransMeta;
import org.pentaho.di.trans.step.BaseStepMeta;
import org.pentaho.di.trans.step.StepDialogInterface;
import org.pentaho.di.trans.steps.addsequence.AddSequenceMeta;
import org.pentaho.di.ui.core.dialog.EnterSelectionDialog;
import org.pentaho.di.ui.core.dialog.ErrorDialog;
import org.pentaho.di.ui.core.widget.TextVar;
import org.pentaho.di.ui.trans.step.BaseStepDialog;
public class AddSequenceDialog extends BaseStepDialog implements StepDialogInterface {
private static Class<?> PKG = AddSequenceMeta.class; // for i18n purposes, needed by Translator2!!
private Label wlValuename;
private Text wValuename;
private Group gDatabase, gCounter;
private FormData fdDatabase, fdCounter;
private Label wlUseDatabase;
private Button wUseDatabase;
private Button wbSequence;
private FormData fdbSequence;
private Label wlConnection;
private CCombo wConnection;
private Button wbnConnection, wbeConnection, wbwConnection;
private Label wlSchema;
private TextVar wSchema;
private FormData fdbSchema;
private Button wbSchema;
private Label wlSeqname;
private TextVar wSeqname;
private Label wlUseCounter;
private Button wUseCounter;
private Label wlCounterName;
private Text wCounterName;
private Label wlStartAt;
private TextVar wStartAt;
private Label wlIncrBy;
private TextVar wIncrBy;
private Label wlMaxVal;
private TextVar wMaxVal;
private AddSequenceMeta input;
public AddSequenceDialog( Shell parent, Object in, TransMeta transMeta, String sname ) {
super( parent, (BaseStepMeta) in, transMeta, sname );
input = (AddSequenceMeta) in;
}
public String open() {
Shell parent = getParent();
Display display = parent.getDisplay();
shell = new Shell( parent, SWT.DIALOG_TRIM | SWT.RESIZE | SWT.MAX | SWT.MIN );
props.setLook( shell );
setShellImage( shell, input );
ModifyListener lsMod = new ModifyListener() {
public void modifyText( ModifyEvent e ) {
input.setChanged();
}
};
changed = input.hasChanged();
FormLayout formLayout = new FormLayout();
formLayout.marginWidth = Const.FORM_MARGIN;
formLayout.marginHeight = Const.FORM_MARGIN;
shell.setLayout( formLayout );
shell.setText( BaseMessages.getString( PKG, "AddSequenceDialog.Shell.Title" ) );
int middle = props.getMiddlePct();
int margin = Const.MARGIN;
// Stepname line
wlStepname = new Label( shell, SWT.RIGHT );
wlStepname.setText( BaseMessages.getString( PKG, "AddSequenceDialog.StepName.Label" ) );
props.setLook( wlStepname );
fdlStepname = new FormData();
fdlStepname.left = new FormAttachment( 0, 0 );
fdlStepname.right = new FormAttachment( middle, -margin );
fdlStepname.top = new FormAttachment( 0, margin );
wlStepname.setLayoutData( fdlStepname );
wStepname = new Text( shell, SWT.SINGLE | SWT.LEFT | SWT.BORDER );
wStepname.setText( stepname );
props.setLook( wStepname );
wStepname.addModifyListener( lsMod );
fdStepname = new FormData();
fdStepname.left = new FormAttachment( middle, 0 );
fdStepname.top = new FormAttachment( 0, margin );
fdStepname.right = new FormAttachment( 100, 0 );
wStepname.setLayoutData( fdStepname );
// Valuename line
wlValuename = new Label( shell, SWT.RIGHT );
wlValuename.setText( BaseMessages.getString( PKG, "AddSequenceDialog.Valuename.Label" ) );
props.setLook( wlValuename );
FormData fdlValuename = new FormData();
fdlValuename.left = new FormAttachment( 0, 0 );
fdlValuename.top = new FormAttachment( wStepname, margin );
fdlValuename.right = new FormAttachment( middle, -margin );
wlValuename.setLayoutData( fdlValuename );
wValuename = new Text( shell, SWT.SINGLE | SWT.LEFT | SWT.BORDER );
wValuename.setText( "" );
props.setLook( wValuename );
wValuename.addModifyListener( lsMod );
FormData fdValuename = new FormData();
fdValuename.left = new FormAttachment( middle, 0 );
fdValuename.top = new FormAttachment( wStepname, margin );
fdValuename.right = new FormAttachment( 100, 0 );
wValuename.setLayoutData( fdValuename );
gDatabase = new Group( shell, SWT.NONE );
gDatabase.setText( BaseMessages.getString( PKG, "AddSequenceDialog.UseDatabaseGroup.Label" ) );
FormLayout databaseLayout = new FormLayout();
databaseLayout.marginHeight = margin;
databaseLayout.marginWidth = margin;
gDatabase.setLayout( databaseLayout );
props.setLook( gDatabase );
fdDatabase = new FormData();
fdDatabase.left = new FormAttachment( 0, 0 );
fdDatabase.right = new FormAttachment( 100, 0 );
fdDatabase.top = new FormAttachment( wValuename, 2 * margin );
gDatabase.setLayoutData( fdDatabase );
wlUseDatabase = new Label( gDatabase, SWT.RIGHT );
wlUseDatabase.setText( BaseMessages.getString( PKG, "AddSequenceDialog.UseDatabase.Label" ) );
props.setLook( wlUseDatabase );
FormData fdlUseDatabase = new FormData();
fdlUseDatabase.left = new FormAttachment( 0, 0 );
fdlUseDatabase.top = new FormAttachment( 0, 0 );
fdlUseDatabase.right = new FormAttachment( middle, -margin );
wlUseDatabase.setLayoutData( fdlUseDatabase );
wUseDatabase = new Button( gDatabase, SWT.CHECK );
props.setLook( wUseDatabase );
wUseDatabase.setToolTipText( BaseMessages.getString( PKG, "AddSequenceDialog.UseDatabase.Tooltip" ) );
FormData fdUseDatabase = new FormData();
fdUseDatabase.left = new FormAttachment( middle, 0 );
fdUseDatabase.top = new FormAttachment( 0, 0 );
wUseDatabase.setLayoutData( fdUseDatabase );
wUseDatabase.addSelectionListener( new SelectionAdapter() {
public void widgetSelected( SelectionEvent e ) {
wUseCounter.setSelection( !wUseDatabase.getSelection() );
enableFields();
input.setChanged();
}
} );
// Connection line
wlConnection = new Label( gDatabase, SWT.RIGHT );
wbwConnection = new Button( gDatabase, SWT.PUSH );
wbnConnection = new Button( gDatabase, SWT.PUSH );
wbeConnection = new Button( gDatabase, SWT.PUSH );
wConnection =
addConnectionLine(
gDatabase, wUseDatabase, middle, margin, wlConnection, wbwConnection, wbnConnection, wbeConnection );
if ( input.getDatabase() == null && transMeta.nrDatabases() == 1 ) {
wConnection.select( 0 );
}
wConnection.addModifyListener( lsMod );
wConnection.addModifyListener( new ModifyListener() {
public void modifyText( ModifyEvent e ) {
activeSequence();
}
} );
// Schema line...
wlSchema = new Label( gDatabase, SWT.RIGHT );
wlSchema.setText( BaseMessages.getString( PKG, "AddSequenceDialog.TargetSchema.Label" ) );
props.setLook( wlSchema );
FormData fdlSchema = new FormData();
fdlSchema.left = new FormAttachment( 0, 0 );
fdlSchema.right = new FormAttachment( middle, -margin );
fdlSchema.top = new FormAttachment( wConnection, 2 * margin );
wlSchema.setLayoutData( fdlSchema );
wbSchema = new Button( gDatabase, SWT.PUSH | SWT.CENTER );
props.setLook( wbSchema );
wbSchema.setText( BaseMessages.getString( PKG, "AddSequenceDialog.GetSchemas.Label" ) );
fdbSchema = new FormData();
fdbSchema.top = new FormAttachment( wConnection, 2 * margin );
fdbSchema.right = new FormAttachment( 100, 0 );
wbSchema.setLayoutData( fdbSchema );
wSchema = new TextVar( transMeta, gDatabase, SWT.SINGLE | SWT.LEFT | SWT.BORDER );
props.setLook( wSchema );
wSchema.addModifyListener( lsMod );
FormData fdSchema = new FormData();
fdSchema.left = new FormAttachment( middle, 0 );
fdSchema.top = new FormAttachment( wConnection, 2 * margin );
fdSchema.right = new FormAttachment( wbSchema, -margin );
wSchema.setLayoutData( fdSchema );
// Seqname line
wlSeqname = new Label( gDatabase, SWT.RIGHT );
wlSeqname.setText( BaseMessages.getString( PKG, "AddSequenceDialog.Seqname.Label" ) );
props.setLook( wlSeqname );
FormData fdlSeqname = new FormData();
fdlSeqname.left = new FormAttachment( 0, 0 );
fdlSeqname.right = new FormAttachment( middle, -margin );
fdlSeqname.top = new FormAttachment( wbSchema, margin );
wlSeqname.setLayoutData( fdlSeqname );
wbSequence = new Button( gDatabase, SWT.PUSH | SWT.CENTER );
props.setLook( wbSequence );
wbSequence.setText( BaseMessages.getString( PKG, "AddSequenceDialog.GetSequences.Label" ) );
fdbSequence = new FormData();
fdbSequence.right = new FormAttachment( 100, -margin );
fdbSequence.top = new FormAttachment( wbSchema, margin );
wbSequence.setLayoutData( fdbSequence );
wSeqname = new TextVar( transMeta, gDatabase, SWT.SINGLE | SWT.LEFT | SWT.BORDER );
wSeqname.setText( "" );
props.setLook( wSeqname );
wSeqname.addModifyListener( lsMod );
FormData fdSeqname = new FormData();
fdSeqname.left = new FormAttachment( middle, 0 );
fdSeqname.top = new FormAttachment( wbSchema, margin );
fdSeqname.right = new FormAttachment( wbSequence, -margin );
wSeqname.setLayoutData( fdSeqname );
gCounter = new Group( shell, SWT.NONE );
gCounter.setText( BaseMessages.getString( PKG, "AddSequenceDialog.UseCounterGroup.Label" ) );
FormLayout counterLayout = new FormLayout();
counterLayout.marginHeight = margin;
counterLayout.marginWidth = margin;
gCounter.setLayout( counterLayout );
props.setLook( gCounter );
fdCounter = new FormData();
fdCounter.left = new FormAttachment( 0, 0 );
fdCounter.right = new FormAttachment( 100, 0 );
fdCounter.top = new FormAttachment( gDatabase, 2 * margin );
gCounter.setLayoutData( fdCounter );
wlUseCounter = new Label( gCounter, SWT.RIGHT );
wlUseCounter.setText( BaseMessages.getString( PKG, "AddSequenceDialog.UseCounter.Label" ) );
props.setLook( wlUseCounter );
FormData fdlUseCounter = new FormData();
fdlUseCounter.left = new FormAttachment( 0, 0 );
fdlUseCounter.top = new FormAttachment( wSeqname, margin );
fdlUseCounter.right = new FormAttachment( middle, -margin );
wlUseCounter.setLayoutData( fdlUseCounter );
wUseCounter = new Button( gCounter, SWT.CHECK );
props.setLook( wUseCounter );
wUseCounter.setToolTipText( BaseMessages.getString( PKG, "AddSequenceDialog.UseCounter.Tooltip" ) );
FormData fdUseCounter = new FormData();
fdUseCounter.left = new FormAttachment( middle, 0 );
fdUseCounter.top = new FormAttachment( wSeqname, margin );
wUseCounter.setLayoutData( fdUseCounter );
wUseCounter.addSelectionListener( new SelectionAdapter() {
public void widgetSelected( SelectionEvent e ) {
wUseDatabase.setSelection( !wUseCounter.getSelection() );
enableFields();
input.setChanged();
}
} );
// CounterName line
wlCounterName = new Label( gCounter, SWT.RIGHT );
wlCounterName.setText( BaseMessages.getString( PKG, "AddSequenceDialog.CounterName.Label" ) );
props.setLook( wlCounterName );
FormData fdlCounterName = new FormData();
fdlCounterName.left = new FormAttachment( 0, 0 );
fdlCounterName.right = new FormAttachment( middle, -margin );
fdlCounterName.top = new FormAttachment( wUseCounter, margin );
wlCounterName.setLayoutData( fdlCounterName );
wCounterName = new Text( gCounter, SWT.SINGLE | SWT.LEFT | SWT.BORDER );
wCounterName.setText( "" );
props.setLook( wCounterName );
wCounterName.addModifyListener( lsMod );
FormData fdCounterName = new FormData();
fdCounterName.left = new FormAttachment( middle, 0 );
fdCounterName.top = new FormAttachment( wUseCounter, margin );
fdCounterName.right = new FormAttachment( 100, 0 );
wCounterName.setLayoutData( fdCounterName );
// StartAt line
wlStartAt = new Label( gCounter, SWT.RIGHT );
wlStartAt.setText( BaseMessages.getString( PKG, "AddSequenceDialog.StartAt.Label" ) );
props.setLook( wlStartAt );
FormData fdlStartAt = new FormData();
fdlStartAt.left = new FormAttachment( 0, 0 );
fdlStartAt.right = new FormAttachment( middle, -margin );
fdlStartAt.top = new FormAttachment( wCounterName, margin );
wlStartAt.setLayoutData( fdlStartAt );
wStartAt = new TextVar( transMeta, gCounter, SWT.SINGLE | SWT.LEFT | SWT.BORDER );
wStartAt.setText( "" );
props.setLook( wStartAt );
wStartAt.addModifyListener( lsMod );
FormData fdStartAt = new FormData();
fdStartAt.left = new FormAttachment( middle, 0 );
fdStartAt.top = new FormAttachment( wCounterName, margin );
fdStartAt.right = new FormAttachment( 100, 0 );
wStartAt.setLayoutData( fdStartAt );
// IncrBy line
wlIncrBy = new Label( gCounter, SWT.RIGHT );
wlIncrBy.setText( BaseMessages.getString( PKG, "AddSequenceDialog.IncrBy.Label" ) );
props.setLook( wlIncrBy );
FormData fdlIncrBy = new FormData();
fdlIncrBy.left = new FormAttachment( 0, 0 );
fdlIncrBy.right = new FormAttachment( middle, -margin );
fdlIncrBy.top = new FormAttachment( wStartAt, margin );
wlIncrBy.setLayoutData( fdlIncrBy );
wIncrBy = new TextVar( transMeta, gCounter, SWT.SINGLE | SWT.LEFT | SWT.BORDER );
wIncrBy.setText( "" );
props.setLook( wIncrBy );
wIncrBy.addModifyListener( lsMod );
FormData fdIncrBy = new FormData();
fdIncrBy.left = new FormAttachment( middle, 0 );
fdIncrBy.top = new FormAttachment( wStartAt, margin );
fdIncrBy.right = new FormAttachment( 100, 0 );
wIncrBy.setLayoutData( fdIncrBy );
// MaxVal line
wlMaxVal = new Label( gCounter, SWT.RIGHT );
wlMaxVal.setText( BaseMessages.getString( PKG, "AddSequenceDialog.MaxVal.Label" ) );
props.setLook( wlMaxVal );
FormData fdlMaxVal = new FormData();
fdlMaxVal.left = new FormAttachment( 0, 0 );
fdlMaxVal.right = new FormAttachment( middle, -margin );
fdlMaxVal.top = new FormAttachment( wIncrBy, margin );
wlMaxVal.setLayoutData( fdlMaxVal );
wMaxVal = new TextVar( transMeta, gCounter, SWT.SINGLE | SWT.LEFT | SWT.BORDER );
wMaxVal.setText( "" );
props.setLook( wMaxVal );
wMaxVal.addModifyListener( lsMod );
FormData fdMaxVal = new FormData();
fdMaxVal.left = new FormAttachment( middle, 0 );
fdMaxVal.top = new FormAttachment( wIncrBy, margin );
fdMaxVal.right = new FormAttachment( 100, 0 );
wMaxVal.setLayoutData( fdMaxVal );
wbSequence.addSelectionListener( new SelectionAdapter() {
public void widgetSelected( SelectionEvent e ) {
getSequences();
}
} );
wbSchema.addSelectionListener( new SelectionAdapter() {
public void widgetSelected( SelectionEvent e ) {
getSchemaNames();
}
} );
// THE BUTTONS
wOK = new Button( shell, SWT.PUSH );
wOK.setText( BaseMessages.getString( PKG, "System.Button.OK" ) );
wCancel = new Button( shell, SWT.PUSH );
wCancel.setText( BaseMessages.getString( PKG, "System.Button.Cancel" ) );
setButtonPositions( new Button[] { wOK, wCancel }, margin, gCounter );
// Add listeners
lsOK = new Listener() {
public void handleEvent( Event e ) {
ok();
}
};
lsCancel = new Listener() {
public void handleEvent( Event e ) {
cancel();
}
};
wOK.addListener( SWT.Selection, lsOK );
wCancel.addListener( SWT.Selection, lsCancel );
lsDef = new SelectionAdapter() {
public void widgetDefaultSelected( SelectionEvent e ) {
ok();
}
};
wStepname.addSelectionListener( lsDef );
wValuename.addSelectionListener( lsDef );
wSchema.addSelectionListener( lsDef );
wSeqname.addSelectionListener( lsDef );
wStartAt.addSelectionListener( lsDef );
wIncrBy.addSelectionListener( lsDef );
wMaxVal.addSelectionListener( lsDef );
wCounterName.addSelectionListener( lsDef );
// Detect X or ALT-F4 or something that kills this window...
shell.addShellListener( new ShellAdapter() {
public void shellClosed( ShellEvent e ) {
cancel();
}
} );
// Set the shell size, based upon previous time...
setSize();
getData();
input.setChanged( changed );
shell.open();
while ( !shell.isDisposed() ) {
if ( !display.readAndDispatch() ) {
display.sleep();
}
}
return stepname;
}
public void enableFields() {
boolean useDatabase = wUseDatabase.getSelection();
boolean useCounter = wUseCounter.getSelection();
wbSchema.setEnabled( useDatabase );
wlConnection.setEnabled( useDatabase );
wConnection.setEnabled( useDatabase );
wbwConnection.setEnabled( useDatabase );
wbnConnection.setEnabled( useDatabase );
wbeConnection.setEnabled( useDatabase );
wlSchema.setEnabled( useDatabase );
wSchema.setEnabled( useDatabase );
wlSeqname.setEnabled( useDatabase );
wSeqname.setEnabled( useDatabase );
wlCounterName.setEnabled( useCounter );
wCounterName.setEnabled( useCounter );
wlStartAt.setEnabled( useCounter );
wStartAt.setEnabled( useCounter );
wlIncrBy.setEnabled( useCounter );
wIncrBy.setEnabled( useCounter );
wlMaxVal.setEnabled( useCounter );
wMaxVal.setEnabled( useCounter );
activeSequence();
}
/**
* Copy information from the meta-data input to the dialog fields.
*/
public void getData() {
logDebug( BaseMessages.getString( PKG, "AddSequenceDialog.Log.GettingKeyInfo" ) );
if ( input.getValuename() != null ) {
wValuename.setText( input.getValuename() );
}
wUseDatabase.setSelection( input.isDatabaseUsed() );
if ( input.getDatabase() != null ) {
wConnection.setText( input.getDatabase().getName() );
} else if ( transMeta.nrDatabases() == 1 ) {
wConnection.setText( transMeta.getDatabase( 0 ).getName() );
}
if ( input.getSchemaName() != null ) {
wSchema.setText( input.getSchemaName() );
}
if ( input.getSequenceName() != null ) {
wSeqname.setText( input.getSequenceName() );
}
wUseCounter.setSelection( input.isCounterUsed() );
wCounterName.setText( Const.NVL( input.getCounterName(), "" ) );
wStartAt.setText( input.getStartAt() );
wIncrBy.setText( input.getIncrementBy() );
wMaxVal.setText( input.getMaxValue() );
enableFields();
wStepname.selectAll();
wStepname.setFocus();
}
private void cancel() {
stepname = null;
input.setChanged( changed );
dispose();
}
private void ok() {
if ( Utils.isEmpty( wStepname.getText() ) ) {
return;
}
stepname = wStepname.getText(); // return value
input.setUseCounter( wUseCounter.getSelection() );
input.setUseDatabase( wUseDatabase.getSelection() );
String connection = wConnection.getText();
input.setDatabase( transMeta.findDatabase( connection ) );
input.setSchemaName( wSchema.getText() );
input.setSequenceName( wSeqname.getText() );
input.setValuename( wValuename.getText() );
input.setCounterName( wCounterName.getText() );
input.setStartAt( wStartAt.getText() );
input.setIncrementBy( wIncrBy.getText() );
input.setMaxValue( wMaxVal.getText() );
if ( input.isDatabaseUsed() && transMeta.findDatabase( connection ) == null ) {
MessageBox mb = new MessageBox( shell, SWT.OK | SWT.ICON_ERROR );
mb.setMessage( BaseMessages.getString( PKG, "AddSequenceDialog.NoValidConnectionError.DialogMessage" ) );
mb.setText( BaseMessages.getString( PKG, "AddSequenceDialog.NoValidConnectionError.DialogTitle" ) );
mb.open();
}
dispose();
}
private void activeSequence() {
boolean useDatabase = wUseDatabase.getSelection();
DatabaseMeta databaseMeta = transMeta.findDatabase( wConnection.getText() );
wbSequence.setEnabled( databaseMeta == null ? false : useDatabase && databaseMeta.supportsSequences() );
}
private void getSequences() {
DatabaseMeta databaseMeta = transMeta.findDatabase( wConnection.getText() );
if ( databaseMeta != null ) {
Database database = new Database( loggingObject, databaseMeta );
try {
database.connect();
String[] sequences = database.getSequences();
if ( null != sequences && sequences.length > 0 ) {
sequences = Const.sortStrings( sequences );
EnterSelectionDialog dialog =
new EnterSelectionDialog( shell, sequences,
BaseMessages.getString( PKG, "AddSequenceDialog.SelectSequence.Title", wConnection.getText() ),
BaseMessages.getString( PKG, "AddSequenceDialog.SelectSequence.Message" ) );
String d = dialog.open();
if ( d != null ) {
wSeqname.setText( Const.NVL( d.toString(), "" ) );
}
} else {
MessageBox mb = new MessageBox( shell, SWT.OK | SWT.ICON_ERROR );
mb.setMessage( BaseMessages.getString( PKG, "AddSequenceDialog.NoSequence.Message" ) );
mb.setText( BaseMessages.getString( PKG, "AddSequenceDialog.NoSequence.Title" ) );
mb.open();
}
} catch ( Exception e ) {
new ErrorDialog( shell, BaseMessages.getString( PKG, "System.Dialog.Error.Title" ), BaseMessages
.getString( PKG, "AddSequenceDialog.ErrorGettingSequences" ), e );
} finally {
if ( database != null ) {
database.disconnect();
database = null;
}
}
}
}
private void getSchemaNames() {
if ( wSchema.isDisposed() ) {
return;
}
DatabaseMeta databaseMeta = transMeta.findDatabase( wConnection.getText() );
if ( databaseMeta != null ) {
Database database = new Database( loggingObject, databaseMeta );
try {
database.connect();
String[] schemas = database.getSchemas();
if ( null != schemas && schemas.length > 0 ) {
schemas = Const.sortStrings( schemas );
EnterSelectionDialog dialog =
new EnterSelectionDialog( shell, schemas,
BaseMessages.getString( PKG, "AddSequenceDialog.SelectSequence.Title", wConnection.getText() ),
BaseMessages.getString( PKG, "AddSequenceDialog.SelectSequence.Message" ) );
String d = dialog.open();
if ( d != null ) {
wSchema.setText( Const.NVL( d.toString(), "" ) );
}
} else {
MessageBox mb = new MessageBox( shell, SWT.OK | SWT.ICON_ERROR );
mb.setMessage( BaseMessages.getString( PKG, "AddSequenceDialog.NoSchema.Message" ) );
mb.setText( BaseMessages.getString( PKG, "AddSequenceDialog.NoSchema.Title" ) );
mb.open();
}
} catch ( Exception e ) {
new ErrorDialog( shell, BaseMessages.getString( PKG, "System.Dialog.Error.Title" ), BaseMessages
.getString( PKG, "AddSequenceDialog.ErrorGettingSchemas" ), e );
} finally {
if ( database != null ) {
database.disconnect();
database = null;
}
}
}
}
}