How to use

addDatabase

method

in

org.pentaho.di.job.JobMeta

 @Override
 public void widgetSelected( SelectionEvent e ) {
  DatabaseMeta databaseMeta = new DatabaseMeta();
  String connectionName = showDbDialogUnlessCancelledOrValid( databaseMeta, null );
  if ( connectionName != null ) {
   jobMeta.addDatabase( databaseMeta );
   reinitConnectionDropDown( wConnection, databaseMeta.getName() );
  }
 }
}

 public void widgetSelected( SelectionEvent e ) {
  CreateDatabaseWizard cdw = new CreateDatabaseWizard();
  DatabaseMeta newDBInfo = cdw.createAndRunDatabaseWizard( shell, props, jobMeta.getDatabases() );
  if ( newDBInfo != null ) {
   jobMeta.addDatabase( newDBInfo );
   reinitConnectionDropDown( wConnection, newDBInfo.getName() );
  }
 }
} );

 public void widgetSelected( SelectionEvent e ) {
  DatabaseMeta databaseMeta = jobMeta.findDatabase( wConnection.getText() );
  if ( databaseMeta != null ) {
   // cloning to avoid spoiling data on cancel or incorrect input
   DatabaseMeta clone = (DatabaseMeta) databaseMeta.clone();
   String connectionName = showDbDialogUnlessCancelledOrValid( clone, databaseMeta );
   if ( connectionName != null ) {
    // need to replace the old connection with a new one
    jobMeta.removeDatabase( jobMeta.indexOfDatabase( databaseMeta ) );
    jobMeta.addDatabase( clone );
    reinitConnectionDropDown( wConnection, connectionName );
   }
  }
 }
}

dbMetaToReplace.setObjectId( repo.getDatabaseID( dbMetaToReplace.getName() ) );
jobMeta.removeDatabase( indexToReplace );
jobMeta.addDatabase( dbMetaToReplace );

 public void widgetSelected( SelectionEvent e ) {
  DatabaseMeta databaseMeta = new DatabaseMeta();
  databaseMeta.shareVariablesWith( jobMeta );
  getDatabaseDialog().setDatabaseMeta( databaseMeta );
  if ( getDatabaseDialog().open() != null ) {
   jobMeta.addDatabase( getDatabaseDialog().getDatabaseMeta() );
   wLogconnection.add( getDatabaseDialog().getDatabaseMeta().getName() );
   wLogconnection.select( wLogconnection.getItemCount() - 1 );
  }
 }
} );

jobMeta.addDatabase( oldDatabase );

 addDatabase( dbcon );
} else {
 if ( !exist.isShared() ) {
   int idx = indexOfDatabase( exist );
   removeDatabase( idx );
   addDatabase( idx, dbcon );

/**
 * Open the Database Connection Dialog to edit
 *
 * @param database
 *          Database meta to edit
 * @param isNew
 *          Is this database meta new? If so and the user chooses to save the database connection we will make sure to
 *          save this into the job meta.
 */
protected void editDatabaseMeta( DatabaseMeta database, boolean isNew ) {
 database.shareVariablesWith( jobMeta );
 getDatabaseDialog().setDatabaseMeta( database );
 if ( getDatabaseDialog().open() != null ) {
  if ( isNew ) {
   jobMeta.addDatabase( getDatabaseDialog().getDatabaseMeta() );
  }
  suppressEventHandling = true;
  try {
   populateDatabases();
  } finally {
   suppressEventHandling = false;
  }
  setSelectedDatabaseConnection( createDatabaseItem( getDatabaseDialog().getDatabaseMeta().getName() ) );
  jobEntry.setUsedDbConnection( database );
 }
}