[Hibernate-issues] [Hibernate-JIRA] Created: (HB-610) column names that are keywords are not enclosed in hyphens

[<leg...@at...>]

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:

  http://opensource.atlassian.com/projects/hibernate/secure/ViewIssue.jspa?key=HB-610


Here is an overview of the issue:
---------------------------------------------------------------------
        Key: HB-610
    Summary: column names that are keywords are not enclosed in hyphens
       Type: Bug

     Status: Unassigned
   Priority: Critical

    Project: Hibernate2
   Versions:
             2.1

   Assignee: 
   Reporter: Andreas Schildbach

    Created: Thu, 8 Jan 2004 1:27 PM
    Updated: Thu, 8 Jan 2004 1:27 PM
Environment: MySQL 3.23
Tomcat 4.1
Windows XP

Description:
I've got a database column named "key" in a legacy database schema under MySQL.

Since "key" seems to be a reserved keyword under MySQL, you have to prepend it with the table-name and ".", like in "where keys.key=?" instead of "where key=?".

The MySQLDialect does not do that ==> Hibernate errors.

Unfortunately I am not allowed to change the DB schema. This means I cannot use Hibernate at the moment.



---------------------------------------------------------------------
JIRA INFORMATION:
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

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira