Unable to display a jira table value using the Kepler db plugin

Hi there,

I'm trying to use this plugin to pull in a list of names from the projectrole table within Jira itself using the add in. I already have this database listed in the context.xml file.

e.g

<Resource name="JIRA_PROD" auth="Container" type="javax.sql.DataSource" username="nnnn" password="nnn" driverClassName="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://servername:port/JIRA_PROD;instance=INSTANCE1" />
</Context>

However when I configure it as below, nothing appears in the drop down. Is there something else that I need to do?

I aleady have another table (non-native) in the Jira database referenced and that works fine.

Thanks in advance

4 answers

1 accepted

This widget could not be displayed.

Hi - thanks for the response. I checked the logs and found that the sql query was incorrect. After a bit of checking I found out that I had to use the full table name (i.e. jira.projectrole) and this worked.

This widget could not be displayed.

Do you have any errors in the logs?

This widget could not be displayed.

which log file did you look at to determine this?

You should look into atlassian-jira log file, located under the JIRA_HOME/log folder.

This widget could not be displayed.

So there's no real problem, but the config. Please mark it as solved

Thanks,

R.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Published yesterday in Marketplace Apps

The 7 hacks of highly successful automation

...there's anything I've learnt from working, it's that people are lazy! No offense to anyone reading this, but it's true and we can all admit it. The easier you make something for someone, the more...

94 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