Package org.apache.tomcat.jdbc.pool

Examples of org.apache.tomcat.jdbc.pool.DataSource

28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
public class TomcatJdbcPoolDatasourceAccessor implements DatasourceAccessor {

    public DataSourceInfo getInfo(Object resource) throws Exception {
        DataSourceInfo dataSourceInfo = null;
        if (canMap(resource)) {
            DataSource source = (DataSource) resource;
            dataSourceInfo = new DataSourceInfo();
            dataSourceInfo.setBusyConnections(source.getNumActive());
            dataSourceInfo.setEstablishedConnections(source.getNumIdle() + source.getNumActive());
            dataSourceInfo.setMaxConnections(source.getMaxActive());
            dataSourceInfo.setJdbcURL(source.getUrl());
            dataSourceInfo.setUsername(source.getUsername());
            dataSourceInfo.setResettable(false);
        }
        return dataSourceInfo;
    }
View Full Code Here
63
64
65
66
67
68
69
70
71
72
73
74
75
76
  @Inject
  Environment env;

  @Bean
  public javax.sql.DataSource dataSource() {
    DataSource dataSource = new DataSource();
    dataSource.setDriverClassName(env.getProperty("jdbc.driverClassName"));
    dataSource.setUrl(env.getProperty("jdbc.url"));
    dataSource.setUsername(env.getProperty("jdbc.username"));
    dataSource.setPassword(env.getProperty("jdbc.password"));
    dataSource.setTestOnBorrow(true);
    dataSource.setValidationQuery("SELECT 1");
    return dataSource;
  }
View Full Code Here
40
41
42
43
44
45
46
47
48
49
  private static JpaRepositoryFactory factory;
  protected static EntityManager entityManager;

  @BeforeClass
  public static void beforeClass() {
    DataSource dataSource = dataSource();
    entityManager = entityManager(dataSource);
    initFlyway(dataSource);
    factory = new JpaRepositoryFactory(entityManager);
  }
View Full Code Here
71
72
73
74
75
76
77
78
79
80
81
82
    map.put("openjpa.ConnectionFactoryProperties", "PrintParameters=true");
    return emfBean.getObject().createEntityManager(map);
  }

  private static DataSource dataSource() {
    DataSource dataSource = new DataSource();
    dataSource.setDriverClassName("org.hsqldb.jdbcDriver");
    dataSource.setUrl("jdbc:hsqldb:file:target/db;shutdown=true");
    dataSource.setUsername("sa");
    dataSource.setPassword("");
    return dataSource;
  }
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
        p.setMinEvictableIdleTimeMillis(30000);
        p.setMinIdle(10);
        p.setJdbcInterceptors("org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer");
        p.setLogAbandoned(true);
        p.setRemoveAbandoned(true);
        DataSource datasource = new DataSource();
        datasource.setPoolProperties(p);
       
        Connection con = null;
        try {           
          con = datasource.getConnection();
          Statement st = con.createStatement();
          ResultSet rs = st.executeQuery("select * from user");
          int cnt = 1;
          while (rs.next()) {
              System.out.println((cnt++)+". Host:" +rs.getString("Host")+" User:"+rs.getString("User")+" Password:"+rs.getString("Password"));
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
        p.setMinEvictableIdleTimeMillis(30000);
        p.setMinIdle(10);
        p.setLogAbandoned(true);
        p.setRemoveAbandoned(true);
        p.setJdbcInterceptors("org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer");
        DataSource datasource = new DataSource();
        datasource.setPoolProperties(p);
       
        Connection con = null;
        try {           
          Future<Connection> future = datasource.getConnectionAsync();
          while (!future.isDone()) {
              System.out.println("Connection is not yet available. Do some background work");
              try {
                  Thread.sleep(100); //simulate work
              }catch (InterruptedException x) {
View Full Code Here
108
109
110
111
112
113
114
115
116
117
    p.setJmxEnabled(false);

    p.setMaxActive(100);
    p.setInitialSize(10);

    DataSource datasource = new DataSource();
    datasource.setPoolProperties(p);

    return datasource;
  }
View Full Code Here
120
121
122
123
124
125
126
127
128
129
            p.setRemoveAbandonedTimeout(60);
            p.setMinEvictableIdleTimeMillis(30000);
            p.setMinIdle(10);
            p.setLogAbandoned(true);
            p.setRemoveAbandoned(true);
            _instance.datasource = new DataSource();
            _instance.datasource.setPoolProperties(p);
        }
        return _instance;
    }
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
103
104
105
                envCtx = (Context) initCtx.lookup(jndiContext);
            else
                envCtx = initCtx;

            // Look up our data source
            DataSource ds = (DataSource) envCtx.lookup(jndiDatasource);

            // Allocate and use a connection from the pool then put it back
            connection = ds.getConnection();
            if (connection != null)
                connection.close();
            return true;
        }
        else if (this.type.equalsIgnoreCase("jdbc")) {
View Full Code Here
178
179
180
181
182
183
184
185
186
187
188
        p.setLogAbandoned(true);
        p.setRemoveAbandoned(true);
        p.setJdbcInterceptors(
          "org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;"+
          "org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer");
        dataSource = new DataSource();
        dataSource.setPoolProperties(p);
        log.debug("set properties...");
        return dataSource.getConnection();
        // return a connection based on type
//        if (this.type.equalsIgnoreCase("jndi")) {
View Full Code Here
TOP

Related Classes of org.apache.tomcat.jdbc.pool.DataSource

  • com.gmail.nossr50.database.SQLDatabaseManager
  • com.googlecode.psiprobe.beans.TomcatJdbcPoolDatasourceAccessor
  • com.groupon.odo.proxylib.SQLService
  • com.innavace.ds.config.Connection
  • gov.nysenate.openleg.services.UpdateReporter
  • org.apache.marmotta.kiwi.persistence.KiWiPersistence
  • org.apache.stratos.adc.mgt.utils.StratosDBUtils
  • org.apache.tomcat.jdbc.bugs.Bug53367
  • org.apache.tomcat.jdbc.bugs.Bug54225
  • org.apache.tomcat.jdbc.bugs.Bug54227
    • 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.