[
https://issues.apache.org/jira/browse/OAK-2986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14585501#comment-14585501
]
Philipp Suter commented on OAK-2986:
------------------------------------
How about adding a default configuration from [0]:
PoolProperties p = new PoolProperties();
p.setUrl(url);
p.setDriverClassName(d.getClass().getName());
p.setUsername(username);
p.setPassword(passwd);
p.setJmxEnabled(true);
p.setTestWhileIdle(false);
p.setTestOnBorrow(true);
p.setValidationQuery("SELECT 1");
p.setTestOnReturn(false);
p.setValidationInterval(30000);
p.setTimeBetweenEvictionRunsMillis(30000);
p.setMaxActive(100);
p.setInitialSize(10);
p.setMaxWait(10000);
p.setRemoveAbandonedTimeout(60);
p.setMinEvictableIdleTimeMillis(30000);
p.setMinIdle(10);
p.setLogAbandoned(true);
p.setRemoveAbandoned(true);
org.apache.tomcat.jdbc.pool.DataSource datasource = new
org.apache.tomcat.jdbc.pool.DataSource();
datasource.setPoolProperties(p);
[0] https://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html
> RDB: switch to tomcat datasource implementation
> ------------------------------------------------
>
> Key: OAK-2986
> URL: https://issues.apache.org/jira/browse/OAK-2986
> Project: Jackrabbit Oak
> Issue Type: Sub-task
> Components: rdbmk
> Affects Versions: 1.2.2, 1.0.15, 1.3
> Reporter: Julian Reschke
> Assignee: Julian Reschke
> Fix For: 1.3.1
>
> Attachments: OAK-2986.diff
>
>
> See <https://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html>.
> In addition, this is the datasource used in Slings datasource service, so
> it's closer to what people will use in practice.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
