Java Code Examples for org.pentaho.di.core.database.DatabaseMeta#TYPE_ACCESS_NATIVE

The following examples show how to use org.pentaho.di.core.database.DatabaseMeta#TYPE_ACCESS_NATIVE . You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source File: XulDatabaseDialog.java From pentaho-reporting with GNU Lesser General Public License v2.1

6 votes

private int convertAccessTypeToKettle( final DatabaseAccessType type ) {
  switch( type ) {
    case NATIVE:
      return DatabaseMeta.TYPE_ACCESS_NATIVE;
    case JNDI:
      return DatabaseMeta.TYPE_ACCESS_JNDI;
    case OCI:
      return DatabaseMeta.TYPE_ACCESS_OCI;
    case ODBC:
      return DatabaseMeta.TYPE_ACCESS_ODBC;
    case PLUGIN:
      return DatabaseMeta.TYPE_ACCESS_PLUGIN;
    default:
      throw new IllegalStateException();
  }
}

Example 2

Source File: XulDatabaseDialog.java From pentaho-reporting with GNU Lesser General Public License v2.1

6 votes

private DatabaseAccessType convertAccessTypeFromKettle( final int type ) {
  switch( type ) {
    case DatabaseMeta.TYPE_ACCESS_NATIVE:
      return DatabaseAccessType.NATIVE;
    case DatabaseMeta.TYPE_ACCESS_JNDI:
      return DatabaseAccessType.JNDI;
    case DatabaseMeta.TYPE_ACCESS_OCI:
      return DatabaseAccessType.OCI;
    case DatabaseMeta.TYPE_ACCESS_ODBC:
      return DatabaseAccessType.ODBC;
    case DatabaseMeta.TYPE_ACCESS_PLUGIN:
      return DatabaseAccessType.PLUGIN;
    default:
      throw new IllegalStateException();
  }
}

Example 3

Source File: MetadataGenerator.java From pentaho-kettle with Apache License 2.0

6 votes

private SqlDataSource createSqlDataSource(DatabaseMeta databaseMeta) {
  SqlDataSource dataSource = new SqlDataSource();
  dataSource.setDatabaseName(databaseMeta.getDatabaseName());
  dataSource.setHostname(databaseMeta.getHostname());
  dataSource.setUsername(databaseMeta.getUsername());
  dataSource.setPassword(databaseMeta.getPassword());
  dataSource.setPort(databaseMeta.getDatabasePortNumberString());
  dataSource.setAttributes(databaseMeta.getExtraOptions());
  DataSourceType dataSourceType;
  switch(databaseMeta.getAccessType()) {
  case DatabaseMeta.TYPE_ACCESS_NATIVE : dataSourceType = DataSourceType.NATIVE; break;
  case DatabaseMeta.TYPE_ACCESS_ODBC   : dataSourceType = DataSourceType.ODBC; break;
  case DatabaseMeta.TYPE_ACCESS_JNDI   : dataSourceType = DataSourceType.JNDI; break;
  case DatabaseMeta.TYPE_ACCESS_OCI    : dataSourceType = DataSourceType.OCI; break;
  default: dataSourceType = DataSourceType.CUSTOM; break;
  }
  dataSource.setType(dataSourceType);

  return dataSource;
}

Example 4

Source File: ThinModelConverter.java From pentaho-metadata with GNU Lesser General Public License v2.1

5 votes

public static SqlDataSource convertFromLegacy( DatabaseMeta database ) {
  SqlDataSource dataSource = new SqlDataSource();

  dataSource.setDialectType( database.getDatabaseTypeDesc() );
  dataSource.setDatabaseName( database.environmentSubstitute( database.getDatabaseName() ) );
  dataSource.setHostname( database.environmentSubstitute( database.getHostname() ) );
  dataSource.setPort( database.environmentSubstitute( database.getDatabasePortNumberString() ) );
  dataSource.setUsername( database.environmentSubstitute( database.getUsername() ) );
  dataSource.setPassword( database.environmentSubstitute( database.getPassword() ) );
  dataSource.setServername( database.environmentSubstitute( database.getServername() ) );

  if ( database.getAccessType() == DatabaseMeta.TYPE_ACCESS_JNDI ) {
    dataSource.setType( DataSourceType.values()[database.getAccessType()] );
  } else if ( database.getAccessType() == DatabaseMeta.TYPE_ACCESS_NATIVE ) {
    dataSource.setType( DataSourceType.NATIVE );
  }

  // And now load the attributes...
  if ( database.getAttributes() != null ) {
    for ( Object key : database.getAttributes().keySet() ) {
      dataSource.getAttributes().put( (String) key,
          database.environmentSubstitute( (String) database.getAttributes().get( key ) ) );
    }
  }

  return dataSource;
}