Question about how to configure for oracle...

I have installed JIRA Build 4.4.4#664-r167664

Do I configure to use oracle manually as per the below doc using dbconfig.xml in the jira_home directory? Or do I use the wizard that comes up when I first go to the jira url?

1 answer

It seems like the documentation gives a few hints on how to answer this question:

The first one is if you've installed JIRA and connected to Oracle in the past and have manual configuration or custom settings, then you should configure manually as stated here:

If you had previously specified any additional custom settings while manually configuring JIRA with Oracle below (for example, adding the <connection-properties>SetBigStringTryClob=true</connection-properties> element to your dbconfig.xml file), these custom settings will be deleted upon clicking the 'Save' button and you will need to reinstate them manually.

The other two reasons mentioned would also mean you would need to configure manually:

1. If you use the JIRA WAR distribution or

2. you have a console-only connection to your JIRA server.

Perhaps some other folks have some input, but based on the documentation I'd take a look at whether or not any of the above apply and also look at the docs on known issues with Oracle to see if any of those might require custom settings. If this is your first time installing JIRA and connecting to Oracle and you can use the GUI then I'd try that and perhaps apply custom settings afterwards if you need them. I'm guessing you'll need to customize the settings though, I seem to recall the connection-properties issue (SetBigStringTryClob=true) being a must. That's explained in the bottom of the link you provided:

If you start experiencing problems when dealing with custom workflows or working with issues that have long descriptions, comments or custom field values, try adding the element <connection-properties>SetBigStringTryClob=true</connection-properties> as a child of the </jdbc-datasource> element in your dbconfig.xml file. Adding this connection property may overcome these problems. Be aware that you will need to restart JIRA for this setting to take effect.

True, but this doc seems to say to do it via the wizard....Houston we have a conflict:

Suggest an answer

Log in or Join to answer
Community showcase
Alexey Matveev
Published Saturday in Jira

How to run Jira in a docker container

Everything below is tested on Ubuntu 17.10. I prefer to use Jira in a docker container because: 1. I can install Jira with a couple of commands. 2. I can start and stop Jira just by starting and s...

95 views 2 5
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot