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 18:09 Go to next message
Dan Kaplan is currently offline Dan KaplanFriend
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 15:55 Go to previous messageGo to next message
James Sutherland is currently offline James SutherlandFriend
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 18:34 Go to previous messageGo to next message
Dan Kaplan is currently offline Dan KaplanFriend
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 14:59 Go to previous message
James Sutherland is currently offline James SutherlandFriend
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: Sat Dec 20 21:45:59 GMT 2014

Powered by FUDForum. Page generated in 0.01767 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software