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.214.170 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CACeMiA9N29RzfPW3YwLP2icapHhPfE_QN5+M_iGby5FO-57ypw@mail.gmail.com>
References: 
 <CACeMiA9-yrjeBVry11LWjb_Ahv+DCChLWBGz1CNfH6n5J=asWw@mail.gmail.com>
	<CAArU9iZRDNoLGJJiMCsjoOcO3_LvW+_4ZHShDcrxgcdwzK3kbg@mail.gmail.com>
	<CAJmbs8jdE4Gv-w=3a+F5D1DZr11KLk+fo8gmdYJ-Z=fP3xuMmw@mail.gmail.com>
	<CACeMiA9b_RXsZbGevD86xjJEvAv7aYp_7jL32m5bMC1h0Qmx1g@mail.gmail.com>
	<CACeMiA8QoG-FB1RN8mimvqnxBbSJ8fK5CgnWtGUMJXxLO_76nQ@mail.gmail.com>
	<CACeMiA9N29RzfPW3YwLP2icapHhPfE_QN5+M_iGby5FO-57ypw@mail.gmail.com>
Date: Tue, 12 Feb 2013 08:30:08 -0600
Message-ID: 
 <CAP=qHCuTbzwB=Sbcm6OJv6W93UzFrasUiqpQAs6goHgmJKpVWw@mail.gmail.com>
Subject: Re: OpenJPA has issues with table name "user" and Apache Derby
 database
From: Rick Curtis <curtisr7@gmail.com>
To: users@openjpa.apache.org
Content-Type: multipart/alternative; boundary=14dae9399547cf573b04d587dc11

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

Sebastian -

Yes, I believe this is a bug. That being said, there might be already
support for enabling escaping / delimiting table names in DBDictionary...
I'd look myself, but I don't have a dev environment on this machine. Let us
know what you find out.

Thanks,
Rick


On Mon, Feb 11, 2013 at 1:35 AM, seba.wagner@gmail.com <
seba.wagner@gmail.com> wrote:

> I might be willing to look into the OpenJPA source code to find out the
> root of the issue,
> but it would be good if somebody could confirm that this is a bug that
> needs to be fixed.
>
> Sebastian
>
>
> 2013/2/10 seba.wagner@gmail.com <seba.wagner@gmail.com>
>
> > Btw: The same issue exists with Postgres. We can't choose a table name
> > "user" cause the SQL is not quoted in the sql for string "user".
> >
> > Sebastian
> >
> >
> > 2013/2/10 seba.wagner@gmail.com <seba.wagner@gmail.com>
> >
> > Yes,
> >>
> >> actually you have those reserved keywords in all database. A subset of
> >> those is common across all, some are special in each.
> >> But of course it does not mean that those strings are "forbidden" to
> use.
> >> It simply means you have to escape them! (Or double quoting as the link
> >> to the derby 10.8 docs say).
> >>
> >> For example the word "open" is also a reserved keyword according to the
> >> list. But of course you can name a column "open" in OpenJPA, because it
> is
> >> somehow correctly escaped when the SQL is generated. "user" seems to be
> not
> >> correctly escaped. That is the problem.
> >>
> >> Sebastian
> >>
> >>
> >>
> >> 2013/2/10 Maxim Solodovnik <solomax666@gmail.com>
> >>
> >>> Hello Jesse,
> >>> Thanks for the link!
> >>>
> >>> Is there any option to tell OpenJPA to generate derby compatible SQL?
> >>>
> >>>
> >>> On Sat, Feb 9, 2013 at 8:11 PM, Jesse Farinacci <jieryn@gmail.com>
> >>> wrote:
> >>>
> >>> > Greetings,
> >>> >
> >>> > On Sat, Feb 9, 2013 at 12:15 AM, seba.wagner@gmail.com
> >>> > <seba.wagner@gmail.com> wrote:
> >>> > > we face an issue with OpenJPA 2.2.1 and Derby 10.8.2.2.
> >>> > > When there is a table "user" the schema is correctly created
> >>> > > with SynchronizeMappings.
> >>> > >
> >>> > > However making a query in the that database results in:
> >>> > > org.apache.openjpa.persistence.PersistenceException: Syntax error:
> >>> > > Encountered "user" at line 1, column 888.
> >>> >
> >>> > http://db.apache.org/derby/docs/10.8/ref/rrefkeywords29722.html
> >>> >
> >>> > -Jesse
> >>> >
> >>> > --
> >>> > There are 10 types of people in this world, those
> >>> > that can read binary and those that can not.
> >>> >
> >>>
> >>>
> >>>
> >>> --
> >>> WBR
> >>> Maxim aka solomax
> >>>
> >>
> >>
> >>
> >> --
> >> Sebastian Wagner
> >> https://twitter.com/#!/dead_lock
> >> http://www.webbase-design.de
> >> http://www.wagner-sebastian.com
> >> seba.wagner@gmail.com
> >>
> >
> >
> >
> > --
> > Sebastian Wagner
> > https://twitter.com/#!/dead_lock
> > http://www.webbase-design.de
> > http://www.wagner-sebastian.com
> > seba.wagner@gmail.com
> >
>
>
>
> --
> Sebastian Wagner
> https://twitter.com/#!/dead_lock
> http://www.webbase-design.de
> http://www.wagner-sebastian.com
> seba.wagner@gmail.com
>


-- 
*Rick Curtis*

--14dae9399547cf573b04d587dc11--