openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "seba.wagner@gmail.com" <seba.wag...@gmail.com>
Subject Re: OpenJPA has issues with table name "user" and Apache Derby database
Date Sun, 10 Feb 2013 00:24:24 GMT
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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message