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.
twix=# select nextval ('public.hibernate_sequence'); nextval
---------
3
(1 row)
twix=# select nextval ('hibernate_sequence'); nextval
---------
4
(1 row)
The sequence was created with the following command:
twix=# create sequence hibernate_sequence; CREATE SEQUENCE
I don't see what the problem could be.
Because of the connectivity problem could not connect to remote database
with pgAdmin. But it's the question for the next post.
Andrey