Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » EclipseLink » Can eclipselink use better table names in its generated sql?
Can eclipselink use better table names in its generated sql? [message #534652] Wed, 19 May 2010 14:09 Go to next message
Dan Kaplan is currently offline 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
Re: Can eclipselink use better table names in its generated sql? [message #534918 is a reply to message #534652] Thu, 20 May 2010 11:55 Go to previous messageGo to next message
James Sutherland is currently offline 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
Re: Can eclipselink use better table names in its generated sql? [message #534947 is a reply to message #534918] Thu, 20 May 2010 14:34 Go to previous messageGo to next message
Dan Kaplan is currently offline Dan Kaplan
Messages: 13
Registered: May 2010
Junior Member
Couldn't the same thing happen if you had a table that was named "t0"?
Re: Can eclipselink use better table names in its generated sql? [message #536938 is a reply to message #534652] Mon, 31 May 2010 10:59 Go to previous message
James Sutherland is currently offline James Sutherland
Messages: 1939
Registered: July 2009
Location: Ottawa, Canada
Senior Member

No, as the alias names are unique among the aliases.


James : Wiki : Book : Blog : Twitter
Previous Topic:Eclipselink 1.1.3 choosing the wrong table id generator
Next Topic:General design question on polymorphic collections and querying
Goto Forum:
  


Current Time: Fri Apr 18 11:48:57 EDT 2014

Powered by FUDForum. Page generated in 0.07196 seconds