Re: Problems using Grails with Postgresql - Mailing list pgsql-general

From Richard Huxton
Subject Re: Problems using Grails with Postgresql
Date
Msg-id 48849ABB.90800@archonet.com
Whole thread Raw
In response to Problems using Grails with Postgresql  (priyaa <pri8419@yahoo.co.in>)
List pgsql-general
priyaa 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

How about providing the error message from the PostgreSQL logs? This
might mean something to a hibernate expert (although I doubt it), but it
doesn't tell me anything.

Make sure you are logging statement errors and show us the error. You
might want to log all statements while getting this to work, that would
give you some context.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Dushyanth
Date:
Subject: Re: [Postgresql 8.2.3] autovacuum starting up evenafter disabling ?
Next
From: "A B"
Date:
Subject: How to remove duplicate lines but save one of the lines?