How to use

getDatabase

method

in

org.pentaho.di.job.JobMeta

/**
 * Adds the databases from the job metadata to the combo box.
 *
 * @param wConnection
 *          the w connection
 */
public void addDatabases( CCombo wConnection ) {
 for ( int i = 0; i < jobMeta.nrDatabases(); i++ ) {
  DatabaseMeta ci = jobMeta.getDatabase( i );
  wConnection.add( ci.getName() );
 }
}

DatabaseMeta dbMetaToReplace = jobMeta.getDatabase( indexToReplace );
dbMetaToReplace.setObjectId( repo.getDatabaseID( dbMetaToReplace.getName() ) );
jobMeta.removeDatabase( indexToReplace );

private void getTableName() {
 // New class: SelectTableDialog
 int connr = wConnection.getSelectionIndex();
 if ( connr >= 0 ) {
  DatabaseMeta inf = jobMeta.getDatabase( connr );
  DatabaseExplorerDialog std = new DatabaseExplorerDialog( shell, SWT.NONE, inf, jobMeta.getDatabases() );
  std.setSelectedSchemaAndTable( wSchemaname.getText(), wTablename.getText() );
  if ( std.open() ) {
   // wSchemaname.setText(Const.NVL(std.getSchemaName(), ""));
   wTablename.setText( Const.NVL( std.getTableName(), "" ) );
  }
 } else {
  MessageBox mb = new MessageBox( shell, SWT.OK | SWT.ICON_ERROR );
  mb.setMessage( BaseMessages.getString( PKG, "JobMysqlBulkFile.ConnectionError2.DialogMessage" ) );
  mb.setText( BaseMessages.getString( PKG, "System.Dialog.Error.Title" ) );
  mb.open();
 }
}

public void addDatabases() {
 connections = new String[jobMeta.nrDatabases()];
 for ( int i = 0; i < jobMeta.nrDatabases(); i++ ) {
  DatabaseMeta ci = jobMeta.getDatabase( i );
  connections[i] = ci.getName();
 }
}

private void getTableName() {
 // New class: SelectTableDialog
 int connr = wConnection.getSelectionIndex();
 if ( connr >= 0 ) {
  DatabaseMeta inf = jobMeta.getDatabase( connr );
  DatabaseExplorerDialog std = new DatabaseExplorerDialog( shell, SWT.NONE, inf, jobMeta.getDatabases() );
  std.setSelectedSchemaAndTable( wSchemaname.getText(), wTablename.getText() );
  if ( std.open() ) {
   wTablename.setText( Const.NVL( std.getTableName(), "" ) );
  }
 } else {
  MessageBox mb = new MessageBox( shell, SWT.OK | SWT.ICON_ERROR );
  mb.setMessage( BaseMessages.getString( PKG, "JobEntryWaitForSQL.ConnectionError2.DialogMessage" ) );
  mb.setText( BaseMessages.getString( PKG, "System.Dialog.Error.Title" ) );
  mb.open();
 }
}

DatabaseMeta dbMeta = getDatabase( i );
if ( props != null && props.areOnlyUsedConnectionsSavedToXML() ) {
 if ( usedDatabaseMetas.contains( dbMeta ) ) {

private void getTableName() {
 // New class: SelectTableDialog
 int connr = wConnection.getSelectionIndex();
 if ( connr >= 0 ) {
  DatabaseMeta inf = jobMeta.getDatabase( connr );
  DatabaseExplorerDialog std = new DatabaseExplorerDialog( shell, SWT.NONE, inf, jobMeta.getDatabases() );
  std.setSelectedSchemaAndTable( wSchemaname.getText(), wTablename.getText() );
  if ( std.open() ) {
   wTablename.setText( Const.NVL( std.getTableName(), "" ) );
  }
 } else {
  MessageBox mb = new MessageBox( shell, SWT.OK | SWT.ICON_ERROR );
  mb.setMessage( BaseMessages.getString( PKG, "JobMssqlBulkLoad.ConnectionError2.DialogMessage" ) );
  mb.setText( BaseMessages.getString( PKG, "System.Dialog.Error.Title" ) );
  mb.open();
 }
}

public void getDatabases() {
 wFields.removeAll();
 for ( int i = 0; i < jobMeta.nrDatabases(); i++ ) {
  DatabaseMeta ci = jobMeta.getDatabase( i );
  if ( ci != null ) {
   wFields.add( new String[] { ci.getName(), "0", JobEntryCheckDbConnections.unitTimeDesc[0] } );
  }
 }
 wFields.removeEmptyRows();
 wFields.setRowNums();
 wFields.optWidth( true );
}

private void getTableName() {
 // New class: SelectTableDialog
 int connr = wConnection.getSelectionIndex();
 if ( connr >= 0 ) {
  DatabaseMeta inf = jobMeta.getDatabase( connr );
  DatabaseExplorerDialog std = new DatabaseExplorerDialog( shell, SWT.NONE, inf, jobMeta.getDatabases() );
  std.setSelectedSchemaAndTable( wSchemaname.getText(), wTablename.getText() );
  if ( std.open() ) {
   wTablename.setText( Const.NVL( std.getTableName(), "" ) );
  }
 } else {
  MessageBox mb = new MessageBox( shell, SWT.OK | SWT.ICON_ERROR );
  mb.setMessage( BaseMessages.getString( PKG, "JobEntryEvalTableContent.ConnectionError2.DialogMessage" ) );
  mb.setText( BaseMessages.getString( PKG, "System.Dialog.Error.Title" ) );
  mb.open();
 }
}

DatabaseMeta meta = getDatabase( i );
stringList.add( new StringSearchResult( meta.getName(), meta, this,
  BaseMessages.getString( PKG, "JobMeta.SearchMetadata.DatabaseConnectionName" ) ) );

private void getTableName() {
 // New class: SelectTableDialog
 int connr = wConnection.getSelectionIndex();
 if ( connr >= 0 ) {
  DatabaseMeta inf = jobMeta.getDatabase( connr );
  DatabaseExplorerDialog std = new DatabaseExplorerDialog( shell, SWT.NONE, inf, jobMeta.getDatabases() );
  std.setSelectedSchemaAndTable( wSchemaname.getText(), wTablename.getText() );
  if ( std.open() ) {
   wTablename.setText( Const.NVL( std.getTableName(), "" ) );
  }
 } else {
  MessageBox mb = new MessageBox( shell, SWT.OK | SWT.ICON_ERROR );
  mb.setMessage( BaseMessages.getString( PKG, "JobMysqlBulkLoad.ConnectionError2.DialogMessage" ) );
  mb.setText( BaseMessages.getString( PKG, "System.Dialog.Error.Title" ) );
  mb.open();
 }
}

  + ( i + 1 ) + "/" + jobMeta.nrDatabases() );
DatabaseMeta databaseMeta = jobMeta.getDatabase( i );

 private void getTableName() {
  // New class: SelectTableDialog
  int connr = wConnection.getSelectionIndex();
  if ( connr >= 0 ) {
   DatabaseMeta inf = jobMeta.getDatabase( connr );

   DatabaseExplorerDialog std = new DatabaseExplorerDialog( shell, SWT.NONE, inf, jobMeta.getDatabases() );
   std.setSelectedSchemaAndTable( wSchemaname.getText(), wTablename.getText() );
   if ( std.open() ) {
    wSchemaname.setText( Const.NVL( std.getSchemaName(), "" ) );
    wTablename.setText( Const.NVL( std.getTableName(), "" ) );
   }
  } else {
   MessageBox mb = new MessageBox( shell, SWT.OK | SWT.ICON_ERROR );
   mb.setMessage( BaseMessages.getString( PKG, "System.Dialog.ConnectionError.DialogMessage" ) );
   mb.setText( BaseMessages.getString( PKG, "System.Dialog.Error.Title" ) );
   mb.open();
  }

 }
}

private void getTableName() {
 // New class: SelectTableDialog
 int connr = wConnection.getSelectionIndex();
 if ( connr >= 0 ) {
  DatabaseMeta inf = jobMeta.getDatabase( connr );
  DatabaseExplorerDialog std = new DatabaseExplorerDialog( shell, SWT.NONE, inf, jobMeta.getDatabases() );
  std.setSelectedSchemaAndTable( wSchemaname.getText(), wTablename.getText() );
  if ( std.open() ) {
   wSchemaname.setText( Const.NVL( std.getSchemaName(), "" ) );
   wTablename.setText( Const.NVL( std.getTableName(), "" ) );
  }
 } else {
  MessageBox mb = new MessageBox( shell, SWT.OK | SWT.ICON_ERROR );
  mb.setMessage( BaseMessages.getString( PKG, "JobEntryColumnsExist.ConnectionError.DialogMessage" ) );
  mb.setText( BaseMessages.getString( PKG, "System.Dialog.Error.Title" ) );
  mb.open();
 }
}

for ( JobMeta jobMeta : jobMetas ) {
 for ( int i = 0; i < jobMeta.nrDatabases(); i++ ) {
  jobMeta.getDatabase( i ).setObjectId( null );