Versions Compared

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 4.0 is compatible with Jira 7.x.

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.
  3. Install the version of Power Database Fields 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 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

...

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 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.


...