Re: PostgreSQL + hibernate

From: "Myatluk Andrey" <Andrey(dot)Myatluk(at)bercut(dot)ru>
To: "Chris" <dmagick(at)gmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL + hibernate
Date: 2006-01-31 10:33:36
Message-ID: CD481F25862BDF4EB3014619BACB38D8FEC44A@master.office.bercut.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, Chris!

I've set the sequence owner to my database user. It hasn't changed
anything.

I guess I have to connect through psql as user and then see what
happens.
If it fails, what could be my next step?

Andrey

-----Original Message-----
From: Chris [mailto:dmagick(at)gmail(dot)com]
Sent: Tuesday, January 31, 2006 10:26 AM
To: Myatluk Andrey
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] PostgreSQL + hibernate

Hi,

Are you doing this as the same user that your application uses?

Maybe the application postgresql user doesn't have access to the
sequence but the default user you're connecting as does.

( You're connecting as a postgresql super-user because you have a '#' in

your command prompt - a regular user gets = ).

Myatluk Andrey wrote:
> Hi!
>
> I have an application, consisting of Struts 1.2 + Tomcat 5.5 +
Hibernate
> 3.1 + PostgreSQL 8.1
>
> The application is developed on WinXP and installed on Fedora Core 4.
>
> On local machine everything works OK. Both databases are created from
> the same script and application is the same.
>
> But when installed on FC, I get the following exception:
>
> Hibernate: select nextval ('hibernate_sequence') Jan 30, 2006 8:21:35
PM
> org.hibernate.util.JDBCExceptionReporter logExceptions
> WARNING: SQL Error: 0, SQLState: 25P02
> Jan 30, 2006 8:21:35 PM org.hibernate.util.JDBCExceptionReporter
> logExceptions
> SEVERE: ERROR: current transaction is aborted, commands ignored until
> end of transaction block Jan 30, 2006 8:21:35 PM
>
> Although when I'm trying to call hibernate sequence it works fine.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2006-01-31 10:48:17 Re: PostgreSQL + hibernate
Previous Message Howard Cole 2006-01-31 10:33:31 How to enumerate/drop user sessions in windows