Unable to connect to oracle database

manohar chunchu February 21, 2024

i am using to connect to my oracle db. , i downloaded ojdbc jar and placed in my lib path C:\Program Files\Atlassian\Jira\lib and restarted server in script runner console

i written a script like

def oracleDataSource = [
        url: connectionString,
        user: username,
        password: password,
        driver: driver
assume driver is 
 def driver = 'oracle.jdbc.driver.OracleDriver'
   def connectionString = "jdbc:oracle:thin:@${hostname}:${port}:${service_name}"
    try {
        // Initialize the Sql object with the Oracle connection parameters
         def sql = Sql.newInstance(oracleDataSource.url.toString(),

i am getting error Failed to connect to Oracle database: oracle.jdbc.driver.OracleDriver not found by com.onresolve.jira.groovy.groovyrunner [189]


What i am missing?

1 answer

0 votes
Pramodh M
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 21, 2024

Hi @manohar chunchu 

Ensure you have provided the proper schema name in the connection string and also to download the driver and place it the lib directory in installation folder.



manohar chunchu February 21, 2024

i don't want to change default db. , i just want to connect to external db for a specific task using script runner

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events