[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-5471) Not exception thrown when dealing with reserved words on Microsot SQL Server 2008

[Steve Ebersole (JIRA)]

     [ http://opensource.atlassian.com/projects/hibernate/browse/HHH-5471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steve Ebersole closed HHH-5471.
-------------------------------

      Assignee: Steve Ebersole
    Resolution: Rejected

This is not a bug.  You must tell Hibernate to quote key/reserved words you use as identifiers using the back tick.  

Having Hibernate do this for you based on reported keywords from the driver is planned for a later release.  See http://community.jboss.org/docs/DOC-14928

> Not exception thrown when dealing with reserved words on Microsot SQL Server 2008
> ---------------------------------------------------------------------------------
>
>                 Key: HHH-5471
>                 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5471
>             Project: Hibernate Core
>          Issue Type: Bug
>    Affects Versions: 3.2.1
>         Environment: Hibernate 3.2.1, Microsoft SQL Server 2008, jTDS JDBC Driver
>            Reporter: Maximiliano Gomez Vidal
>            Assignee: Steve Ebersole
>
> I have an entity with the properties "user", "type" and "password", all being reserved words in SQL Server 2008.
> The exported schema shows the CREATE TABLE statement with the corresponding properties. However, the table is not created because of the use of the reserved word user (type and password are reserved but the creation is not aborted by them).
> I'll expect Hibernate to throw an exception as when using reserved words in other RDBMS like MySQL. Instead, it does not report any error and continues with the execution.

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