Re: Problems using Grails with Postgresql

From: Richard Huxton <dev(at)archonet(dot)com>
To: priyaa <pri8419(at)yahoo(dot)co(dot)in>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problems using Grails with Postgresql
Date: 2008-07-21 14:18:35
Message-ID: 48849ABB.90800@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A B 2008-07-21 15:33:59 How to remove duplicate lines but save one of the lines?
Previous Message Dushyanth 2008-07-21 13:57:13 Re: [Postgresql 8.2.3] autovacuum starting up even after disabling ?