Java BasicDataSource.close方法代码示例

import org.apache.commons.dbcp.BasicDataSource; //导入方法依赖的package包/类
public void destroyDataSource(DataSource dataSource) {
    try {
        // for filter to destroy custom datasource
        if (letHandlerDestroyIfSupport(0L, dataSource)) {
            return;
        }

        if (dataSource == null) {
            return;
        }

        BasicDataSource basicDataSource = (BasicDataSource) dataSource;
        basicDataSource.close();
    } catch (SQLException e) {
        logger.error("ERROR ## close the datasource has an error", e);
    }
}
 

import org.apache.commons.dbcp.BasicDataSource; //导入方法依赖的package包/类
public void destroy(Long pipelineId) {
    Map<DbMediaSource, DataSource> sources = dataSources.remove(pipelineId);
    if (sources != null) {
        for (DataSource source : sources.values()) {
            try {
                // for filter to destroy custom datasource
                if (letHandlerDestroyIfSupport(pipelineId, source)) {
                    continue;
                }

                // fallback for regular destroy
                // TODO need to integrate to handler
                BasicDataSource basicDataSource = (BasicDataSource) source;
                basicDataSource.close();
            } catch (SQLException e) {
                logger.error("ERROR ## close the datasource has an error", e);
            }
        }

        sources.clear();
    }
}
 

import org.apache.commons.dbcp.BasicDataSource; //导入方法依赖的package包/类
@Test
public void test() throws Exception {
    try (Server server = new Server(new ServerConfiguration(folder.newFolder().toPath()))) {
        server.start();
        BasicDataSource dataSource = new BasicDataSource();
        dataSource.setUrl("jdbc:herddb:server:localhost:7000?");
        dataSource.setDriverClassName(Driver.class.getName());
        try (Connection connection = dataSource.getConnection();
                Statement statement = connection.createStatement();
                ResultSet rs = statement.executeQuery("SELECT * FROM SYSTABLES")) {
            int count = 0;
            while (rs.next()) {
                System.out.println("table: " + rs.getString(1));
                count++;
            }
            assertTrue(count > 0);
        }
        dataSource.close();

    }
}
 

import org.apache.commons.dbcp.BasicDataSource; //导入方法依赖的package包/类
public synchronized void destory() throws SQLException {
    if (delegate != null) {
        BasicDataSource basicDataSource = (BasicDataSource) delegate;
        basicDataSource.close();
        delegate = null;
    }
    if (dataSourceSupplier != null) {
        dataSourceSupplier.stop();
        dataSourceSupplier = null;
    }
}
 

import org.apache.commons.dbcp.BasicDataSource; //导入方法依赖的package包/类
static void runImportExportTest_Export(final String clientUrl,
    final String userName, final String password,
    final String schemaFileName, final String dataFileName) throws Throwable {

  // first dump this to XML

  String dbtype = (new PlatformUtils()).determineDatabaseType(
      "com.pivotal.gemfirexd.jdbc.ClientDriver", "jdbc:gemfirexd://" + clientUrl);
  getLogger().info("DB TYPE = " + dbtype);

  BasicDataSource dataSource = new BasicDataSource();
  dataSource.setDriverClassName("com.pivotal.gemfirexd.jdbc.ClientDriver");
  dataSource.setUrl("jdbc:gemfirexd://" + clientUrl);
  if (userName != null) {
    dataSource.setUsername(userName);
    dataSource.setPassword(password);
  }

  DatabaseToDdlTask fromDBTask = new DatabaseToDdlTask();
  fromDBTask.addConfiguredDatabase(dataSource);
  fromDBTask.setDatabaseType(dbtype);

  WriteSchemaToFileCommand writeSchemaToFile = new WriteSchemaToFileCommand();
  File schemaFile = new File(schemaFileName);
  writeSchemaToFile.setFailOnError(true);
  writeSchemaToFile.setOutputFile(schemaFile);

  WriteDataToFileCommand writeDataToFile = new WriteDataToFileCommand();
  File dataFile = new File(dataFileName);
  writeDataToFile.setFailOnError(true);
  writeDataToFile.setOutputFile(dataFile);

  fromDBTask.addWriteSchemaToFile(writeSchemaToFile);
  fromDBTask.addWriteDataToFile(writeDataToFile);

  fromDBTask.execute();

  dataSource.close();

  // end dump to XML
}
 

import org.apache.commons.dbcp.BasicDataSource; //导入方法依赖的package包/类
static void runImportExportTest_Import(final Connection netConn,
    final String clientUrl, final String userName, final String password,
    final String schemaFileName, final String dataFileName) throws Throwable {

  // now load the tables using the XML data

  BasicDataSource dataSource = new BasicDataSource();
  dataSource.setDriverClassName("com.pivotal.gemfirexd.jdbc.ClientDriver");
  dataSource.setUrl("jdbc:gemfirexd://" + clientUrl);
  if (userName != null) {
    dataSource.setUsername(userName);
    dataSource.setPassword(password);
  }

  DdlToDatabaseTask toDBTask = new DdlToDatabaseTask();
  toDBTask.addConfiguredDatabase(dataSource);
  File schemaFile = new File(schemaFileName);
  toDBTask.setSchemaFile(schemaFile);

  WriteSchemaToDatabaseCommand writeSchemaToDB =
      new WriteSchemaToDatabaseCommand();
  writeSchemaToDB.setAlterDatabase(true);
  writeSchemaToDB.setFailOnError(true);

  toDBTask.addWriteSchemaToDatabase(writeSchemaToDB);
  toDBTask.execute();

  WriteDataToDatabaseCommand writeDataToDB = new WriteDataToDatabaseCommand();
  File dataFile = new File(dataFileName);
  writeDataToDB.setIsolationLevel(Connection.TRANSACTION_READ_COMMITTED);
  writeDataToDB.setUseBatchMode(true);
  writeDataToDB.setBatchSize(1000);
  writeDataToDB.setDataFile(dataFile);
  writeDataToDB.setFailOnError(true);

  // next check for the success case
  toDBTask = new DdlToDatabaseTask();
  toDBTask.addConfiguredDatabase(dataSource);
  toDBTask.setSchemaFile(schemaFile);

  toDBTask.addWriteDataToDatabase(writeDataToDB);
  toDBTask.execute();

  dataSource.close();

  // end load the tables using the XML data
}
 

import org.apache.commons.dbcp.BasicDataSource; //导入方法依赖的package包/类
@Override
protected void destroyInstance(BasicDataSource instance) throws Exception {
	instance.close();
}