Problems using Grails with Postgresql

From: priyaa <pri8419(at)yahoo(dot)co(dot)in>
To: pgsql-general(at)postgresql(dot)org
Subject: Problems using Grails with Postgresql
Date: 2008-07-21 11:00:49
Message-ID: 18565587.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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"

}
}
}
pls help me to execute
--
View this message in context: http://www.nabble.com/Problems-using-Grails-with-Postgresql-tp18565587p18565587.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message A. Kretschmer 2008-07-21 13:47:19 Re: question about performance
Previous Message el dorado 2008-07-21 09:43:15 Fw: Re: C-procedure crashed in Postgres 8.3.3 when using 'text'variable (WinXP) - additional