Versions Compared

Old Version 9

changes.mady.by.user Admin Adminovich

Saved on

compared with

New Version 10

changes.mady.by.user Admin Adminovich

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Content

Table of Contents
outlinetrue
stylenone

What should I do if I installed an incompatible version?

Power Database Fields 4Database Fields PRO 4.0 is compatible with Jira 7.xX.

If you have installed DBCF 3.0.x on JIRA 7.x or DBCF 3.1.x / DBCF 4.0.x on JIRA 6.x, perform the following steps:

  1. Uninstall katl-commons.
  2. Uninstall Power Database Fields PRO.
  3. Install the version of Power Database Fields PRO that is compatible with your Jira.

  4. katl-commons should get updated automatically and should now have the correct version as well.

    Note

    After you uninstall katl-commons, some plugins may might remain disabled, so you might need to re-enable them manually.


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

Power Database Fields plugin PRO app 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 This doesn't mean that the app will not work with more than 10K records, it's just that you might experience certain issues with performance and data retrieval.

We plan to re-write the plugin at some point in time to overcome this limitationenhance the app to take care of such cases as well.

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

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

Expand
titleStep-by-step guide for SQL Server databases
  1. Download the latest jdbc driver for sql server (at this moment it is sqljdbc4.2)  
  2. Extract the archive and copy the .jar file (sqljdbc42.jar) to lib folder, from your JIRA

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

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


  4. Restart Jira.

...

Expand
titleStep-by-step guide for Postgres databases
  1. Download the latest jdbc driver for Postgres (at this moment it is postgresql-9.4-1204.jdbc4)  

  2. Copy the .jar file (postgresql-9.4-1204.jdbc4.jar) to lib folder, from your JIRA

  3. Restart Jira.

Note

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

Since Starting with version 4.0.0, you may avoid changing no longer need to change the resource in the context.xml file and can add the resource directly from the UI, via the "Datasources" page.


I experience difficulties using special characters

When users of the Power Database Fields users Database Fields PRO use another language than English and it contains special characters, some translation may might happen at the JDBC driver level. To avoid this, ensure that the translation between char codes doesn't happen.

Expand
titleStep-by-step guide
  1. Go to the conf folder of your Jira and edit the context.xml.

  2. Modify the resource url which defines your data source like this: "useUnicode=yes" and "characterEncoding=UTF-8".

    Code Block
    url="jdbc:DRIVER://IP:PORT/DATABASE?useUnicode=yes&amp;characterEncoding=UTF-8"


  3. Restart your Jira.

How can I use a

...

custom field value in the SQL query?

Most of Power Database Fields PRO users are usually using some custom fields in their queries to filter the data returned from the database. We're assuming that you have already created a database custom field already at this point.

Expand
titleStep-by-step guide
  1. Go to the Database the Database Custom Field page. You will find the database custom fields here.
  2. In the SQL query, usually in the WHERE clause, use the custom field id (e.g. customfield_12345) or the standard fields between braces. You can find the list of standard fields and more details about dynamic query on the Dynamic Query (SQL) page.

Info

Note that this only works for single value Custom Fields. If you need to use multiple value CF, there is a recipe for it here: Using DBCF queries: IN clauses


...