Using Postgres with Grails

Question

Has anyone gotten Grails working with Postgres? I have used this tutorial and everything seems to make sense and be correct to me. However when I 'grails run-app' I get this error

Cannot create JDBC driver of class 'org.postgresql.Driver' for connect URL 'jdbc:postgres://10.0.0.21/tribes'
java.sql.SQLException: No suitable driver

My DataSource file is

dataSource {
    pooled = true
    driverClassName = "org.postgresql.Driver"
    dialect = org.hibernate.dialect.PostgreSQLDialect
}
hibernate {
    cache.use_second_level_cache=true
    cache.use_query_cache=true
    cache.provider_class='com.opensymphony.oscache.hibernate.OSCacheProvider'
}
// environment specific settings
environments {
    development {
        dataSource {
            dbCreate = "update"
            url = "jdbc:postgres://10.0.0.21:5432/tribes"
            username = "grails"
            password = "grails"
        }   
    }   
    test {
        dataSource {
            dbCreate = "update"
            url = "jdbc:postgres://10.0.0.21:5432/tribes"
            username = "grails"
            password = "grails"
        }   
    }   
    production {
        dataSource {
            dbCreate = "update"
            url = "jdbc:postgres://10.0.0.21:5432/tribes"
            username = "grails"
            password = "grails"
        }   
    }   
}

yes. I have tried several versions anyway but am pretty sure I have the right one — Joe Cannatti
– Joe Cannatti, Commented Oct 6, 2009 at 20:49

Greg Smith · Accepted Answer · 2009-10-07 00:14:42Z

23

From the FAQ: "[if] you get a runtime error that says 'No suitable driver found', it is likely that the URL passed to DriverManager.getConnection is malformed or otherwise incorrect". So what's wrong with yours? Well, the examples in the tutorial look like this:

jdbc:postgresql://localhost:5432/grails

Yours looks like this:

jdbc:postgres://10.0.0.21:5432/tribes

I'm guessing those missing two letters are causing your trouble.

answered Oct 7, 2009 at 0:14

Greg Smith

18.4k1 gold badge39 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ganesh Krishnan · Accepted Answer · 2011-02-28 04:45:22Z

19

In the BuildConfig.groovy file uncomment the external maven repositories and then add this line

runtime 'postgresql:postgresql:9.0-801.jdbc4' in the dependencies section

answered Feb 28, 2011 at 4:45

Ganesh Krishnan

7,4152 gold badges46 silver badges52 bronze badges

2 Comments

Michael Dillon Over a year ago

This line is essential to getting Grails talking to Postgresql. But you don't need to uncomment any external Maven repos if you have already copied the Postgresql JDBC jar to your project/lib directory. Also, you need to create the database that you reference in your JDBC url before you do grails run-app.

hkong Over a year ago

Updating this since it's been awhile since the answer, and the version of the postgresql driver has been upgraded. The current driver (as of Jan 2014) is: runtime 'org.postgresql:postgresql:9.3-1100-jdbc4' This is for JDK 1.6. You'll need to change that last 'jdbc4' to 'jdbc3' if you're still running JDK 1.5. For more info see jdbc.postgresql.org/download.html

Collectives™ on Stack Overflow

Using Postgres with Grails

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related