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.
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 |