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 = ${hostname}:${port}:${service_name}"
log.warn(oracleDataSource.toString())
try {
// Initialize the Sql object with the Oracle connection parameters
def sql = Sql.newInstance(oracleDataSource.url.toString(),
oracleDataSource.user.toString(),
oracleDataSource.password.toString(),
oracleDataSource.driver.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?
