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
Duplicated by https://answers.atlassian.com/questions/43344184
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.