Re: Problems using Grails with Postgresql

On Mon, Jul 21, 2008 at 5:00 AM, priyaa <pri8419(at)yahoo(dot)co(dot)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.