# JDBC driver com.mysql.jdbc.Driver could not be loaded

**URL:** <https://discuss.gradle.org/t/jdbc-driver-com-mysql-jdbc-driver-could-not-be-loaded/6043>\
**Category:** Old Forum Archive\
**Created:** [October 14, 2012, 2:20am UTC](https://discuss.gradle.org/t/jdbc-driver-com-mysql-jdbc-driver-could-not-be-loaded/6043 "2012-10-14T02:20:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![suresh](https://avatars.discourse-cdn.com/v4/letter/s/aca169/32.png) [@suresh](https://discuss.gradle.org/u/suresh)\
**Post date:** [October 14, 2012, 2:20am UTC](https://discuss.gradle.org/t/jdbc-driver-com-mysql-jdbc-driver-could-not-be-loaded/6043/1 "2012-10-14T02:20:00Z")

</div>

Hi Guys,

I am fairly new to gradle. Here is my script:

apply plugin: ‘java’

buildscript {

repositories {

mavenCentral()

}

dependencies {

‘mysql:mysql-connector-java:5.1.16’

} }

task buildTravelDatabase \<\< {

println “Connecting to mysql …”

runScript(“src/travel.sql”, “jdbc:mysql://localhost:3306/test”, “root”, “password”) }

def runScript(scriptName, url, user, password) {

ant.sql(src:scriptName,

driver:‘com.mysql.jdbc.Driver’,

print:true,

url:url,

userid:user,

password:password,

onerror:‘continue’

) }

Maven is able to download the mysql driver jar file into gradle cache still I am getting the below error :

Class Not Found: JDBC driver com.mysql.jdbc.Driver could not be loaded

Can you please help me.

Suresh

---

<div class="post-metadata">

**Author:** ![Peter\_Niederwieser](https://avatars.discourse-cdn.com/v4/letter/p/9f8e36/32.png) [@Peter\_Niederwieser](https://discuss.gradle.org/u/Peter_Niederwieser)\
**Post date:** [October 14, 2012, 4:32am UTC](https://discuss.gradle.org/t/jdbc-driver-com-mysql-jdbc-driver-could-not-be-loaded/6043/2 "2012-10-14T04:32:00Z")

</div>

First, please enclose all code snippets in HTML ‘code’ tags.

Second, your ‘dependencies’ block should look like this:

```gradle
dependencies {
       classpath 'mysql:mysql-connector-java:5.1.16'
  }

```

Does this solve the problem?

---

<div class="post-metadata">

**Author:** ![suresh](https://avatars.discourse-cdn.com/v4/letter/s/aca169/32.png) [@suresh](https://discuss.gradle.org/u/suresh)\
**Post date:** [October 14, 2012, 5:24am UTC](https://discuss.gradle.org/t/jdbc-driver-com-mysql-jdbc-driver-could-not-be-loaded/6043/3 "2012-10-14T05:24:00Z")

</div>

Peter, Thanks for the response.

I will make sure to embed code in tags.

I am still getting the same exception.

What could be the issue ?

---

<div class="post-metadata">

**Author:** ![Peter\_Niederwieser](https://avatars.discourse-cdn.com/v4/letter/p/9f8e36/32.png) [@Peter\_Niederwieser](https://discuss.gradle.org/u/Peter_Niederwieser)\
**Post date:** [October 14, 2012, 5:27am UTC](https://discuss.gradle.org/t/jdbc-driver-com-mysql-jdbc-driver-could-not-be-loaded/6043/4 "2012-10-14T05:27:00Z")

</div>

Actually, you probably have to put the Jar on the Ant task’s class path, not on Gradle’s build script class path. Try something like this (without using a ‘buildscript’ block):

```gradle
configurations {
    sql
}
  dependencies {
    sql 'mysql:mysql-connector-java:5.1.16'
}
  task buildTravelDatabase << {
    ant.sql(classpath: configurations.sql.asPath, ...)
}

```

---

<div class="post-metadata">

**Author:** ![suresh](https://avatars.discourse-cdn.com/v4/letter/s/aca169/32.png) [@suresh](https://discuss.gradle.org/u/suresh)\
**Post date:** [October 14, 2012, 5:50am UTC](https://discuss.gradle.org/t/jdbc-driver-com-mysql-jdbc-driver-could-not-be-loaded/6043/5 "2012-10-14T05:50:00Z")

</div>

It worked. Great help, much appreciated.
