How to configure jira and confluence applications to use oracle OCI client

[Rebecca Puypalat]

To meet expectation of transparent DB failover we have to implemented TAF.

One of the requirement for that technology is to not use oracle thin client- currently that one are used for JIRA and Confluence.

We have installed OCI oracle client and configure tnsnames.ora file with connection parameter to meet TAF expectation.

The problem which we faced are that we are not able to change oracle jdbc thin client to oracle jdbc oci on the jira site.

we have configured jira to use tnsnames.ora file with thin jdbc client for jira, but it is not the goal which we would like to achieve.

So how to configure jira and confluence application to use oracle OCI client?

I submitted a Atlassian support case this morning but if some of you have already experienced situation

Thanks a lot for your feedback

Beckie

[Nic Brough -Adaptavist-]

I've attempted this once.  It's not actually anything to do with JIRA or Confluence, it's the Tomcat that provides them with their data sources.

We got a connection working after following

https://tomcat.apache.org/tomcat-7.0-doc/jndi-datasource-examples-howto.html#Putting_it_all_together

but it failed under load and wasn't worth fixing as we were never going to use it in production as it's not supported.