Grails 2.4.4 with MySql

R

RuRu

Guest
Hi People

I am having an annoying time trying to set up Grails with mysql, it's so annoying that I am getting very frustrated

As of this I need some help with this nonsense.

I am getting this kind of errors

Code:
Error | 
2015-03-08 13:58:00,674 [localhost-startStop-1] ERROR pool.ConnectionPool  - Unable to create initial 
Caused by ClassNotFoundException: com.mysql.jdbc.Driver. 

Error | 
2015-03-08 13:58:00,763 [localhost-startStop-1] ERROR pool.ConnectionPool  - Unable to create initial 

Caused by ClassNotFoundException: com.mysql.jdbc.Driver. 

2015-03-08 13:58:02,215 [localhost-startStop-1] ERROR pool.ConnectionPool  - Unable to create initial connections of pool. 
Message: com.mysql.jdbc.Driver. 

Caused by ClassNotFoundException: com.mysql.jdbc.Driver. 
->>  372 | run       in java.net.URLClassLoader$1



I have looked around for a long time, and none of the solutions has helped me so far. Which is very frustrating.

This are my settings in the DataSource.groovy

Code:
dataSource { 
    pooled = true 
    driverClassName = "com.mysql.jdbc.Driver." 
    dialect = "org.hibernate.dialect.MySQL5InnoDBDialect" 
} 
hibernate { 
    cache.use_second_level_cache = true 
    cache.use_query_cache = true 
    cache.provider_class = 'net.sf.ehcache.hibernate.EhCacheProvider' 
    //  cache.region.factory_class = 'net.sf.ehcache.hibernate.EhCacheRegionFactory' // Hibernate 3 
    //  cache.region.factory_class = 'org.hibernate.cache.ehcache.EhCacheRegionFactory' // Hibernate 4 
    //  singleSession = true // configure OSIV singleSession mode 
    // flush.mode = 'manual' // OSIV session flush mode outside of transactional context 
} 

// environment specific settings 
environments { 
    development { 
        dbCreate = "create" // one of 'create', 'create-drop', 'update', 'validate', '' 
        url = "jdbc:mysql://localhost:3306/gamereview" 
        username = "root" 
        password = "********" 
    } 
    hibernate { 
        show_sql = true 
}


BuildConfig.groovy

Code:
grails.project.dependency.resolver = "maven" // or ivy 
grails.project.dependency.resolution = { 
    // inherit Grails' default dependencies 
    inherits("global") { 
        // specify dependency exclusions here; for example, uncomment this to disable ehcache: 
        // excludes 'ehcache' 
    } 
    log "warn" // log level of Ivy resolver, either 'error', 'warn', 'info', 'debug' or 'verbose' 
    checksums true // Whether to verify checksums on resolve 
    legacyResolve false // whether to do a secondary resolve on plugin installation, not advised and here for backwards compatibility 

    repositories { 
        inherits true // Whether to inherit repository definitions from plugins 

        grailsPlugins() 
        grailsHome() 
        mavenLocal() 
        grailsCentral() 
        mavenCentral() 
        // uncomment these (or add new ones) to enable remote dependency resolution from public Maven repositories 
        mavenRepo "http://mvnrepository.com" 
        mavenRepo "http://snapshots.repository.codehaus.org" 
        mavenRepo "http://repository.codehaus.org" 
        mavenRepo "http://download.java.net/maven/2/" 
        mavenRepo "http://repository.jboss.com/maven2/" 
    } 

    dependencies { 
        // specify dependencies here under either 'build', 'compile', 'runtime', 'test' or 'provided' scopes e.g. 
        runtime 'mysql:mysql-connector-java:5.1.34' 
        // runtime 'org.postgresql:postgresql:9.3-1101-jdbc41' 
       // test "org.grails:grails-datastore-test-support:1.0.2-grails-2.4" 
    } 

    plugins { 
        // plugins for the build system only 
        build ":tomcat:7.0.55" 

        // plugins for the compile step 
        compile ":scaffolding:2.1.2" 
        compile ':cache:1.1.8' 
        compile ":asset-pipeline:1.9.9" 

        // plugins needed at runtime but not for compilation 
        runtime ":hibernate4:4.3.6.1" // or ":hibernate:3.6.10.18" 
        runtime ":database-migration:1.4.0" 
        runtime ":jquery:1.11.1" 

        // Uncomment these to enable additional asset-pipeline capabilities 
        //compile ":sass-asset-pipeline:1.9.0" 
        //compile ":less-asset-pipeline:1.10.0" 
        //compile ":coffee-asset-pipeline:1.8.0" 
        //compile ":handlebars-asset-pipeline:1.3.0.3" 
}


I have no files in libs folder. I have tried putting it in and changing the build config file, all in vain. Clearing cache, deleting ivy cache, as well as .grails folder. Refreshing dependencies and so much more.
I have tested the connection URL in IntelliJ and it works fine, I can connect and work with the DB, so that is not an issue.


It is horrible, and so much time spend being unproductive, which is completely the opposite of what this frameworks claims to be! Leaves a bitter taste, and I have only just started learning it.
 
Top