JavaMelody on Oracle XML backup fails

[Viktor Kuzmychov]

Hi everyone,

I'm trying to configure JavaMelody to monitor my DB connection and seems like I can successfully do that, but my XML backups fail. 

As soon as I switch back to original configuration my backups work again. 

Original dbconfig.xml:

<?xml version="1.0" encoding="UTF-8"?>

<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>oracle10g</database-type>
<jdbc-datasource>
<url>jdbc:oracle:thin:@//host.name.com:1521/DBNAME</url>
<driver-class>oracle.jdbc.OracleDriver</driver-class>
<username>xxxxxx</username>
<password>xxxxxxx</password>
<pool-min-size>50</pool-min-size>
<pool-max-size>700</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<validation-query>select 1 from dual</validation-query>
<min-evictable-idle-time-millis>60000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>120000</time-between-eviction-runs-millis>
<pool-max-idle>40</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>180</pool-remove-abandoned-timeout>
<pool-test-on-borrow>false</pool-test-on-borrow>
<pool-test-while-idle>true</pool-test-while-idle>
</jdbc-datasource>
</jira-database-config>

After switching looks like this:

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

Here is what I add to server.xml:

<Resource name="UserTransaction" auth="Container" type="javax.transaction.UserTransaction"
factory="org.objectweb.jotm.UserTransactionFactory" jotm.timeout="60"/>
<Manager pathname=""/>
<JarScanner scanManifest="false"/>

<Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
username="xxxxxxxx"
password="xxxxxxxx"
driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@//host.name.com:1521/DBNAME"
minTotal="50"
maxTotal="700"
maxWaitMillis="30000"
validationQuery="select 1 from dual"
minEvictableIdleTimeMillis="60000"
timeBetweenEvictionRunsMillis="120000"
maxIdle="40"
removeAbandonedOnMaintenance="true"
removeAbandonedTimeout="180"
testOnBorrow="false"
testWhileIdle="true"
/>