ContentContents
...
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:
- Uninstall katl-commons.
- Uninstall Power Database Fields PRO.
- Install the version of Power Database Fields PRO that is compatible with your Jira.
katl-commons should get updated automatically and should now have the correct version as well.
| Note |
|---|
After you uninstall katl-commons, some plugins might remain disabled, so you might need to re-enable them manually. |
...
| Expand |
|---|
| title | 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: | 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"/> |
Restart Jira.
|
...
| Expand |
|---|
| title | 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.
| Note |
|---|
The same problem might occur for other databases as well (Oracle, MySQL, hsql). In this case, follow the same steps, updating the driver and restarting the Jira instance. Starting with version 4.0.0, you 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. |
|
...
| Expand |
|---|
|
- Go to the Database Custom Field page.
- 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.
|