[news.eclipse.rt.eclipselink] Re: escaping table names

[tbee <tbee@xxxxxxxx>]

James wrote:
> Automatically escaping table and column names would be a useful feature, 
> please log this as an enhancement request.  

Bug 271782 has been added to the database


> I don't think you can do it 
> with just a DatabasePlatform, you would need to modify the DatabaseTable 
> object.  It will be nice to have some persistence unit property to auto 
> escape all table and column names.


True. Can this be automated? Do all databases use the same style of escaping (double quotes)? Doesn't MSAccess use square brackets? Anyhow, I assumed not and therefore intended to extend the database platform.


> You can put the quotes in your mappings in the mean time.  Instead of 
> setting the table's name to "Group" set it to "\"Group\"".

Only if that is a valid notation for all databases. The user table in postgres is just one scenario I may encounter.

Tom