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

[Nic Brough -Adaptavist- · Accepted solution]

Duplicated by https://answers.atlassian.com/questions/43344184