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

[Jeremy Hindmarsh (JIRA)]

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


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