2 Replies Latest reply on Mar 26, 2008 4:18 PM by cyberanto

    case sensitive oracle column names

    cyberanto

      I am trying to map an Entity Bean into an existing table. The columns in this table are case sensitive.


      If I specify @Column(name=dispName) on the getter of the property, I get the following error:


      INFO  [STDOUT] Hibernate:
          select
              affiliatio0.affiliateId as affiliat11,
              affiliatio0
      .addressId as addressId1,
              affiliatio0
      .DESCRIPTION as DESCRIPT31,
              affiliatio0.dispName as dispName1
          from
              WCMTAFFILIATION affiliatio0
      15:58:16,968 WARN  [JDBCExceptionReporter] SQL Error: 904, SQLState: 42000


      15:58:16,968 ERROR [JDBCExceptionReporter] ORA-00904: "AFFILIATIO0_"."DISPNAME": invalid identifier


      couldn't find where to set the strategy to treat column names case sensitive (I thought this happens automatically if the name is specified)