[hibernate-issues] [Hibernate-JIRA] Commented: (ANN-689) @JoinColumn not quoted for Oracle dialect

[Earnie Dyke (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/ANN-689?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_29266 ] 

Earnie Dyke commented on ANN-689:
---------------------------------

Just for grins and giggles, I upgraded to Core 3.2.5, EM 3.3.1 and Anno 3.3.0 and the problem appears to be fixed. However, now I am getting the following exception:

java.lang.RuntimeException: Could not create Component: org.jboss.seam.core.Validators
...
Caused by: java.lang.NoClassDefFoundError: [Lorg/hibernate/validator/InvalidValue;

Where did InvalidValue go? I can no longer find it in hibernate-annotations.jar.

Earnie!

> @JoinColumn not quoted for Oracle dialect
> -----------------------------------------
>
>                 Key: ANN-689
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-689
>             Project: Hibernate Annotations
>          Issue Type: Bug
>    Affects Versions: 3.2.1
>         Environment: Oracle 10g XE
>            Reporter: Earnie Dyke
>
> Within an @Entity I have the following:
> @ManyToOne(cascase = {}, fetch = FecthType.Lazy)
> @JoinColumn(name = "`PresentationId`")  // Notice the backticks
> public Presentation getPresentation() {
>   return this.presentation;
> }
> the generated SQL for a load is:
> select ... from PRESENTATION presentati0_ left outer join CSESSION csessions1_ on presentati0_."Id"=csessions1_.PresentationId where ...
> Notice that PresentationId in csessions1_.PresentationId is NOT quoted. This causes an exception from Oracle:
> java.sql.SQLException: ORA-00904: "CSESSIONS1_"."PRESENTATIONID": invalid identifier.
> I added the backticks to all @Column annotations and they work. Also PresentationId is not quoted in the SELECT list either.
> Earnie!

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