Java DatabaseMeta.setDataTablespace方法代碼示例

import org.pentaho.di.core.database.DatabaseMeta; //導入方法依賴的package包/類
/**
    *  
 *  Load the Database Info 
    */ 
public static DatabaseMeta loadDatabaseMeta(Repository rep, long id_database) throws KettleException
{
       DatabaseMeta databaseMeta = new DatabaseMeta();
       
	try
	{
		RowMetaAndData r = rep.getDatabase(id_database);
		
		if (r!=null)
		{
			long id_database_type    = r.getInteger("ID_DATABASE_TYPE", 0); // con_type
			String dbTypeDesc = rep.getDatabaseTypeCode(id_database_type);
			if (dbTypeDesc!=null)
			{
				databaseMeta.setDatabaseInterface(DatabaseMeta.getDatabaseInterface(dbTypeDesc));
				databaseMeta.setAttributes(new Properties()); // new attributes
			}
			else
			{
				// throw new KettleException("No database type was specified [id_database_type="+id_database_type+"]");
			}

			databaseMeta.setID(id_database);
			databaseMeta.setName( r.getString("NAME", "") );

			long id_database_contype = r.getInteger("ID_DATABASE_CONTYPE", 0); // con_access 
			databaseMeta.setAccessType( DatabaseMeta.getAccessType( rep.getDatabaseConTypeCode( id_database_contype)) );

			databaseMeta.setHostname( r.getString("HOST_NAME", "") );
			databaseMeta.setDBName( r.getString("DATABASE_NAME", "") );
			databaseMeta.setDBPort( r.getString("PORT", "") );
			databaseMeta.setUsername( r.getString("USERNAME", "") );
			databaseMeta.setPassword( Encr.decryptPasswordOptionallyEncrypted( r.getString("PASSWORD", "") ) );
			databaseMeta.setServername( r.getString("SERVERNAME", "") );
			databaseMeta.setDataTablespace( r.getString("DATA_TBS", "") );
			databaseMeta.setIndexTablespace( r.getString("INDEX_TBS", "") );
               
               // Also, load all the properties we can find...
			final Collection<RowMetaAndData> attrs = rep.getDatabaseAttributes(id_database);
               for (RowMetaAndData row : attrs)
               {
                   String code = row.getString("CODE", "");
                   String attribute = row.getString("VALUE_STR", "");
                   // System.out.println("Attributes: "+(getAttributes()!=null)+", code: "+(code!=null)+", attribute: "+(attribute!=null));
                   databaseMeta.getAttributes().put(code, Const.NVL(attribute, ""));
               }
		}
		
		return databaseMeta;
	}
	catch(KettleDatabaseException dbe)
	{
		throw new KettleException("Error loading database connection from repository (id_database="+id_database+")", dbe);
	}
}
 

import org.pentaho.di.core.database.DatabaseMeta; //導入方法依賴的package包/類
/**
    *  
 *  Load the Database Info 
    */ 
public DatabaseMeta loadDatabaseMeta(ObjectId id_database) throws KettleException
{
	DatabaseMeta databaseMeta = new DatabaseMeta();
	try
	{
		RowMetaAndData r = getDatabase(id_database);
		
		if (r!=null)
		{
			ObjectId id_database_type = new LongObjectId( r.getInteger( KettleDatabaseRepository.FIELD_DATABASE_ID_DATABASE_TYPE, 0) ); // con_type
			String dbTypeDesc = getDatabaseTypeCode( id_database_type );
			if (dbTypeDesc!=null)
			{
				databaseMeta.setDatabaseInterface(DatabaseMeta.getDatabaseInterface(dbTypeDesc));
				databaseMeta.setAttributes(new Properties()); // new attributes
			}
			else
			{
				// throw new KettleException("No database type was specified [id_database_type="+id_database_type+"]");
			}

			databaseMeta.setObjectId(id_database);
			databaseMeta.setName( r.getString(KettleDatabaseRepository.FIELD_DATABASE_NAME, "") );

			ObjectId id_database_contype = new LongObjectId( r.getInteger(KettleDatabaseRepository.FIELD_DATABASE_ID_DATABASE_CONTYPE, 0) ); // con_access 
			databaseMeta.setAccessType( DatabaseMeta.getAccessType( getDatabaseConTypeCode( id_database_contype)) );

			databaseMeta.setHostname( r.getString(KettleDatabaseRepository.FIELD_DATABASE_HOST_NAME, "") );
			databaseMeta.setDBName( r.getString(KettleDatabaseRepository.FIELD_DATABASE_DATABASE_NAME, "") );
			databaseMeta.setDBPort( r.getString(KettleDatabaseRepository.FIELD_DATABASE_PORT, "") );
			databaseMeta.setUsername( r.getString(KettleDatabaseRepository.FIELD_DATABASE_USERNAME, "") );
			databaseMeta.setPassword( Encr.decryptPasswordOptionallyEncrypted( r.getString(KettleDatabaseRepository.FIELD_DATABASE_PASSWORD, "") ) );
			databaseMeta.setServername( r.getString(KettleDatabaseRepository.FIELD_DATABASE_SERVERNAME, "") );
			databaseMeta.setDataTablespace( r.getString(KettleDatabaseRepository.FIELD_DATABASE_DATA_TBS, "") );
			databaseMeta.setIndexTablespace( r.getString(KettleDatabaseRepository.FIELD_DATABASE_INDEX_TBS, "") );
               
               // Also, load all the properties we can find...
			final Collection<RowMetaAndData> attrs = repository.connectionDelegate.getDatabaseAttributes(id_database);
               for (RowMetaAndData row : attrs)
               {
                   String code = row.getString(KettleDatabaseRepository.FIELD_DATABASE_ATTRIBUTE_CODE, "");
                   String attribute = row.getString(KettleDatabaseRepository.FIELD_DATABASE_ATTRIBUTE_VALUE_STR, "");
                   // System.out.println("Attributes: "+(getAttributes()!=null)+", code: "+(code!=null)+", attribute: "+(attribute!=null));
                   databaseMeta.getAttributes().put(code, Const.NVL(attribute, ""));
               }
		}
		
		return databaseMeta;
	}
	catch(KettleDatabaseException dbe)
	{
		throw new KettleException("Error loading database connection from repository (id_database="+id_database+")", dbe);
	}
}