Task #12292 (new)
Opened 10 years ago
Last modified 8 years ago
RFE: reserved column names
| Reported by: | mtbcarroll | Owned by: | jamoore |
|---|---|---|---|
| Priority: | minor | Milestone: | Unscheduled |
| Component: | ORM | Version: | 5.0.1 |
| Keywords: | n.a. | Cc: | server@… |
| Resources: | n.a. | Referenced By: | n.a. |
| References: | n.a. | Remaining Time: | n.a. |
| Sprint: | n.a. |
Description
In the database we have columns named things like name, time, column and I wonder if it might make our SQL much easier to portably and safely write if our generated persistence annotations could avoid table or column names of any words found on pages like http://www.postgresql.org/docs/9.3/static/sql-keywords-appendix.html even if we leave the corresponding Java/HQL class and property names unchanged in the model so that clients don't see a difference.
Change History (3)
comment:1 Changed 10 years ago by jamoore
comment:2 Changed 9 years ago by mtbcarroll
- Cc server@… added; omero-team@… removed
- Milestone changed from Unscheduled to 5.x
comment:3 Changed 8 years ago by jamoore
- Milestone changed from 5.x to Unscheduled
Note: See
TracTickets for help on using
tickets.
You may also have a look at Agilo extensions to the ticket.
Mark: I agree to some extent. (The previous method used by Hibernate was just to double quote columns, which works. The migration to Oracle was more interesting). But we should really find somewhere more explicit for this that "Unscheduled"/RFE/no story otherwise it's just lost in the see.