Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,364,633
Community Members
 
Community Events
168
Community Groups

Groovy connect to Oracle db

Edited

I am trying to connect to oracle database with groovy . I have used the following code in groovy console 

import groovy.sql.*
import java.sql.Driver
try {
def driver = Class.forName('oracle.jdbc.driver.OracleDriver') as Driver
} catch (ClassNotFoundException e) {
println e.printStackTrace()
}
def url= "jdbc:oracle:thin:@192.168.100.78:1521:oraacc"
def username = "user"
def password = "password"
def sql = Sql.newInstance(url, username, password)
try {
sql.eachRow('select * from tableexample'){ row ->
println row
}
} finally {
sql.close()
}

but getting the following compilation error

java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@192.168.100.78:1521:oraacc

I have place ojdbc7.jar in the /home/jira/jira-server/lib folder and restarted Jira instance. I guess something wrong with classpath but can't found what wrong exactly.

Any ideas how to resolve this?

1 answer

1 accepted

0 votes
Answer accepted

Solved.

import groovy.sql.Sql
import java.sql.Driver

def driver = Class.forName('oracle.jdbc.OracleDriver').newInstance() as Driver
def props = new Properties()
props.setProperty("user", "user")
props.setProperty("password", "password")
def conn = driver.connect("jdbc:oracle:thin:@192.168.100.78:1521:oraacc", props)
def sql = new Sql(conn)
def results = sql.rows("select * from tableexample.repdata ")
return results

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events