[hibernate-issues] [Hibernate-JIRA] Commented: (ANN-476) EJB3 naming strategy struggles with quoted identifiers when generating composed table/column names

[Edward Costello (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/ANN-476?page=comments#action_25484 ] 

Edward Costello commented on ANN-476:
-------------------------------------

> Is there any harm in quoting a table/column name even if not necessary? Otherwise, I would suggest a "Better safe than sorry" strategy.

Yes there is. Oracle at least treats identifiers as case sensitive when quoted and case insensitive when unquoted. I suspect you'd find similar issues with some other databases too.

> EJB3 naming strategy struggles with quoted identifiers when generating composed table/column names
> --------------------------------------------------------------------------------------------------
>
>          Key: ANN-476
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-476
>      Project: Hibernate Annotations
>         Type: Improvement

>     Versions: 3.2.0.ga
>  Environment: Hibernate Core/Annotations v3.2.0.GA
> JDK 1.5.0_07
>     Reporter: Benjamin Bentmann
>     Priority: Minor
>      Fix For: 3.2.1

>
>
> Improve EJB3 naming strategy to allow quoted identifiers when composing default table/column names.
> Related forum posting:
> http://forum.hibernate.org/viewtopic.php?t=966257

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira