Srinivasan Ramu Srinivasan Ramu - 1 year ago 152
MySQL Question

Connecting to MySQL using Groovy

I'm trying to connect to a MySQL database using the below Groovy code on MAC OS 10.10.5 Yosemite

import groovy.sql.Sql

def dbURL = 'jdbc:mysql://localhost:3306/sakila'
def dbUserName = 'root'
def dbPassword = 'Orange@27'
def dbDriver = 'com.mysql.jdbc.Driver''Good')
def db = Sql.newInstance(dbURL,dbUserName,dbPassword,dbDriver)
}catch(Exception e){'DB Error')


But when I execute this code, I see the below message

Sat Aug 13 15:09:14 EDT 2016:INFO:Good
Sat Aug 13 15:09:14 EDT 2016:INFO:DB Error
Sat Aug 13 15:09:14 EDT 2016:INFO:No suitable driver found for jdbc:mysql://localhost:3306/sakila

I have kept the
inside the folder location

Could you please help me in resolving this issue?

Answer Source

In order to use a JDBC driver you need to register it. There are a number of ways to do this:

Using DriverManager

You can register a JDBD driver with a DriverManager:

import java.sql.DriverManager

DriverManager.registerDriver(new com.mysql.jdbc.Driver())

// Remaining Groovy code here


Kind of a hack, but you can also dynamically load the driver's class:


// Remaining Groovy code here

Groovy Grape

Because you're using Soap UI to run the Groovy code, this option may not work for you, but here it is for completeness:


// Remaining Groovy code here
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download