Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: neutral (athena.apache.org: 216.139.250.139 is neither permitted
 nor denied by domain of sursini@gmail.com)
Date: Thu, 8 Nov 2012 01:56:09 -0800 (PST)
From: ubiteck <sursini@gmail.com>
To: users@openjpa.apache.org
Message-ID: <1352368569651-7581664.post@n2.nabble.com>
In-Reply-To: 
 <CABH8erkN1EBjPCLxawM3J6jBbDYACUv4YovHPBm11iq6A3+ENw@mail.gmail.com>
References: <1338883815011-7580209.post@n2.nabble.com>
 <CABH8er=WphXBnuH8MEMnzLFagcMf1ZiS-gZveim-fm3CVkRFvw@mail.gmail.com>
 <slrnjt8sah.o7u.fredrik@scout.jonson.org>
 <CABH8erkN1EBjPCLxawM3J6jBbDYACUv4YovHPBm11iq6A3+ENw@mail.gmail.com>
Subject: Re: Verified database matrix (was: PostgreSQL 9.1 [Error :current
 transaction is aborted])
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_1096572_21307242.1352368569659"

------=_Part_1096572_21307242.1352368569659
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

I found the issue. The problem is related to the use of the underscore in
table name. Let's imagine you have an entity called *SubscriptionEvent *with
an auto generated field called *id* (/GenerationType.IDENTITY/). 
You want OpenJPA to create a table named SUBSCRIPTION_EVENT by using the
following annotation to please you DBA with is favorite naming convention :  
   @Table(name="SUBSCRIPTION_EVENT") 
The problem occurs when the class PostgresDictionary try to determine
whether a sequence is owned by the database using the method is
/isOwnedSequence/. This method use another method called *buildNames* to
define what is the table name and the column name to provide the parameters
to the sql statement : 
SELECT pg_get_serial_sequence(?, ?) 
The argument provided to *buildNames* according to the name provided in the
annotation @Table and the identity field is : "subscription_event_id".
BuildNames split this string using the underscore as separator interpreting
this :
*   Table name : *	subscription 
*  Column name :*	event_id

instead of 
*   Table name :*	 subscription_event 
*Column name :*	id
As a workaround you have to remove the underscore in you table or field
name. But it is in my opinion a bug to rely on the underscore to split the
table from the column name.   
  

--
View this message in context: http://openjpa.208410.n2.nabble.com/PostgreSQL-9-1-Error-current-transaction-is-aborted-tp7580209p7581664.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
------=_Part_1096572_21307242.1352368569659--