Examples of DruidDataSource

Examples of com.alibaba.druid.pool.DruidDataSource

32
33
34
35
36
37
38
    private static final long serialVersionUID = 1026193803901107651L;

    private DruidDataSource dataSource;

    public DruidConnectionProvider() {
        dataSource = new DruidDataSource();
    }
View Full Code Here

Examples of com.alibaba.druid.pool.DruidDataSource

38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
        ModularRealmAuthorizer authorizer = new ModularRealmAuthorizer();
        authorizer.setPermissionResolver(new WildcardPermissionResolver());
        securityManager.setAuthorizer(authorizer);

        //设置Realm
        DruidDataSource ds = new DruidDataSource();
        ds.setDriverClassName("com.mysql.jdbc.Driver");
        ds.setUrl("jdbc:mysql://localhost:3306/shiro");
        ds.setUsername("root");
        ds.setPassword("");

        JdbcRealm jdbcRealm = new JdbcRealm();
        jdbcRealm.setDataSource(ds);
        jdbcRealm.setPermissionsLookupEnabled(true);
        securityManager.setRealms(Arrays.asList((Realm) jdbcRealm));
View Full Code Here

Examples of com.alibaba.druid.pool.DruidDataSource

19
20
21
22
23
24
25
26
27
28
29
30
31
        return jdbcTemplate;
    }

    private static JdbcTemplate createJdbcTemplate() {

        DruidDataSource ds = new DruidDataSource();
        ds.setDriverClassName("com.mysql.jdbc.Driver");
        ds.setUrl("jdbc:mysql://localhost:3306/shiro");
        ds.setUsername("root");
        ds.setPassword("");

        return new JdbcTemplate(ds);
    }
View Full Code Here

Examples of com.alibaba.druid.pool.DruidDataSource

19
20
21
22
23
24
25
26
27
28
29
30
31
        return jdbcTemplate;
    }

    private static JdbcTemplate createJdbcTemplate() {

        DruidDataSource ds = new DruidDataSource();
        ds.setDriverClassName("com.mysql.jdbc.Driver");
        ds.setUrl("jdbc:mysql://localhost:3306/shiro");
        ds.setUsername("root");
        ds.setPassword("");

        return new JdbcTemplate(ds);
    }
View Full Code Here

Examples of com.alibaba.druid.pool.DruidDataSource

19
20
21
22
23
24
25
26
27
28
29
30
31
        return jdbcTemplate;
    }

    private static JdbcTemplate createJdbcTemplate() {

        DruidDataSource ds = new DruidDataSource();
        ds.setDriverClassName("com.mysql.jdbc.Driver");
        ds.setUrl("jdbc:mysql://localhost:3306/shiro");
        ds.setUsername("root");
        ds.setPassword("");

        return new JdbcTemplate(ds);
    }
View Full Code Here

Examples of com.alibaba.druid.pool.DruidDataSource

112
113
114
115
116
117
118
119
120
121
122
    filterList.add(filter);
    return this;
  }
 
  public boolean start() {
    ds = new DruidDataSource();
   
    ds.setUrl(url);
    ds.setUsername(username);
    ds.setPassword(password);
    ds.setDriverClassName(driverClass);
View Full Code Here

Examples of com.alibaba.druid.pool.DruidDataSource

112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
    public void init() {
        try {
            ManagementFactory.getPlatformMBeanServer().registerMBean(JdbcStatManager.getInstance(), new ObjectName("com.alibaba.druid:type=JdbcStatManager"));

            DruidDataSource dataSource = new DruidDataSource();

            ManagementFactory.getPlatformMBeanServer().registerMBean(dataSource, new ObjectName("com.alibaba.druid:type=DataSource"));

            dataSource.setUrl("jdbc:mock:");
            dataSource.setFilters("stat,trace");

            Connection conn = dataSource.getConnection();
            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT 1");
            while (rs.next()) {

            }
View Full Code Here

Examples of com.alibaba.druid.pool.DruidDataSource

23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
    public Connection getConnection(MultiDataSourceConnection connectionProxy, String sql) throws SQLException {
        MultiDataSource multiDataSource = connectionProxy.getHaDataSource();

        Object[] array = multiDataSource.getDataSources().toArray();

        DruidDataSource minDataSource = null;
        int min = 0;
        for (Object item : array) {
            DruidDataSource dataSource = (DruidDataSource) item;

            if (!dataSource.isEnable()) {
                continue;
            }

            int activeCount = dataSource.getActiveCount();

            if (minDataSource == null || activeCount < min) {
                minDataSource = dataSource;
                min = activeCount;
            }

            if (activeCount >= maxActive) {
                continue;
            }

            return dataSource.getConnection();
        }

        if (minDataSource != null) {
            return minDataSource.getConnection();
        }
View Full Code Here

Examples of com.alibaba.druid.pool.DruidDataSource

34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
                throw new SQLException("can not get connection, no availabe datasources");
            }

            int index = (int) (connectionId % size);

            DruidDataSource dataSource = null;

            try {
                // 处理并发时的错误
                dataSource = multiDataSource.getDataSources().get(index);
            } catch (Exception ex) {
                indexErrorCount.incrementAndGet();
                if (LOG.isDebugEnabled()) {
                    LOG.debug("getDataSource error, index : " + index, ex);
                }
                continue;
            }

            assert dataSource != null;

            if (!dataSource.isEnable()) {
                multiDataSource.handleNotAwailableDatasource(dataSource);
                continue;
            }

            Connection conn = null;

            try {
                tryCount++;
                conn = dataSource.getConnection();
            } catch (SQLException ex) {
                LOG.error("getConnection error", ex);

                if (tryCount >= size) {
                    throw ex;
View Full Code Here

Examples of com.alibaba.druid.pool.DruidDataSource

244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
        for (Object item : dataSources) {
            if (!(item instanceof DruidDataSource)) {
                continue;
            }

            DruidDataSource dataSource = (DruidDataSource) item;

            if (collectSqlEnable) {
                DruidDataSourceStatValue statValue = dataSource.getStatValueAndReset();
                statValueList.add(statValue);
            }

            if (collectSqlWallEnable) {
                WallProviderStatValue wallStatValue = dataSource.getWallStatValue(true);
                if (wallStatValue != null && wallStatValue.getCheckCount() > 0) {
                    wallStatValueList.add(wallStatValue);
                }
            }
        }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.