public DatabaseMeta getDatabaseInfo() { if ( wName.getText() != null && wName.getText().length() > 0 ) { databaseMeta.setName( wName.getText() ); databaseMeta.setDisplayName( wName.getText() ); } String[] dbTypeSel = wDBType.getSelection(); if ( dbTypeSel != null && dbTypeSel.length == 1 ) { databaseMeta.setDatabaseType( dbTypeSel[0] ); } String[] accTypeSel = wAccType.getSelection(); if ( accTypeSel != null && accTypeSel.length == 1 ) { databaseMeta.setAccessType( DatabaseMeta.getAccessType( accTypeSel[0] ) ); } // Also, set the default port in case of JDBC: databaseMeta.setDBPort( String.valueOf( databaseMeta.getDefaultDatabasePort() ) ); return databaseMeta; }
public void setValues( String name, String type, String access, String host, String db, String port, String user, String pass ) { try { databaseInterface = getDatabaseInterface( type ); } catch ( KettleDatabaseException kde ) { throw new RuntimeException( "Database type not found!", kde ); } setName( name ); setAccessType( getAccessType( access ) ); setHostname( host ); setDBName( db ); setDBPort( port ); setUsername( user ); setPassword( pass ); setServername( null ); setChanged( false ); }
meta.setAccessType( DatabaseMeta.getAccessType( (String) access ) );
public void setDatabaseType( String type ) { DatabaseInterface oldInterface = databaseInterface; try { databaseInterface = getDatabaseInterface( type ); } catch ( KettleDatabaseException kde ) { throw new RuntimeException( "Database type [" + type + "] not found!", kde ); } setName( oldInterface.getName() ); setDisplayName( oldInterface.getDisplayName() ); setAccessType( oldInterface.getAccessType() ); setHostname( oldInterface.getHostname() ); setDBName( oldInterface.getDatabaseName() ); setDBPort( oldInterface.getDatabasePortNumberString() ); setUsername( oldInterface.getUsername() ); setPassword( oldInterface.getPassword() ); setServername( oldInterface.getServername() ); setDataTablespace( oldInterface.getDataTablespace() ); setIndexTablespace( oldInterface.getIndexTablespace() ); setChanged( oldInterface.isChanged() ); }
public void dataNodeToElement( final DataNode rootNode, final RepositoryElementInterface element ) throws KettleException { DatabaseMeta databaseMeta = (DatabaseMeta) element; databaseMeta.setDatabaseType( getString( rootNode, PROP_TYPE ) ); databaseMeta.setAccessType( DatabaseMeta.getAccessType( getString( rootNode, PROP_CONTYPE ) ) ); databaseMeta.setHostname( getString( rootNode, PROP_HOST_NAME ) ); databaseMeta.setDBName( getString( rootNode, PROP_DATABASE_NAME ) ); databaseMeta.setDBPort( getString( rootNode, PROP_PORT ) ); databaseMeta.setUsername( getString( rootNode, PROP_USERNAME ) ); databaseMeta.setPassword( Encr.decryptPasswordOptionallyEncrypted( getString( rootNode, PROP_PASSWORD ) ) ); databaseMeta.setServername( getString( rootNode, PROP_SERVERNAME ) ); databaseMeta.setDataTablespace( getString( rootNode, PROP_DATA_TBS ) ); databaseMeta.setIndexTablespace( getString( rootNode, PROP_INDEX_TBS ) ); // Also, load all the properties we can find... DataNode attrNode = rootNode.getNode( NODE_ATTRIBUTES ); for ( DataProperty property : attrNode.getProperties() ) { String code = property.getName(); String attribute = property.getString(); // We need to unescape the code as it was escaped to handle characters that JCR does not handle String unescapeCode = RepositoryFilenameUtils.unescape( code ); databaseMeta.getAttributes().put( unescapeCode, Const.NVL( attribute, "" ) ); //$NON-NLS-1$ } }
databaseMeta.setAccessType( DatabaseMeta.getAccessType( getDatabaseConTypeCode( id_database_contype ) ) );
setHostname( XMLHandler.getTagValue( con, "server" ) ); String acc = XMLHandler.getTagValue( con, "access" ); setAccessType( getAccessType( acc ) );
accessTypeString = DatabaseMeta.getAccessTypeDesc( DatabaseMeta.TYPE_ACCESS_NATIVE ); databaseMeta.setAccessType( DatabaseMeta.getAccessType( accessTypeString ) );
private DatabaseMeta getDatabaseMeta( IDatabaseConnection connection ) throws Exception { DatabaseMeta databaseMeta = DatabaseUtil.convertToDatabaseMeta( connection ); if ( connection.getName().equals( "SampleData" ) ) { databaseMeta.setAccessType( DatabaseMeta.TYPE_ACCESS_JNDI ); databaseMeta.setDBName( "SampleData" ); } return databaseMeta; }
public static DatabaseMeta getDatabaseMeta() { // get the database settings from configuration String jndi = getJndiName(); DatabaseMeta databaseMeta = new DatabaseMeta(); databaseMeta.setAccessType( DatabaseMeta.TYPE_ACCESS_JNDI ); databaseMeta.setDBName( jndi ); databaseMeta.setName( jndi ); String dialect = getDialect( databaseMeta ); databaseMeta.setDatabaseType( dialect ); databaseMeta.setQuoteAllFields( true ); return databaseMeta; }
public static DatabaseMeta convertToLegacy( String name, SqlDataSource datasource ) { // make sure that the Kettle environment is initialized before DatabaseMeta creation try { KettleEnvironment.init( false ); } catch ( KettleException e ) { logger.error( "Error initializing the Kettle Environment", e ); throw new RuntimeException( "Error initializing the Kettle Environment", e ); } DatabaseMeta databaseMeta = new DatabaseMeta(); databaseMeta.setName( name ); databaseMeta.setHostname( datasource.getHostname() ); if ( datasource.getDialectType() == null ) { // default to mysql if dialect is null databaseMeta.setDatabaseType( "GENERIC" ); //$NON-NLS-1$ } else { databaseMeta.setDatabaseType( datasource.getDialectType() ); } databaseMeta.setAccessType( DatabaseMeta.getAccessType( datasource.getType().toString() ) ); databaseMeta.setDBName( datasource.getDatabaseName() ); databaseMeta.setDBPort( datasource.getPort() ); databaseMeta.setUsername( datasource.getUsername() ); databaseMeta.setPassword( datasource.getPassword() ); databaseMeta.setServername( datasource.getServername() ); // And now load the attributes... for ( String key : datasource.getAttributes().keySet() ) { databaseMeta.getAttributes().put( key, datasource.getAttributes().get( key ) ); } return databaseMeta; }
public Domain generateDomain( String connectionName, String tableName, String dbType, String query, String datasourceName ) throws Exception { try { DatabaseMeta database = new DatabaseMeta(); database.setDatabaseInterface( new MySQLDatabaseMeta() ); database.setDatabaseType( "mysql" ); database.setUsername( "root" ); database.setPassword( "" ); database.setAccessType( DatabaseMeta.TYPE_ACCESS_NATIVE ); database.setHostname( "localhost" ); database.setDBName( "hibernate" ); database.setDBPort( "3306" ); TableModelerSource source = new TableModelerSource( database, tableName, null ); Domain d = null; try { d = source.generateDomain(); } catch ( ModelerException e ) { e.printStackTrace(); // To change body of catch statement use File | Settings | File Templates. } return d; } catch ( Exception e ) { e.printStackTrace(); } return null; }
databaseMeta.setAccessType( DatabaseMeta .getAccessType( cwm.getFirstTaggedValue( catalog, CWM.TAG_DATABASE_ACCESS ) ) ); databaseMeta.setDBName( cwm.getFirstTaggedValue( catalog, CWM.TAG_DATABASE_DATABASE ) );