FAQ

Content

1. I have a large DB with about 30K records and I experience performance issues

Power Database Fields plugin was not designed for dealing with large amount of data. Sometimes, our users reported issues when more than ~10k records were retrieved by the sql queries. this doesn't mean that the app will not work with more than 10K records, it's just that you might experience issues with performance and data retrieval.

We plan to re-write the plugin at some point in time to overcome this limitation.

2. Database custom fields don't work on Jira 7.X

After updating to Jira 7, some user experimented this error (Error rendering 'databaseinput') when using SQL Server databases or the custom fields simply don't work when using PostgreSQL databases.

Step-by-step guide for SQL Server databases

Download the latest jdbc driver for sql server (at this moment it is sqljdbc4.2)
Extract the archive and copy the .jar file (sqljdbc42.jar) to lib folder, from your JIRA

Update the resource from context.xml accordingly. It should look like this:

<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"/>

Restart Jira.

Step-by-step guide for Postgres databases

Download the latest jdbc driver for Postgres (at this moment it is postgresql-9.4-1204.jdbc4)
Copy the .jar file (postgresql-9.4-1204.jdbc4.jar) to lib folder, from your JIRA
Restart Jira.

The same problem may occur for other databasese as well (Oracle, MySQL, hsql). In this case, you should follow the same steps, updating the driver and restarting the JIRA instance.

Since version 4.0.0, you may avoid changing the resource in the context.xml file and add the resource directly from the UI, via the "Datasources" page.