Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Error creating and getting datasource after version upgrade Script Runner

ignacio.flores January 4, 2023

Recently upgraded Jira Data Center 7.10.1 to version 8.5.19

In my previous version of Jira the ScriptRunner plugin was installed in its version 6.3

For compatibility reasons, when doing the jira upgrade, we updated the script runner plugin to version 6.6, I also tried 6.4.0-p5

After doing this, I started having problems with my scriptfields connecting to both local and external databases. I can't create new resources and in the list of resources to assign to a scriptfield only some appear and not all. getting the following error:
"/rest/scriptrunner/latest/resources/com.onresolve.scriptrunner.canned.db.LocalDatabaseConnection [c.z.hikari.util.DriverDataSource] Registered driver with driverClassName=oracle.jdbc.OracleDriver was not found, trying direct instantiation."

"Error creating datasource: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection"

Unfortunately, the scriptrunner support cannot support me because of the jira version that we have in my client, and unfortunately we cannot upload the jira version yet, since the maximum version that we can reach is 8.5 due to a database issue (Oracle 12c R1)

It should be noted that I have another plugin (Table Grid) that can connect to the database without problems.

Has anyone had this problem and been able to fix it?

For my client it is critical to solve this, since they are fields that contain sensitive information and must work correctly.

1 answer

0 votes
Fabio Racobaldo _Herzum_
Community Champion
January 4, 2023

Hi @ignacio.flores ,

first of all please verify that, during your upgrade, you put db connector in the lib folder under jira installation. It seems that oracle connector jar is missing.

If so, please transfer the connector jar and restart JIRA.

Fabio

ignacio.flores January 4, 2023

Hi @Fabio Racobaldo _Herzum_ 

Thanks for response

After the uprade, copy the jdbc from my backup and stay in the new path:

 /software/jira/app-jira/lib/ojdbc8.jar

ignacio.flores January 6, 2023

any one ? helps please!

Suggest an answer

Log in or Sign up to answer