Database configuration for Java Melody - problem with parameters (connection pool)

[Wojciech Miecznikowski]

Hi,

I connected Java Melody to the Oracle database. I must changed configuration like below:

dbconfig.xml:

<jira-database-config>
 <name>defaultDS</name>
 <delegator-name>default</delegator-name>
 <database-type>oracle10g</database-type>
 <jndi-datasource>
 <jndi-name>java:comp/env/jdbc/JiraDS</jndi-name>
 </jndi-datasource>
</jira-database-config>

additional lines in <Context> in server.xml:

<Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
 url="jdbc:oracle:thin:@//YYY:1525/XXX"
 driverClassName="oracle.jdbc.OracleDriver"
 username="jiradbuser"
 password=
 minIdle="20"
 maxActive="40"
 maxWaitMillis="30000"
 minEvictableIdleTimeMillis="60000"
 timeBetweenEvictionRunsMillis="300000"
 maxIdle="40"
 removeAbandoned="true"
 removeAbandonedTimeout="300"
 />

and Java Melody working fine, but every settings are default, so my connection pool size is not 40, but 8. Do you have any idea why? 

Regards,

Wojciech Miecznikowski

[Ronak]

Hello Wojciech Miecznikowski,

You should have to use maxTotal="40"

<Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
 url="jdbc:oracle:thin:@//YYY:1525/XXX"
 driverClassName="oracle.jdbc.OracleDriver"
 username="jiradbuser"
 password=
 minIdle="20"
 maxTotal="40"
 maxWaitMillis="30000"
 minEvictableIdleTimeMillis="60000"
 timeBetweenEvictionRunsMillis="300000"
 maxIdle="40"
 removeAbandoned="true"
 removeAbandonedTimeout="300"
 />

[Wojciech Miecznikowski]

anyone have any idea? I can not find correct configuration