There is no dumb question when you try to solve issues.
*Database creation *
I created the database the same way for both version (8.4 and 9.1) using the
following commands :
> sudo -i -u postgres
> psql
> CREATE USER admin;
> ALTER ROLE admin WITH CREATEDB;
> CREATE DATABASE sampleDB OWNER admin;
> ALTER USER admin WITH ENCRYPTED PASSWORD 'mypassword';
About the credentials. I executed successfully the incriminated stored
procedure using the datasource configured in my Geronimo Server using the
same credentials for both old (8.4) and new (9.1). I used the same
credential (admin) using psql command line and the Geronimo datasource. In
geronimo, you can use the administration console to execute sql using the
credential defined in the datasource.
I'm pretty confident to exclude the credentials assumption.
*Same Database ? *
I created the datasource the same way using the same database name.
*Entity definition*
Identity generation type :
In my entity i'm defining my id using the following snippet :
/**
* @return the id
*/
@Id
@GeneratedValue (strategy=GenerationType.IDENTITY)
public Long getId() {
return id;
}
--
View this message in context:
http://openjpa.208410.n2.nabble.com/PostgreSQL-9-1-Error-current-transaction-is-aborted-tp7580209p7580230.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
