Custom Database Field not retrieving data after upgrade to 6.0.2

Originally, this was set up to read via a JNDI database name, now with 6.0.2 we use dbconfig.xml to name the database and the custom database field is not able to read from it.

How do I restore the custom database field's capability?

2 answers

1 accepted

1 vote
Accepted answer

As it turned out, after some experimentation, the problem was the persistence manager in config.xml Previously it was set to

<Manager className="org.apache.catalina.session.PersistentManager" saveOnRestart="false">

The recommended setting in 6.0.2 is

<Manager pathname=""/>

It turns out that the previous persistence manager setting never works when a JNDI resource is defined in the config.xml and it mostly works when the JNDI entry is omitted.

We were using the old persistence manager, so we had to remove the JNDI entry and try a few times to launch Jira.

By going to the new, recommended persitence manager setting, we were able to launch with the JNDI resource defined.

You should define your data source in the context.xml file, under the JIRA_HOME/conf folder, as described here:

Actually I was already aware of this answer from the custom database field documentation, but it doesn't fully address the problem.

I tried with setting up a JNDI resource in config.xml (the way it used to be) and Jira failed to load at all. I had to back that out so I could keep the Jira instance running while I figured it out.

What was the error in the log when setting the JNDI resource in the context.xml file? I have tested on Jira 6.0.2 and it works fine declaring the data source as described in documentation.

There was no error or even any progress trace in the Jira log. I don't think Jira ever got close to launching. The tomcat log had

SEVERE: No Store configured, persistence disabled

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 29, 2018 in Jira

How to set up an incident workflow from the VP of Engineering at Sentry

Hey Atlassian community, I help lead engineering at Sentry, an open-source error-tracking and monitoring tool that integrates with Jira. We started using Jira Software Cloud internally last year, a...

1,090 views 0 8
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