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

0 votes

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 Sign up to answer
Community showcase
Published 3 hours ago in Agile

How Scrum works? It starts with training and education

To answer “How scrum works,” most of the teams I've worked with first addressed the question: “where to start?”  That question applies to both implementation and improvements on the Scrum framew...

46 views 1 3
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