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 Mon, 11 Feb 2013 07:35:20 GMT
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

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