database-values plugin NullPointerException

[Josep Llaurado]

Hi there,

I downloaded the latest version of database-values-plugin v3.4 under JIRA 6.3.15.

I have configured a first custom field, with the associated file: jira-database-values-plugin-10100.properties

I have tried the connection to the postgreSQL database using the JIRA user I'm using with the query inside the code and it works:

cmdbuild=> select "Id","IdClass","Code","Description" from "CI" where "Status"='A';

 Id |  IdClass  |  Code  |   Description

----+-----------+--------+-----------------

 49 | "Service" | SRVSAP | Servicio de SAP

 But when I create an Issue I get: Error rendering 'databasevaluesselectionfield'. Please contact your JIRA administrators.

Taking a look at the catalina.out log it appears a nullpointer exception: 2015-04-21 11:28:29,268 http-bio-8080-exec-7 WARN j.llaurado 688x907x1 1xyizvc 192.168.170.246 /secure/CreateIssue.jspa [com.atlassian.ozymandias.SafePluginPointAccess] Unable to run plugin code because of 'java.lang.NullPointerException - null'.

But nothing more.

Is there any way to debug the problem a little further?

The properties file:

database.driver=org.postgresql.Driver
database.user=jira
database.password=*******
database.conection.url=jdbc:postgresql://localhost:5432/cmdbuild
cache.timeout=1000
sql.query=select "Id","IdClass","Code","Description" from "CI" where "Status"='A'
primarykey.column.number=0
rendering.viewpattern={3} - {4}
rendering.editpattern={3}, {4}
rendering.searchpattern={3} {4}
rendering.sortpattern={3} {4}
edit.type=2
search.type=1
rendering.changelog.viewpattern={3} {4}
rendering.statistics.viewpattern={3} {4}

[Josep Llaurado · Accepted solution]

I found the answer by myself.

In the configuration I selected a edit type 2 (cascading select) but I miss the parameter to group in the first field. Once I wrote in the config file the line:

rendering.editpattern.group.column.number=1

Everything started working

[Wim Deblauwe]

Great to hear that you have it working.

[Zawistowski Grzegorz]

How to prepere Conection String to MS SQL Please Wim help.