reserved words and table names

2018-05-11 Thread Matthew Broadhead
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

Re: reserved words and table names

2018-05-11 Thread Matthew Broadhead
in hibernate it is hibernate.globally_quoted_identifiers On 11/05/18 16:41, Matthew Broadhead wrote: 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 i

Re: reserved words and table names

2018-05-11 Thread Matthew Broadhead
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") O

RE: reserved words and table names

2018-05-11 Thread Boblitz John
Hello Mathew, I solved this by extended the Dictionary and overriding the toDBName methods. @Override public String toDBName(DBIdentifier name) { if (!getSupportsDelimitedIdentifiers()) { return name.getName(); } else { for (String s : invalidColumn