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
Hi Stéphane,
This should help you: https://confluence.kepler-rominfo.com/display/DBCF/Install+notes+for+JIRA+7
HTH.
Alex
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.