[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5005?page=c...
]
Jeremy Hindmarsh commented on HHH-5005:
---------------------------------------
Yes I tried putting backticks around the column name. This causes the table name alias to
be appended to the column name but puts doubles quotes around the column name as well.
select geoentity0_.EXPIRY_DATE as EXPIRY16_5_0_, geoentity0_."GEOM.SDO_POINT.Y"
as GEOM17_5_0_, geoentity0_."GEOM.SDO_POINT.X" as GEOM18_5_0_,
geoentity0_.PARENT as PARENT5_0_, geoentity0_.QABY as QABY5_0_, geoentity0_.QADATE as
QADATE5_0_ from ENTITIES geoentity0_ where geoentity0_.ENO=?
This causes the same invalid identifier exception:
java.sql.SQLException: ORA-00904: "GEOENTITY0_"."GEOM.SDO_POINT.X":
invalid identifier
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....
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira