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?

http://confluence.atlassian.com/display/JIRA044/Connecting+JIRA+to+Oracle#ConnectingJIRAtoOracle-manually

1 answer

0 vote

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:

http://confluence.atlassian.com/display/JIRA044/Running+the+Setup+Wizard

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Thursday in Off-topic

Friday Fun: Magic Eyes

...staring into the background. Once the image pops out in 3D, you can look around the picture and enjoy. If you will see if you are a true illusion master! :) You did it? :) Wow! Awesome! As a bonus...

480 views 85 11
Join discussion

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