public static void fillCatalogAndSchemas( IMetadataConnection iMetadataConnection, DatabaseConnection temConnection) throws ClassNotFoundException, InstantiationException, IllegalAccessException, SQLException { java.sql.Connection sqlConn = null; try { MetadataFillFactory dbInstance = MetadataFillFactory.getDBInstance(iMetadataConnection); temConnection = (DatabaseConnection) dbInstance.fillUIConnParams(iMetadataConnection, temConnection); sqlConn = MetadataConnectionUtils.createConnection(iMetadataConnection).getObject(); // because there is no any structure after import into 423 from 402,just sychronized the two // connection's // UISchema for fill catalogs and scheams if (((DatabaseConnection) iMetadataConnection.getCurrentConnection()).getUiSchema() != null) { temConnection.setUiSchema( ((DatabaseConnection) iMetadataConnection.getCurrentConnection()).getUiSchema()); } if (((DatabaseConnection) iMetadataConnection.getCurrentConnection()).getSID() != null) { temConnection.setSID( ((DatabaseConnection) iMetadataConnection.getCurrentConnection()).getSID()); } String dbType = iMetadataConnection.getDbType(); if (sqlConn != null) { DatabaseMetaData dbMetaData = null; // Added by Marvin Wang on Mar. 13, 2013 for loading hive jars dynamically, refer to // TDI-25072. if (EDatabaseTypeName.HIVE.getXmlName().equalsIgnoreCase(dbType)) { dbMetaData = HiveConnectionManager.getInstance().extractDatabaseMetaData(iMetadataConnection); } else { dbMetaData = ExtractMetaDataUtils.getInstance() .getDatabaseMetaData(sqlConn, dbType, false, iMetadataConnection.getDatabase()); } dbInstance.fillCatalogs( temConnection, dbMetaData, iMetadataConnection, MetadataConnectionUtils.getPackageFilter(temConnection, dbMetaData, true)); dbInstance.fillSchemas( temConnection, dbMetaData, iMetadataConnection, MetadataConnectionUtils.getPackageFilter(temConnection, dbMetaData, false)); } } catch (SQLException e) { throw e; } finally { if (sqlConn != null) { ConnectionUtils.closeConnection(sqlConn); } MetadataConnectionUtils.closeDerbyDriver(); } }
/** * DOC scorreia Comment method "main". * * @param args */ public static void main(String[] args) { TypedProperties connectionParams = PropertiesLoader.getProperties(IndicatorEvaluator.class, "db.properties"); String driverClassName = connectionParams.getProperty("driver"); String dbUrl = connectionParams.getProperty("url"); try { // create connection java.sql.Connection connection = ConnectionUtils.createConnection(dbUrl, driverClassName, connectionParams); Connection dataProvider = new AnalysisCreationTest().getDataManager(); // --- test connection evaluator String catalog = "test"; ConnectionEvaluator evaluator = new ConnectionEvaluator(); evaluator.setConnection(connection); // --- create indicators ConnectionIndicator connectionIndicator = SchemaFactory.eINSTANCE.createConnectionIndicator(); evaluator.storeIndicator(dataProvider, connectionIndicator); // SchemaIndicator schemaIndic = SchemaFactory.eINSTANCE.createSchemaIndicator(); // evaluator.storeIndicator(new CatalogSchema(catalog, null), schemaIndic); String sql = createSql(catalog); ReturnCode rc = evaluator.evaluateIndicators(sql, false); if (!rc.isOk()) { System.err.println("Failed to evaluate indicator: " + rc.getMessage()); } // store in file File file = new File("out/myi." + IndicatorsPackage.eNAME); EMFUtil util = new EMFUtil(); util.setUsePlatformRelativePath(false); if (!util.addPoolToResourceSet(file.toURI().toString(), connectionIndicator)) { System.err.println(util.getLastErrorMessage()); } File dp = new File("out/dp.prv"); // util.addPoolToResourceSet(new File("out/dp.prv"), dataProvider); util.addPoolToResourceSet(dp, dataProvider); List<Catalog> tdCatalogs = ConnectionHelper.getCatalogs(dataProvider); for (Catalog tdCatalog : tdCatalogs) { util.addPoolToResourceSet( new File("out/" + tdCatalog.getName() + "." + FactoriesUtil.CAT), tdCatalog); } util.save(); ConnectionUtils.closeConnection(connection); } catch (SQLException e) { // TODO Auto-generated catch block log.error(e, e); } catch (InstantiationException e) { // TODO Auto-generated catch block log.error(e, e); } catch (IllegalAccessException e) { // TODO Auto-generated catch block log.error(e, e); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block log.error(e, e); } }