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.wag...@gmail.com <seba.wag...@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 <solomax...@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 <jie...@gmail.com> wrote: >> >> > Greetings, >> > >> > On Sat, Feb 9, 2013 at 12:15 AM, seba.wag...@gmail.com >> > <seba.wag...@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.wag...@gmail.com > -- Sebastian Wagner https://twitter.com/#!/dead_lock http://www.webbase-design.de http://www.wagner-sebastian.com seba.wag...@gmail.com
