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.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
