Re: Problems using Grails with Postgresql

On Mon, Jul 21, 2008 at 5:00 AM, priyaa <pri8419@yahoo.co.in> wrote:
>
> i am using postgresql instead of mysql ,but while execute i am getting error
> like
>
>
> Caused by: org.codehaus.groovy.runtime.InvokerInvocationException:
> org.springframework.dao.InvalidDataAccessResourceUsageException: could not
> execute query; nested exception is
> org.hibernate.exception.SQLGrammarException: could not execute query
>
>
> my codings in datasource:
>
>
> dataSource {
>        pooled = false
>
>     driverClassName = "org.postgresql.Driver"
>        username ="sa"
>        password =""
> }
> 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" // one of 'create', 'create-drop','update'
>                      url ="jdbc:postgresql://localhost:5432/test"
>                }
>        }
>        test {
>                dataSource {
>                        dbCreate = "update"
>                        url = "jdbc:hsqldb:mem:testDb"
>
>                }
>        }
>        production {
>                dataSource {
>                        dbCreate = "update"
>                        url = "jdbc:hsqldb:file:prodDb;shutdown=true"

Shouldn't that be a pgsql url not hsqldb right there?

It sounds like you're using the wrong db personality with hibernate.
You need hibernate to think in pgsql syntax for it to work right.