Eclipse Community Forums: EclipseLink » Can eclipselink use better table names in its generated sql?

Help

Home

Home » Eclipse Projects » EclipseLink » Can eclipselink use better table names in its generated sql?

Show: Today's Messages :: Show Polls :: Message Navigator

Can eclipselink use better table names in its generated sql? [message #534652]

Wed, 19 May 2010 18:09

Dan Kaplan

Messages: 13
Registered: May 2010

Junior Member

By default eclipselink generates sql and names the tables t0, t1, t2, t3, etc. I was wondering if there's an option to make it generate better table names. For example, instead of outputting "FROM facility t6", it could output "FROM facility facility" or at least "FROM facility facility1".

Thanks,
Dan

Report message to a moderator

Re: Can eclipselink use better table names in its generated sql? [message #534918 is a reply to message #534652]

Thu, 20 May 2010 15:55

James Sutherland

Messages: 1939
Registered: July 2009
Location: Ottawa, Canada

Senior Member

No, there is no such option.

You could log a request for such as option, but it can have naming conflicts. t# are used as they will not conflict, using the name will conflict if the table is joined twice, and using the name# can still conflict if tables have similar names.

James : Wiki : Book : Blog : Twitter

Report message to a moderator