We are not sure where to look next. We are getting the following error on the Kepler Database Custom Field Plugin: Error rendering 'databaseinput'. Please contact your JIRA administrators. Here are the details:The custom fields were working prior to the upgrade to JIRA 7.0. We upgraded from 6.4.10.We are obviously running the Server version of JIRA.If we remove the connection info from the context.xml in the conf folder, the field will actual render but will only have None in the drop down.Here is the info from the context.xml file. I have removed the password and IPs.<?xml version='1.0' encoding='utf-8'?> <Context> --> <WatchedResource>WEB-INF/web.xml</WatchedResource> <WatchedResource>${catalina.base}/conf/web.xml</WatchedResource> <Resource name="JIRACustomTables" auth="Container" type="javax.sql.DataSource" username="username" password="password" driverClassName="net.sourceforge.jtds.jdbc.Driver" url="jdbc:jtds:sqlserver://1.1.1.1:1433/JIRACustomTables" /> </Context>If we change the username or password to be incorrect in the Context file then the field will also render and show only None in the dropdown.We have updated all plugins and are not getting any as action required.We have tested the Query and it works directly against the DB.We do not see any errors in the logs we have looked at. With the exception of getting an error when we put the incorrect password or user name. We are looking in the ..\ProgramFiles\Atlassian\Jira\Logs and ..\Atlassian\Application Data\JIRA\log folders. We are not sure if there is some other place we should be looking to capture the plugin error.We tried uninstalling and reinstalling the plug-in.We tried adding a new field and it has the same results.We have restarted JIRA several times.We have verified that the ..\JIRA\lib folder contains: jtds-1.3.1.jar We are really at a loss as to what to check next. We are looking for guidance on next steps.

Community
Q&A
Jira
Questions
Error rendering 'databaseinput'. Please contact your JIRA administrators.

Changing Status Ordering

Hi,

I'm in the process of re-ordering my statues by means of using the up and down arrows against the status in the Issue Attributes | Statuses Screen - Really Atlassian, is this the only way you could have implemented this functionality! It's truly awful and something to be ashamed of . Frequently the clicks have no impact on the position of the statues. The screen refreshes but the status I'm trying to move is just stuck. Clicking others around it and they don't move either.

This is just making a horrendous process even worse.

Has anyone else come across this and is there a work-around?

Cheers,
Jon C

5 answers

1 accepted

4 votes

Answer accepted

Hi Eric,

You will need to upgrade the jdbc driver, the Microsoft JDBC Drivers 4.2 for SQL Server should resolve your problem.

Best regards,

Alex

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

5 votes

I spent hours researching this. The clue was in @Alexandru Geageac comment to upgrade to MS JDBC drivers. Since JIRA 7 uses Tomcat 8 I kept failing because the wrong jar was being loaded. so for Tomcat 8 JIRA 7 download and copy Microsoft's "sqljdbc4.jar" file into the JIRA \lib directory.

Then change your JIRA conf\context.xml connection as follows, substituting for your own CONNECTION_NAME, USERNAME, PASSWORD, SERVER, PORT, and DATABASE_NAME. Be sure to use the semi-colons in the url string:

&lt;Resource name="CONNECTION_NAME"
        auth="Container"
        type="javax.sql.DataSource"
        username="USERNAME"
        password="PASSWORD"
        driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
        url="jdbc:sqlserver://SERVER:PORT;DatabaseName=DATABASE_NAME"/&gt;

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Did this require a restart for the changes to take place?

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Yup, you should restart the JIRA instance...

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

1 vote

Dan thank you for pointing to the right direction, I had to use sqljdbc42.jar instead for JIRA 7.1.7

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Can you tell me where you found this file? Every time I try to download it from MSFT, I get directed the 4 version instead.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Thanks a lot!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

0 votes

Fantastic resolution Dan.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

Changing Status Ordering

5 answers

1 accepted

Suggest an answer

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events