Downloads (PDF, HTML & XML formats)
JIRA Knowledge Base
Documentation for JIRA 6.4 (This documentation includes the project navigation sidebar). Not using this? See below:
(JIRA 6.4 without sidebar documentation | JIRA 6.3.x documentation | JIRA Cloud documentation | earlier versions of JIRA)
This page has general notes on connecting JIRA to Oracle. It supplements the official Oracle installation documentation.
I've used ojdbc14.jar from Oracle 10.2.0.3 client.
The problem I've experienced is that it didn't wont to connect falling out with exception of "Locale not supported".
It turned out that Regional Setting applet must use English on BOTH Regional Options AND Advanced tabs.
Agter that change everything is quite ok.
Here's an idea. Instead of putting this on your web page:
We thus strongly recommend avoiding Oracle if you have any choice in the matter, for the benefit of all concerned.
How about coding a product that works properly with Oracle?
This app has the issue working with Oracle .
Thanks for your feedback on the documentation. Given the past experiences of our customers who have used Oracle, we must continue to strongly support this recommendation. However, you are quite correct in saying that this warning has been badly worded and can definitely be improved.
I will update the page accordingly.
Does anybody know whether the Oracle password can be encrypted in the server.xml file ?
This is required by most infrastructure or security managers. They don't like clear passwords in flat files ...
If there is no other solution, could you give some arguments that help convince them ...
The Tomcat server needs a clear text password in order to make the DB connection.
In theory, it could use two-way encryption to allow an encrypted password to be in server.xml, which it
could decrypt in order to make the encryption.
However, anyone with half a brain could also decrypt the password, so you just be led into a false sense of security.
It is better to admit that the server.xml is a sensitive file, and make it clear that it needs to be protected.
For more discussion see (eg)
Except where otherwise noted, content in this space is licensed under a Creative Commons Attribution 2.5 Australia License.