Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (athena.apache.org: domain of curtisr7@gmail.com designates
 209.85.215.46 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <4F982C96.7030303@renci.org>
References: <4F96DB30.5020204@renci.org>
	<CAP=qHCsE2bRHhhqjapvMqEVqPqqG1QYDCmG8WA1=zx-gV_100A@mail.gmail.com>
	<4F982C96.7030303@renci.org>
Date: Wed, 25 Apr 2012 13:28:46 -0500
Message-ID: 
 <CAP=qHCvFjp7OHpc2OYVQ3h5RxenJXR2rVeFMLknPQODszSNQ4g@mail.gmail.com>
Subject: Re: column already exists....column reserved word
From: Rick Curtis <curtisr7@gmail.com>
To: users@openjpa.apache.org
Content-Type: multipart/alternative; boundary=bcaec554d9aab42bc004be850aa2

--bcaec554d9aab42bc004be850aa2
Content-Type: text/plain; charset=ISO-8859-1

Hmm, that is a super old JIRA. I would expect that this should work. Your
original post said that the exception happens when creating tables... what
happens if you create the tables by hand and delimit this table name via
annotations (via \"...\")? Does the manual delimiter work at runtime?

Thanks,
Rick

On Wed, Apr 25, 2012 at 11:55 AM, Jason <jdr0887@renci.org> wrote:

> Rick,
>
> I am using OpenJPA v2.1.1.
>
> I did find this open bug related to the issue: https://issues.apache.org/*
> *jira/browse/OPENJPA-84 <https://issues.apache.org/jira/browse/OPENJPA-84>
>
> After reading that bug, I figured that I will have to change the name of
> the column to not be a reserved word until this bug is implemented/fixed.
>
> Regards,
> Jason
>
>
> On 04/25/2012 10:01 AM, Rick Curtis wrote:
>
>> Jason -
>>
>> What version of OpenJPA are you running? Can you post the full stacktrace?
>>
>> On Tue, Apr 24, 2012 at 11:56 AM, Jason<jdr0887@renci.org>  wrote:
>>
>>  Hi all,
>>>
>>> I am using OpenJPA with PostgreSQL.  I have a table where a column has
>>> the
>>> name of "grant".  How can I get the schema creation routine to wrap the
>>> column name "grant" in quotes?  Changing the column name is doable, but
>>> not
>>> preferable.
>>>
>>> I have tried the brain dead solution of just using: @Column(name =
>>> "\"grant\"")
>>>
>>> But that results in an error...PersistenceException: column already
>>> exists.
>>>
>>> Any suggestions?
>>>
>>> Regards,
>>> Jason
>>>
>>>
>>>
>>>
>>>
>>>
>>
>


-- 
*Rick Curtis*

--bcaec554d9aab42bc004be850aa2--