Package org.apache.commons.dbcp2.datasources

Examples of org.apache.commons.dbcp2.datasources.PerUserPoolDataSource

42
43
44
45
46
47
48
49
50
51
52
53
54
  @Inject
  public PostgreSQLConnector(Supplier<MetadataStorageConnectorConfig> config, Supplier<MetadataStorageTablesConfig> dbTables)
  {
    super(config, dbTables);

    final BasicDataSource datasource = getDatasource();
    // PostgreSQL driver is classloader isolated as part of the extension
    // so we need to help JDBC find the driver
    datasource.setDriverClassLoader(getClass().getClassLoader());
    datasource.setDriverClassName("org.postgresql.Driver");

    this.dbi = new DBI(datasource);
  }
View Full Code Here
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
  protected BasicDataSource getDatasource()
  {
    MetadataStorageConnectorConfig connectorConfig = getConfig();

    BasicDataSource dataSource = new BasicDataSource();
    dataSource.setUsername(connectorConfig.getUser());
    dataSource.setPassword(connectorConfig.getPassword());
    String uri = connectorConfig.getConnectURI();
    dataSource.setUrl(uri);

    dataSource.setValidationQuery(getValidationQuery());
    dataSource.setTestOnBorrow(true);

    return dataSource;
  }
View Full Code Here
36
37
38
39
40
41
42
43
44
45
46
  @Inject
  public DerbyConnector(Supplier<MetadataStorageConnectorConfig> config, Supplier<MetadataStorageTablesConfig> dbTables)
  {
    super(config, dbTables);

    final BasicDataSource datasource = getDatasource();
    datasource.setDriverClassLoader(getClass().getClassLoader());
    datasource.setDriverClassName("org.apache.derby.jdbc.ClientDriver");

    this.dbi = new DBI(datasource);
  }
View Full Code Here
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
  @Inject
  public MySQLConnector(Supplier<MetadataStorageConnectorConfig> config, Supplier<MetadataStorageTablesConfig> dbTables)
  {
    super(config, dbTables);

    final BasicDataSource datasource = getDatasource();
    // MySQL driver is classloader isolated as part of the extension
    // so we need to help JDBC find the driver
    datasource.setDriverClassLoader(getClass().getClassLoader());
    datasource.setDriverClassName("com.mysql.jdbc.Driver");

    // use double-quotes for quoting columns, so we can write SQL that works with most databases
    datasource.setConnectionInitSqls(ImmutableList.of("SET sql_mode='ANSI_QUOTES'"));

    this.dbi = new DBI(datasource);
  }
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
51
    }


    @Bean(name = "dataSource")
    public BasicDataSource getDataSource() {
        BasicDataSource dataSource = new BasicDataSource();
        dataSource.setDriverClassName(DRIVE_CLASS_NAME);
        dataSource.setUrl(URL);
        dataSource.setUsername(USERNAME);
        dataSource.setPassword(PASSWORD);

        return dataSource;
    }
View Full Code Here
28
29
30
31
32
33
34
35
36
37
38
39
@Configuration
@Profile("testing")
public class TestConfig {
    @Bean(name = "dataSource")
    public BasicDataSource getDataSource() {
        BasicDataSource dataSource = new BasicDataSource();
        dataSource.setDriverClassName("org.hsqldb.jdbcDriver");
        dataSource.setUrl("jdbc:hsqldb:mem:ex");
        dataSource.setUsername("sa");
        dataSource.setPassword("");
        return dataSource;
    }
View Full Code Here
24
25
26
27
28
29
30
31
32
33
34
35
36
public class HibernateConfig {


    @Bean(name = "dataSource")
    public BasicDataSource getDataSource() {
        BasicDataSource dataSource = new BasicDataSource();
        dataSource.setDriverClassName("com.mysql.jdbc.Driver");
        dataSource.setUrl("jdbc:mysql://localhost:3306/spring_mvc_hibernate");
        dataSource.setUsername("root");
        dataSource.setPassword("123456");

        return dataSource;
    }
View Full Code Here
107
108
109
110
111
112
113
114
115
116
117
118
            try { if (conn != null) conn.close(); } catch(Exception e) { }
        }
    }

    public static DataSource setupDataSource(String connectURI) {
        BasicDataSource ds = new BasicDataSource();
        ds.setDriverClassName("oracle.jdbc.driver.OracleDriver");
        ds.setUsername("scott");
        ds.setPassword("tiger");
        ds.setUrl(connectURI);
        return ds;
    }
View Full Code Here
116
117
118
119
120
121
122
123
124
        ds.setUrl(connectURI);
        return ds;
    }

    public static void printDataSourceStats(DataSource ds) {
        BasicDataSource bds = (BasicDataSource) ds;
        System.out.println("NumActive: " + bds.getNumActive());
        System.out.println("NumIdle: " + bds.getNumIdle());
    }
View Full Code Here
122
123
124
125
126
127
128
129
        System.out.println("NumActive: " + bds.getNumActive());
        System.out.println("NumIdle: " + bds.getNumIdle());
    }

    public static void shutdownDataSource(DataSource ds) throws SQLException {
        BasicDataSource bds = (BasicDataSource) ds;
        bds.close();
    }
View Full Code Here
TOP

Related Classes of org.apache.commons.dbcp2.datasources.PerUserPoolDataSource

  • BasicDataSourceExample
  • com.tumivn.sample.web.config.DataConfig
  • com.tumivn.sample.web.config.HibernateConfig
  • com.tumivn.sample.web.config.TestConfig
  • io.druid.metadata.SQLMetadataConnector
  • io.druid.metadata.storage.derby.DerbyConnector
  • io.druid.metadata.storage.mysql.MySQLConnector
  • io.druid.metadata.storage.postgresql.PostgreSQLConnector
  • junit.framework.TestSuite
  • org.apache.commons.dbcp2.ConnectionFactory
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.