you may be right. i just tried delimited identifiers but it tries to
add already existing fields
https://stackoverflow.com/questions/6791882/jpa-database-delimiters?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa
now i might just go with @Table(name = "ConditionZ")
On 11/05/18 16:48, Sean McDowell wrote:
Hi -- I tried to enable quoting in OpenJPA to deal with reserved
keywords in MySQL.
The feature seems very buggy and didn't work. I would recommend just
avoiding keywords.
Sean
From: Matthew Broadhead <matthew.broadh...@nbmlaw.co.uk>
To: users@openjpa.apache.org
Date: 11/05/2018 10:41 AM
Subject: reserved words and table names
------------------------------------------------------------------------
i am trying to create a table called Condition but i get
javax.el.ELException: javax.enterprise.inject.CreationException:
org.apache.openjpa.lib.jdbc.ReportingSQLException: You have an error in
your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near 'Condition
condition is a reserved word in MySQL. is there a way to tell OpenJPA
to surround table and column names with backticks in queries? i though
it would do that by default
