6:54 a.m.
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:51 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5005) Column name not prefixed with table name alias
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5005?page=c...
]
Sergey Vladimirov commented on HHH-5005:
----------------------------------------
See also HHH-3278 and HHH-4891
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:36 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5005) Column name not prefixed with table name alias
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5005?page=c...
]
Gail Badner commented on HHH-5005:
----------------------------------
What is a "full stop"? Is this a duplicate of HHH-5135?
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:01 a.m.
New subject: [Hibernate-JIRA] Resolved: (HHH-5005) Column name not prefixed with table name alias
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5005?page=c...
]
Gail Badner resolved HHH-5005.
------------------------------
Assignee: Gail Badner
Resolution: Cannot Reproduce
No response and no test case.
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
3:12 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5005) Column name not prefixed with table name alias
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5005?page=c...
]
Jeremy Hindmarsh commented on HHH-5005:
---------------------------------------
A full stop is a dot ("."). Maybe you call it a period. If it is used as part of
a column name eg "GEOM.SDO_POINT.X" then I get the following exception
java.sql.SQLException: ORA-00904: "GEOM"."SDO_POINT"."X":
invalid identifier.
This is because the generated query doesn't append the table alias to the column
name.
select geoentity0_.EXPIRY_DATE as EXPIRY16_5_0_, GEOM.SDO_POINT.Y as GEOM17_5_0_,
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=?
I have just tried hibernate 3.5.1-Final and still get this exception. I guess I'll
continue to use the work around previously mentioned.
This method in Template.java ignores any column name that contains a period and therefore
doesn't add the table name alias.
private static boolean isIdentifier(String token, Dialect dialect) {
return token.charAt(0)=='`' || ( //allow any identifier quoted with backtick
Character.isLetter( token.charAt(0) ) && //only recognizes identifiers
beginning with a letter
token.indexOf('.') < 0
);
}
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
8:20 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5005) Column name not prefixed with table name alias
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5005?page=c...
]
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....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:35 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5005) Column name not prefixed with table name alias
[
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
5343
days inactive
5411
days old
hibernate-issues@lists.jboss.org
6 comments
3 participants
participants (3)
-
Gail Badner (JIRA) -
Jeremy Hindmarsh (JIRA)
-
Sergey Vladimirov (JIRA)