Java Code Examples for org.pentaho.di.core.database.DatabaseMeta#TYPE_ACCESS_ODBC
The following examples show how to use
org.pentaho.di.core.database.DatabaseMeta#TYPE_ACCESS_ODBC .
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: DatabaseMappingGenerator.java From pentaho-reporting with GNU Lesser General Public License v2.1 | 6 votes |
public static void main( String[] args ) { final HashSet knownDrivers = new HashSet(); final DatabaseInterface[] interfaces = DatabaseMeta.getDatabaseInterfaces(); for ( int i = 0; i < interfaces.length; i++ ) { final DatabaseInterface dbi = interfaces[ i ]; final int[] accessTypeList = dbi.getAccessTypeList(); for ( int j = 0; j < accessTypeList.length; j++ ) { final int al = accessTypeList[ j ]; if ( al != DatabaseMeta.TYPE_ACCESS_ODBC ) { dbi.setAccessType( al ); final String driver = dbi.getDriverClass(); if ( knownDrivers.contains( driver ) == false ) { System.out.println( driver + "=" + dbi.getClass().getName() ); knownDrivers.add( driver ); } } } } }
Example 2
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 3
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 4
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 5
Source File: DatabaseMapping.java From pentaho-reporting with GNU Lesser General Public License v2.1 | 5 votes |
private static DatabaseInterface mapTypeFromDriver(final String driverClass) { if (driverClass == null) { return new GenericDatabaseMeta(); } final DatabaseInterface[] interfaces = DatabaseMeta.getDatabaseInterfaces(); for (int i = 0; i < interfaces.length; i++) { final DatabaseInterface dbi = interfaces[i]; final int[] accessTypeList = dbi.getAccessTypeList(); for (int j = 0; j < accessTypeList.length; j++) { final int al = accessTypeList[j]; if (al != DatabaseMeta.TYPE_ACCESS_ODBC) { dbi.setAccessType(al); if (driverClass.equals(dbi.getDriverClass())) { return dbi; } } } } return new GenericDatabaseMeta(); }
Example 6
Source File: CreateDatabaseWizardPage1.java From pentaho-kettle with Apache License 2.0 | 5 votes |
public IWizardPage getNextPage() { IWizard wiz = getWizard(); IWizardPage nextPage; switch ( databaseMeta.getAccessType() ) { case DatabaseMeta.TYPE_ACCESS_OCI: nextPage = wiz.getPage( "oci" ); // OCI break; case DatabaseMeta.TYPE_ACCESS_ODBC: nextPage = wiz.getPage( "odbc" ); // ODBC break; case DatabaseMeta.TYPE_ACCESS_PLUGIN: nextPage = wiz.getPage( databaseMeta.getPluginId() ); // e.g. SAPR3 break; default: // Generic or Native if ( databaseMeta.getDatabaseInterface() instanceof GenericDatabaseMeta ) { // Generic nextPage = wiz.getPage( "generic" ); // generic } else { // Native nextPage = wiz.getPage( "jdbc" ); if ( nextPage != null ) { // Set the port number... ( (CreateDatabaseWizardPageJDBC) nextPage ).setData(); } } break; } return nextPage; }
Example 7
Source File: KettleDatabaseRepository.java From pentaho-kettle with Apache License 2.0 | 4 votes |
@Override public void create() { if ( repositoryMeta.getConnection() != null ) { if ( repositoryMeta.getConnection().getAccessType() == DatabaseMeta.TYPE_ACCESS_ODBC ) { // This will change in a future story log.logDebug( "ODBC type is not advised for repository use" ); } try { if ( !getDatabaseMeta().getDatabaseInterface().supportsRepository() ) { // show error about not being valid log.logError( "This database type does not support being a repository" ); } connectionDelegate.connect( true, true ); boolean upgrade = false; try { String userTableName = getDatabaseMeta().quoteField( KettleDatabaseRepository.TABLE_R_USER ); upgrade = getDatabase().checkTableExists( userTableName ); if ( upgrade ) { // This will change in future story log.logDebug( "Database upgrade will now take place" ); } } catch ( KettleDatabaseException dbe ) { // Roll back the connection: this is required for certain databases like PGSQL // Otherwise we can't execute any other DDL statement. // rollback(); // Don't show an error anymore, just go ahead and propose to create the repository! } if ( upgrade ) { // authenticate as admin before upgrade reconnectAsAdminForUpgrade(); } createRepositorySchema( null, upgrade, new ArrayList<String>(), false ); disconnect(); } catch ( KettleException ke ) { log.logError( "An error has occurred creating a repository" ); } } }