Groovy connect to Oracle db

[evzensx]

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?

[evzensx · Accepted solution]

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