if ( databaseMeta.getObjectId() == null ) { databaseMeta.setObjectId( getDatabaseID( databaseMeta.getName() ) ); if ( databaseMeta.getObjectId() == null ) { databaseMeta.setObjectId( insertDatabase( 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() ); delDatabaseAttributes( databaseMeta.getObjectId() ); insertDatabaseAttributes( databaseMeta.getObjectId(), databaseMeta.getAttributes() ); } catch ( KettleDatabaseException dbe ) { throw new KettleException(
@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 DatabaseMeta loadDatabaseMetaFromJobEntryAttribute( ObjectId id_jobentry, String nameCode, int nr, String idCode, List<DatabaseMeta> databases ) throws KettleException { long id_database = getJobEntryAttributeInteger( id_jobentry, nr, idCode ); if ( id_database <= 0 ) { String name = getJobEntryAttributeString( id_jobentry, nr, nameCode ); if ( name == null ) { return null; } return DatabaseMeta.findDatabase( databases, name ); } return DatabaseMeta.findDatabase( databases, new LongObjectId( id_database ) ); }
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(); }
@Override public Object clone() { DatabaseMeta databaseMeta = new DatabaseMeta(); databaseMeta.replaceMeta( this ); databaseMeta.setObjectId( null ); return databaseMeta; }
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() ) ); }
retval.append( " " ).append( XMLHandler.addTagValue( "name", getName() ) ); retval.append( " " ).append( XMLHandler.addTagValue( "server", getHostname() ) ); retval.append( " " ).append( XMLHandler.addTagValue( "type", getPluginId() ) ); 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( XMLHandler.addTagValue( "password", Encr.encryptPasswordIfNotUsingVariables( getPassword() ) ) ); retval.append( " " ).append( XMLHandler.addTagValue( "servername", getServername() ) ); retval.append( " " ).append( XMLHandler.addTagValue( "data_tablespace", getDataTablespace() ) ); retval.append( " " ).append( XMLHandler.addTagValue( "index_tablespace", getIndexTablespace() ) ); if ( isReadOnly() ) { retval.append( " " ).append( XMLHandler.addTagValue( "read_only", Boolean.toString( isReadOnly() ) ) ); Set<Object> keySet = getAttributes().keySet(); for ( Object object : keySet ) { list.add( (String) object ); String attribute = getAttributes().getProperty( code ); if ( !Utils.isEmpty( attribute ) ) { retval.append( " <attribute>"
public static SAPConnectionParams getFromDatabaseMeta( DatabaseMeta sapConnection ) { String name = sapConnection.getName(); String host = sapConnection.environmentSubstitute( sapConnection.getHostname() ); String sysnr = sapConnection.environmentSubstitute( sapConnection.getAttributes().getProperty( "SAPSystemNumber" ) ); String client = sapConnection.environmentSubstitute( sapConnection.getAttributes().getProperty( "SAPClient" ) ); String user = sapConnection.environmentSubstitute( sapConnection.getUsername() ); String password = sapConnection.environmentSubstitute( sapConnection.getPassword() ); String lang = ""; return new SAPConnectionParams( name, host, sysnr, client, user, password, lang ); } }
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, "" ); }
String databaseName; if ( isPartitioned() && !Utils.isEmpty( partitionId ) ) { PartitionDatabaseMeta partition = getPartitionMeta( partitionId ); hostname = environmentSubstitute( partition.getHostname() ); port = environmentSubstitute( partition.getPort() ); databaseName = environmentSubstitute( partition.getDatabaseName() ); } else { hostname = environmentSubstitute( getHostname() ); port = environmentSubstitute( getDatabasePortNumberString() ); databaseName = environmentSubstitute( getDatabaseName() ); baseUrl = databaseInterface.getURL( environmentSubstitute( hostname ), environmentSubstitute( port ), environmentSubstitute( databaseName ) ); String url = environmentSubstitute( baseUrl ); url = appendExtraOptions( url, getExtraOptions() );
public List<ResourceReference> getResourceDependencies( JobMeta jobMeta ) { List<ResourceReference> references = super.getResourceDependencies( jobMeta ); if ( connection != null ) { ResourceReference reference = new ResourceReference( this ); reference.getEntries().add( new ResourceEntry( connection.getHostname(), ResourceType.SERVER ) ); reference.getEntries().add( new ResourceEntry( connection.getDatabaseName(), ResourceType.DATABASENAME ) ); references.add( reference ); } return references; }
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() ) ); }
@Override public DatabaseMeta getTestObject() { DatabaseMeta db = new DatabaseMeta(); db.setObjectId( new LongObjectId( rand.nextInt( Integer.MAX_VALUE ) ) ); db.setName( UUID.randomUUID().toString() ); db.setHostname( UUID.randomUUID().toString() ); db.setUsername( UUID.randomUUID().toString() ); db.setPassword( UUID.randomUUID().toString() ); return db; }
String realRole = space.environmentSubstitute( role ); if ( databaseMeta.getAccessType() == DatabaseMeta.TYPE_ACCESS_JNDI ) { DataSource dataSource = ( new DatabaseUtil() ).getNamedDataSource( databaseMeta.getDatabaseName() ); mondrian.olap.Util.PropertyList propList = new mondrian.olap.Util.PropertyList(); propList.put( "Provider", "mondrian" ); + "Jdbc='" + space.environmentSubstitute( databaseMeta.getURL() ) + "';" + "Catalog='" + space.environmentSubstitute( catalog ) + "';" + "JdbcDrivers=" + space.environmentSubstitute( databaseMeta.getDriverClass() ) + ";"; if ( !Utils.isEmpty( databaseMeta.getUsername() ) ) { connectString += "JdbcUser=" + space.environmentSubstitute( databaseMeta.getUsername() ) + ";"; String password = databaseMeta.getPassword(); if ( !Utils.isEmpty( password ) ) { String realPassword = Utils.resolvePassword( space, password );
public void widgetSelected( SelectionEvent e ) { DatabaseMeta databaseMeta = new DatabaseMeta(); databaseMeta.shareVariablesWith( transMeta ); getDatabaseDialog().setDatabaseMeta( databaseMeta ); if ( getDatabaseDialog().open() != null ) { transMeta.addDatabase( getDatabaseDialog().getDatabaseMeta() ); wLogconnection.add( getDatabaseDialog().getDatabaseMeta().getName() ); wLogconnection.select( wLogconnection.getItemCount() - 1 ); } } } );
public static String createEntryKey( String connectionGroup, String partitionID, Database database ) { StringBuilder key = new StringBuilder( connectionGroup ); key.append( ':' ).append( database.getDatabaseMeta().getName() ); if ( !Utils.isEmpty( partitionID ) ) { key.append( ':' ).append( partitionID ); } return key.toString(); }
public XulStepFieldsDialog( Shell aShell, int aStyle, DatabaseMeta aDatabaseMeta, String aTableName, RowMetaInterface anInput, String schemaName ) { this.shell = aShell; this.schemaTableCombo = aDatabaseMeta.getQuotedSchemaTableCombination( schemaName, aTableName ); this.databaseMeta = aDatabaseMeta; this.rowMeta = anInput; }
builder.setSessions( this.meta.getSessions().getValue() ); builder.setErrorLimit( this.meta.getErrorLimit().getValue() ); builder.logon( this.meta.getDbMeta().getHostname(), this.meta.getDbMeta().getUsername(), this.meta .getDbMeta().getPassword() ); builder.setRecordFormat( FastloadControlBuilder.RECORD_VARTEXT ); try { builder.beginLoading( this.meta.getDbMeta().getPreferredSchemaName(), this.meta.getTargetTable().getValue() );
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" ) ); } }
protected DatabaseMeta createDatabase( String name ) { DatabaseMeta db = new DatabaseMeta(); db.setName( name ); db.getDatabaseInterface().setDatabaseName( name ); return db; }