[hibernate-issues] [Hibernate-JIRA] Resolved: (HHH-5128) [regression] Columns named "to_date" no longer work
Gail Badner (JIRA)
noreply at atlassian.com
Tue Apr 20 01:38:21 EDT 2010
[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5128?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gail Badner resolved HHH-5128.
------------------------------
Assignee: Gail Badner
Resolution: Duplicate
> [regression] Columns named "to_date" no longer work
> ---------------------------------------------------
>
> Key: HHH-5128
> URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5128
> Project: Hibernate Core
> Issue Type: Bug
> Affects Versions: 3.5.1
> Environment: Database = Oracle 10g
> Reporter: Ramon Casha
> Assignee: Gail Badner
>
> Using Hibernate 3.2, I had columns named from_date and to_date - these worked without problems.
> Since upgrading to Hibernate 3.5, the column to_date no longer works. When generating SQL queries, this column is not prefixed by the table alias name. For example, Hibernate generates the following SQL:
> select
> amounts0_.from_date as from14_44_1_,
> to_date as to18_44_1_
> --etc--
> from reg_alloc_amount amounts0_
> left outer join reg_alloc_amount allocamoun1_ on amounts0_.rec_link_id=allocamoun1_.alloc_amount_id
> This gives java.sql.SQLException: ORA-00918: column ambiguously defined
> I suspect that Hibernate treats to_date as an Oracle function instead of a column.
--
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
More information about the hibernate-issues
mailing list