Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Database monitoring Connection Pool graph no values

jira-connectionpool.png

Our connection pool graph does not show any values.

The resource is configured via server.xml

<Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"
username=""
password=""
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://localhost:5432/jira"
maxTotal="20"
maxIdle="20"
validationQuery="select 1"
removeAbandoned="true"
removeAbandonedTimeout="300" />

We are running Jira Server (NOT cloud) 8.13.1.

Read / Write shows data

What can we do to see the correct data in graph?

1 answer

1 accepted

0 votes
Answer accepted
Andy Heinzer Atlassian Team Mar 11, 2021

Hi Holger,

I see that you are looking to see database connections within Jira, but none of these appear to show on that graph.  It appears that your configuration though is unusual.  What I mean by that is we are not expecting that Jira will define the database connection in the server.xml file anymore.

It is true that very old versions of Jira, such as Jira 4 and earlier if memory serves, would use the server.xml file to define the database connection, such as using a JNDI.  However Jira deprecated this method of connecting to a database way back in Jira 5.  Since that time the database connection is expected to be defined in the $JIRAHOME/dbconfig.xml and in a different format than the JNDI one we see here.

The use of a JNDI connector for connecting to Jira's database is not supported by Atlassian and in turn we instead recommend using the dbconfig.xml to define these settings.  If you're not sure about how to do that, I would recommend trying to follow the appropriate guide over in Connecting Jira applications to a database as this page links to the various supported databases for Jira 8.13.x, and provides you steps to follow to configure Jira to work with them.

Try configuring Jira in this manner, and then see if this graph populates data in the way we expect it to.

Cheers,

Andy

Hi Andy,

thanks for your answer.

We are using JavaMelody Plugin for monitoring our JIRA instance. To get information abount database in Melody you have to configure it this way :-(

For now its good to know that this configuration is deprecated

By

Holger

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Bitbucket Smart Commits vs. Genius Commits - What's the difference?

If you already heard about Smart Commits in Bitbucket, know that you just stumbled upon something even better (and smarter!): Genius Commits by Better DevOps Automation for Jira Data Center (+ Server...

130 views 0 2
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you