JAVAMelody configurations - JNDI

[Heshan Manamperi]

I have configured Javamelody plugin in my JIRA 6.0.6 environment. According to documentation, it requires to change dbconfig.xml and server.xml files. It says it requires to use a jdbc datasource from jndi in order to monitor jdbc connections and SQL requests.

I'm using Oracle database and configuration line mentioned MYSQL.
url="jdbc:mysql://localhost/jiradb?useUnicode=true&characterEncoding=UTF8"

Is it possible to configure this plug-in for Oracle db as well? If so what is the configuration?

[Tiago Comasseto · Accepted solution]

Hi Heshan,

It should be possible with all JIRA supported databases. The jdbc URL for Oracle should be something like this:

jdbc:oracle:thin:@dbserver:1521:ORCL

Cheers

[Satyendra Narwane]

Hi heshan,

you need to do following steps

1. Add the javamelody jar file to <atlassian-jira>/WEB-INF/lib

2. Shutdown the jira

3. In dbconfig.xml replace the

<jdbc-datasource> </jdbc-datasource>

with

<jndi-datasource>

<jndi-name>java:comp/env/jdbc/JiraDS</jndi-name>

</jndi-datasource>

-----------------------------------------------------------------------------------------------

<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>

----------------------------------------------------------------------------------------------

4. Modify the below as per your jdbc-datasource and add

inside the <Context > </Context> tag of server.xml

----------------------------------------------------------------------------------------

<Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"

url="jdbc:oracle:thin:@ xxx.xx.xxx.xx:port No:JIRA"

driver-class="oracle.jdbc.OracleDriver"

driverClassName="oracle.jdbc.OracleDriver"

username="dataBaseUserName"

password="dataBasePassword"

pool-min-size="20"

pool-max-size="150"

pool-max-wait="30000"

min-evictable-idle-time-millis="4000"

time-between-eviction-runs-millis="5000"

pool-max-idle="150"

pool-remove-abandoned="true"

pool-remove-abandoned-timeout="300"

validationQuery="select 1 from dual"

/>

-----------------------------------------------------------------------------------------

5. Now start the jira and do some search realted activity and monitor the jdbc connections and SQL requests.

This work for my jira.

[Dana Jansen]

can i do this with confluence as well? and if so what's the difference?