[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-5005) Column name not prefixed with table name alias

[Gail Badner (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5005?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=37200#action_37200 ] 

Gail Badner commented on HHH-5005:
----------------------------------

Have you tried putting backticks around the column name, like `GEOM.SDO_POINT.X` ?

> Column name not prefixed with table name alias
> ----------------------------------------------
>
>                 Key: HHH-5005
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5005
>             Project: Hibernate Core
>          Issue Type: Bug
>          Components: annotations
>    Affects Versions: 3.5.0-CR-2
>         Environment: Hibernate 3.5 CR2, Oracle 10g
>            Reporter: Jeremy Hindmarsh
>            Assignee: Gail Badner
>
> If a column name annotation contains a full stop, the column name is not prefixed with the table name alias.
> Some of our database tables contain Oracle spatial data. One in particular has two columns for longitude and latitude,
> GEOM.SDO_POINT.X and GEOM.SDO_POINT.Y
> The problem is that the table alias is not added to the column name due to isIdentifier method in the Template class.
> This method returns false because the column name contains full stops.
> This means the renderWhereStringTemplate method doesn't prefix the column name with the table alias placeholder.
> Fortunately for now I can use the following column definition, in order to get the table alias added.
> @Column(name = "$PlaceHolder$.GEOM.SDO_POINT.X")

-- 
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