public void setData() { wHostname.setText( Const.NVL( databaseMeta.getHostname(), "" ) ); wPort.setText( Const.NVL( databaseMeta.getDatabasePortNumberString(), "" ) ); if ( !defaultWebAppNameSet && isDataServiceConnection() ) { wDBName.setText( DEFAULT_WEB_APPLICATION_NAME ); defaultWebAppNameSet = true; } else { wDBName.setText( Const.NVL( databaseMeta.getDatabaseName(), "" ) ); } if ( isDataServiceConnection() ) { wlDBName.setText( BaseMessages.getString( PKG, "CreateDatabaseWizardPageJDBC.WebAppName.Label" ) ); } else { wlDBName.setText( BaseMessages.getString( PKG, "CreateDatabaseWizardPageJDBC.DBName.Label" ) ); } }
private StringBuilder appendConnectionInfo( StringBuilder report, Database db, DatabaseMeta databaseMeta ) { // Check to see if the interface is of a type GenericDatabaseMeta, since it does not have hostname and port fields if ( databaseMeta.getDatabaseInterface() instanceof GenericDatabaseMeta ) { String customUrl = databaseMeta.getAttributes().getProperty( GenericDatabaseMeta.ATRRIBUTE_CUSTOM_URL ); String customDriverClass = databaseMeta.getAttributes().getProperty( GenericDatabaseMeta.ATRRIBUTE_CUSTOM_DRIVER_CLASS ); return report.append( BaseMessages.getString( PKG, "GenericDatabaseMeta.report.customUrl" ) ).append( db.environmentSubstitute( customUrl ) ).append( Const.CR ).append( BaseMessages.getString( PKG, "GenericDatabaseMeta.report.customDriverClass" ) ).append( db.environmentSubstitute( customDriverClass ) ).append( Const.CR ); } return appendConnectionInfo( report, db.environmentSubstitute( databaseMeta.getHostname() ), db .environmentSubstitute( databaseMeta.getDatabasePortNumberString() ), db .environmentSubstitute( databaseMeta.getDatabaseName() ) ); }
retval.append( " " ).append( XMLHandler.addTagValue( "access", getAccessTypeDesc() ) ); retval.append( " " ).append( XMLHandler.addTagValue( "database", getDatabaseName() ) ); retval.append( " " ).append( XMLHandler.addTagValue( "port", getDatabasePortNumberString() ) ); retval.append( " " ).append( XMLHandler.addTagValue( "username", getUsername() ) ); retval.append( " " ).append(
protected static String buildPoolName( DatabaseMeta dbMeta, String partitionId ) { return dbMeta.getName() + Const.NVL( dbMeta.getDatabaseName(), "" ) + Const.NVL( dbMeta.getHostname(), "" ) + Const.NVL( dbMeta.getDatabasePortNumberString(), "" ) + Const.NVL( partitionId, "" ); }
public OpenERPHelper( DatabaseMeta databaseMeta ) { openERPConnection = new Session( databaseMeta.environmentSubstitute( databaseMeta.getHostname() ), Integer.parseInt( databaseMeta .environmentSubstitute( databaseMeta.getDatabasePortNumberString() ) ), databaseMeta .environmentSubstitute( databaseMeta.getDatabaseName() ), databaseMeta.environmentSubstitute( databaseMeta .getUsername() ), databaseMeta.environmentSubstitute( databaseMeta.getPassword() ) ); }
private static String getDataSourceName( DatabaseMeta dbMeta, String partitionId ) { return dbMeta.getName() + Const.NVL( dbMeta.getDatabaseName(), "" ) + Const.NVL( dbMeta.getHostname(), "" ) + Const.NVL( dbMeta.getDatabasePortNumberString(), "" ) + Const.NVL( partitionId, "" ); }
String portnum = Const.NVL( dm.getDatabasePortNumberString(), "" ); sb.append( " -h " ); sb.append( hostname );
} else if ( !equals( databaseMeta.getDatabaseName(), databaseMeta2.getDatabaseName() ) ) { return false; } else if ( !equals( databaseMeta.getDatabasePortNumberString(), databaseMeta2.getDatabasePortNumberString() ) ) { return false; } else if ( !equals( databaseMeta.getUsername(), databaseMeta2.getUsername() ) ) {
protected void executeSql( String query ) throws Exception { if ( this.meta == null ) { throw new KettleException( "No metadata available to determine connection information from." ); } DatabaseMeta dm = meta.getDatabaseMeta(); String hostname = environmentSubstitute( Const.NVL( dm.getHostname(), "" ) ); String portnum = environmentSubstitute( Const.NVL( dm.getDatabasePortNumberString(), "" ) ); String user = environmentSubstitute( Const.NVL( dm.getUsername(), "" ) ); String password = environmentSubstitute( Const.NVL( dm.getPassword(), "" ) ); String db = environmentSubstitute( Const.NVL( dm.getDatabaseName(), "" ) ); executeSql( query, hostname, Integer.valueOf( portnum ), user, password, db ); }
protected MapiSocket getMonetDBConnection() throws Exception { if ( this.meta == null ) { throw new KettleException( "No metadata available to determine connection information from." ); } DatabaseMeta dm = meta.getDatabaseMeta(); String hostname = environmentSubstitute( Const.NVL( dm.getHostname(), "" ) ); String portnum = environmentSubstitute( Const.NVL( dm.getDatabasePortNumberString(), "" ) ); String user = environmentSubstitute( Const.NVL( dm.getUsername(), "" ) ); String password = Utils.resolvePassword( variables, Const.NVL( dm.getPassword(), "" ) ); String db = environmentSubstitute( Const.NVL( dm.getDatabaseName(), "" ) ); MapiSocket mserver = getMonetDBConnection( hostname, Integer.valueOf( portnum ), user, password, db, log ); return mserver; }
BaseMessages.getString( PKG, "JobMeta.SearchMetadata.DatabaseTypeDescription" ) ) ); if ( meta.getDatabasePortNumberString() != null ) { stringList.add( new StringSearchResult( meta.getDatabasePortNumberString(), meta, this, BaseMessages.getString( PKG, "JobMeta.SearchMetadata.DatabasePort" ) ) );
rootNode.setProperty( PROP_HOST_NAME, databaseMeta.getHostname() ); rootNode.setProperty( PROP_DATABASE_NAME, databaseMeta.getDatabaseName() ); rootNode.setProperty( PROP_PORT, new Long( Const.toInt( databaseMeta.getDatabasePortNumberString(), -1 ) ) ); rootNode.setProperty( PROP_USERNAME, databaseMeta.getUsername() ); rootNode.setProperty( PROP_PASSWORD, Encr.encryptPasswordIfNotUsingVariables( databaseMeta.getPassword() ) );
public void replaceMeta( DatabaseMeta databaseMeta ) { this.setValues( databaseMeta.getName(), databaseMeta.getPluginId(), databaseMeta.getAccessTypeDesc(), databaseMeta .getHostname(), databaseMeta.getDatabaseName(), databaseMeta.getDatabasePortNumberString(), databaseMeta.getUsername(), databaseMeta.getPassword() ); this.setServername( databaseMeta.getServername() ); this.setDataTablespace( databaseMeta.getDataTablespace() ); this.setIndexTablespace( databaseMeta.getIndexTablespace() ); this.databaseInterface = (DatabaseInterface) databaseMeta.databaseInterface.clone(); this.setObjectId( databaseMeta.getObjectId() ); this.setChanged(); }
databaseMeta.getName(), databaseMeta.getPluginId(), DatabaseMeta.getAccessTypeDesc( databaseMeta .getAccessType() ), databaseMeta.getHostname(), databaseMeta.getDatabaseName(), databaseMeta .getDatabasePortNumberString(), databaseMeta.getUsername(), databaseMeta.getPassword(), databaseMeta.getServername(), databaseMeta.getDataTablespace(), databaseMeta.getIndexTablespace() ) ); } else { databaseMeta.getObjectId(), databaseMeta.getName(), databaseMeta.getPluginId(), DatabaseMeta .getAccessTypeDesc( databaseMeta.getAccessType() ), databaseMeta.getHostname(), databaseMeta .getDatabaseName(), databaseMeta.getDatabasePortNumberString(), databaseMeta.getUsername(), databaseMeta.getPassword(), databaseMeta.getServername(), databaseMeta.getDataTablespace(), databaseMeta.getIndexTablespace() );
} else { hostname = environmentSubstitute( getHostname() ); port = environmentSubstitute( getDatabasePortNumberString() ); databaseName = environmentSubstitute( getDatabaseName() );
element.addChild( metaStore.newAttribute( MetaStoreConst.DB_ATTR_ID_HOSTNAME, databaseMeta.getHostname() ) ); element.addChild( metaStore.newAttribute( MetaStoreConst.DB_ATTR_ID_PORT, databaseMeta .getDatabasePortNumberString() ) ); element.addChild( metaStore.newAttribute( MetaStoreConst.DB_ATTR_ID_DATABASE_NAME, databaseMeta .getDatabaseName() ) );
databaseInterface.addAttribute( code, attribute ); getDatabasePortNumberString();
@Test public void testDBNameNOTOverridden_IfDbNameOverrideNull() throws Exception { // Db Name Override is null PGBulkLoaderMeta pgBulkLoaderMock = getPgBulkLoaderMock( null ); Database database = pgBulkLoader.getDatabase( pgBulkLoader, pgBulkLoaderMock ); assertNotNull( database ); // Verify DB name is NOT overridden assertEquals( CONNECTION_DB_NAME, database.getDatabaseMeta().getDatabaseName() ); // Check additionally other connection information assertEquals( CONNECTION_NAME, database.getDatabaseMeta().getName() ); assertEquals( CONNECTION_DB_HOST, database.getDatabaseMeta().getHostname() ); assertEquals( CONNECTION_DB_PORT, database.getDatabaseMeta().getDatabasePortNumberString() ); assertEquals( CONNECTION_DB_USERNAME, database.getDatabaseMeta().getUsername() ); assertEquals( CONNECTION_DB_PASSWORD, database.getDatabaseMeta().getPassword() ); }
@Test public void testDBNameOverridden_IfDbNameOverrideSetUp() throws Exception { // Db Name Override is set up PGBulkLoaderMeta pgBulkLoaderMock = getPgBulkLoaderMock( DB_NAME_OVVERRIDE ); Database database = pgBulkLoader.getDatabase( pgBulkLoader, pgBulkLoaderMock ); assertNotNull( database ); // Verify DB name is overridden assertEquals( DB_NAME_OVVERRIDE, database.getDatabaseMeta().getDatabaseName() ); // Check additionally other connection information assertEquals( CONNECTION_NAME, database.getDatabaseMeta().getName() ); assertEquals( CONNECTION_DB_HOST, database.getDatabaseMeta().getHostname() ); assertEquals( CONNECTION_DB_PORT, database.getDatabaseMeta().getDatabasePortNumberString() ); assertEquals( CONNECTION_DB_USERNAME, database.getDatabaseMeta().getUsername() ); assertEquals( CONNECTION_DB_PASSWORD, database.getDatabaseMeta().getPassword() ); }
@Test public void testDBNameNOTOverridden_IfDbNameOverrideEmpty() throws Exception { // Db Name Override is empty PGBulkLoaderMeta pgBulkLoaderMock = getPgBulkLoaderMock( DB_NAME_EMPTY ); Database database = pgBulkLoader.getDatabase( pgBulkLoader, pgBulkLoaderMock ); assertNotNull( database ); // Verify DB name is NOT overridden assertEquals( CONNECTION_DB_NAME, database.getDatabaseMeta().getDatabaseName() ); // Check additionally other connection information assertEquals( CONNECTION_NAME, database.getDatabaseMeta().getName() ); assertEquals( CONNECTION_DB_HOST, database.getDatabaseMeta().getHostname() ); assertEquals( CONNECTION_DB_PORT, database.getDatabaseMeta().getDatabasePortNumberString() ); assertEquals( CONNECTION_DB_USERNAME, database.getDatabaseMeta().getUsername() ); assertEquals( CONNECTION_DB_PASSWORD, database.getDatabaseMeta().getPassword() ); }