Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] Identifiers not quoted in SQL produced by EclipseLink 2.1.0-SNAPSHOT?

Hello Laird,

The feature you linked adds support for delimiting identifiers, it is still upto the application to specify when delimiting is to be used.  The way to do that at the field level is to define the column name in quotes, ie: @Column(name="\"BUYER_NAME\"")
or you can specify delimiting to be used on all fields using the <delimited-identifiers/> tag within the persistence-unit-defaults element of an orm.xml file. 

Best Regards,
Chris
 

On 20/08/2010 3:15 PM, Laird Nelson wrote:
I just spent several hours getting burned by the fact that an identifier for a column of mine--"lines"--is a reserved word in MySQL.

EclipseLink, apparently, is not quoting identifiers in (at least) its INSERT statements on the MySQL platform.

I found this: https://bugs.eclipse.org/bugs/show_bug.cgi?id=251908, which seems to indicate that such a thing should not happen.

Should I file a bug, or is this enhancement request still in the pipeline?  Or is there some configuration somewhere that I need to provide to EclipseLink to tell it to quote identifiers?

Thanks,
Laird

_______________________________________________ eclipselink-users mailing list eclipselink-users@xxxxxxxxxxx https://dev.eclipse.org/mailman/listinfo/eclipselink-users

Back to the top