Notice: In order to edit this ticket you need to be either: a Product Owner, The owner or the reporter of the ticket, or, in case of a Task not yet assigned, a team_member"

Task #12292 (new)

Opened 6 years ago

Last modified 4 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 6 years ago by jamoore

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.

comment:2 Changed 4 years ago by mtbcarroll

  • Cc server@… added; omero-team@… removed
  • Milestone changed from Unscheduled to 5.x

comment:3 Changed 4 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.

1.3.13-PRO © 2008-2011 Agilo Software all rights reserved (this page was served in: 0.137751 sec.)

We're Hiring!