Database custom field doesn't retrieve information from a CSV file with JIRA 7.2

[Stephane Genin]

Hi,
We have upgraded JIRA from 6.3 to 7.2.
Since the upgrade there is a problem with a custom field based on Database Custom Field, that is retrieved from a CSV file.
The error we get is :
Error rendering 'databaseinput'. Please contact your JIRA administrators.

The configuration is as follows :

In the plugin configuration page
Database (JNDI Name) : ExterneCSVDB
SQL Query : select Application, Domaine from CSV_Externe

In the file context.xml
    <Resource name="ExterneCSVDB"
      auth="Container" type="javax.sql.DataSource"
      username="sa"
      password=""
      driverClassName="org.hsqldb.jdbcDriver"
      url="jdbc:hsqldb:/tomcat/jira7data/bddexterne/BDD_Externe"
    />

In the file BDD_Externe.script
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE TEXT TABLE CSV_EXTERNE(APPLICATION VARCHAR,DOMAINE VARCHAR,PORTEFEUILLE VARCHAR,NOM_PROJET VARCHAR)
SET TABLE CSV_EXTERNE SOURCE "BDD_Externe.csv;ignore_first=true"
CREATE USER SA PASSWORD ""
GRANT DBA TO SA
SET WRITE_DELAY 20

We can't find any errors in the catalina.out file.
I found some suggestions on the Internet but they're all related to postgreSQL or SQLServer.

Thanks
Stéphane

[Alexandru Geageac · Accepted solution]

Hi Stéphane,

This should help you: https://confluence.kepler-rominfo.com/display/DBCF/Install+notes+for+JIRA+7 

HTH.

Alex

[Stephane Genin]

Hi Alexandru

This page only speaks about postgreSQL and SQLServer. What about HSQL?

Is there a specific release of the driver that is compatible?

Thanks

Stéphane

[Stephane Genin]

Hi @Alexandru Geageac

Upgrading the postgreSQL driver didn't change anything. As I explained, I use a CSV file, which seems to be based on the HSQL driver. As HSQL comes with Java, I don't think it's possible to upgrade the related driver.

Stéphane

[Alexandru Geageac]

Hi @Stephane Genin,

If you are looking in the libraries folder of your JIRA 7.2 you will see the hsqldb which is 1.8.0.5 and if you will google a little bit you will find that latest hsqldb is 2.3.4...

Try that version and let us know.

Best Regards,

Alex

[Stephane Genin]

Thanks Alex.

It works and I should have tried...

Stéphane