Adding flags in dbconfig.xml causes db connection errors

[Nadica Gaber]

Hi All,

After Jira upgrade on latest version, Troubleshoot and support tools showed that the following flags are missing 'validation-query, pool-test-on-borrow, pool-test-while-idle'

we've added them in the dbconfig.xml file as explained in the KB file:

https://confluence.atlassian.com/jirakb/health-check-database-connection-settings-792636748.html

We are using oracle 12c database and the content of dbconfig.xml is:

<?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:*******</url>
<driver-class>oracle.jdbc.OracleDriver</driver-class>
<username>******</username>
<password>*****</password>
<pool-min-size>20</pool-min-size>
<pool-max-size>20</pool-max-size>
<pool-max-wait>30000</pool-max-wait>
<pool-max-idle>20</pool-max-idle>
<pool-remove-abandoned>true</pool-remove-abandoned>
<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>

<validation-query>select 1 from dual</validation-query>

<pool-test-while-idle>true</pool-test-while-idle>
<pool-test-on-borrow>false</pool-test-on-borrow>
</jdbc-datasource>
</jira-database-config>

After jira restart, it fails to connect to database.

Any advise why would this cause issue?

[Andy Heinzer]

Your dbconfig.xml looks ok to me.  I don't yet have an explanation as to why you might not be able to connect with those settings, perhaps there is something wrong with the URL value, or the username/password in question.

I would recommend using the sample dbconfig shown at the bottom of this document: https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-oracle-938846856.html

What sort of error do you see?  Perhaps you can look in the $JIRAHOME/log/atlassian-jira.log file when Jira tries to start up and see what errors might get generated there to help us understand why this might not work as expected.

Additionally, you can try to use the Jira config tool in order to test a connection to your database.  This utility can both set and test your dbconfig.xml connection settings without actually trying to start Jira itself.