Grails postgresql db connection

Question

Just started Grails. Went through all questions but still with the issue. Connector seems in place. jdbc connector in the lib folder and dependency added to a class path

repositories of BuildConfig

 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://repository.codehaus.org"
    //mavenRepo "http://download.java.net/maven/2/"
    //mavenRepo "http://repository.jboss.com/maven2/"
    //mavenRepo "http://repo1.maven.org/maven2/"
}

DataSource

dataSource {
    pooled = true
    jmxExport = true
    driverClassName = "org.postgresql.Driver"
    username = "postgres"
    password = "password"
}

environments {
    development {
        dataSource {
        dbCreate = "update"
        url = "jdbc:postgresql://localhost:5433/dev1base"
    }
}

And I get this:

|Loading Grails 2.4.3
|Configuring classpath
Error |
Resolve error obtaining dependencies: Could not find artifact postgresql:postgresql:jar:9.3-  1100.jdbc4 in grailsCentral (http://repo.grails.org/grails/plugins) (Use --stacktrace to see the full trace)
Error |
Resolve error obtaining dependencies: Could not find artifact postgresql:postgresql:jar:9.3-1100.jdbc4 in grailsCentral (http://repo.grails.org/grails/plugins) (Use --stacktrace to see the full trace)
Error |
Could not find artifact postgresql:postgresql:jar:9.3-1100.jdbc4 in grailsCentral (http://repo.grails.org/grails/plugins)
|Run 'grails dependency-report' for further information.

There shouldn't be magic here.

Joshua Moore · Accepted Answer · 2014-10-30 22:26:13Z

3

The issue is in the formatting of your artifact. It should be:

runtime 'org.postgresql:postgresql:9.3-1100-jdbc41'

Notice that the final period should be a dash instead.

answered Oct 30, 2014 at 22:26

Joshua Moore

24.8k6 gold badges52 silver badges73 bronze badges

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

2 Comments

Maxim Over a year ago

You're right in 6 mins green check, but why it's not written somewhere clearly? grails.org/Quick+Start example shows this: dependencies { … runtime "postgresql:postgresql:8.3-603.jdbc3" }

sebnukem Over a year ago

@Maxim It would appear that postgresql uses different formatting with different versions. The more recent ones use a dash instead of a dot as well as an extra "org." prefix.

sebnukem · Accepted Answer · 2014-10-30 22:39:43Z

1

Add a dependency in Config.groovy:

dependencies {
    runtime 'org.postgresql:postgresql:9.3-1101-jdbc41'

This is the version I am using, but you can try yours first (mind the format: add an 'org.' prefix and replace a '.' with a '-'). A even more recent version 1102 also seems to be available (http://mvnrepository.com/artifact/org.postgresql/postgresql)

edited Oct 30, 2014 at 22:39

answered Oct 30, 2014 at 22:27

sebnukem

8,3536 gold badges40 silver badges49 bronze badges

1 Comment

Maxim Over a year ago

Thanks for the reference. *-jdbc4 in my case works too.

Collectives™ on Stack Overflow

Grails postgresql db connection

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related