[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Error with MS SQL 2005 and mapping of object with name User

[fastmhaavald]

I have an object annotated as shown below.
Deploying in JBoss FAILS since it does not "see" the table name annotation.

When hibernate tries to create the user table it fails with MS SQL 2005:



@Entity
@Table(name= "USERITEM")
@Inheritance(strategy = InheritanceType.JOINED)
public class User implements Serializable {

...

}


JBoss:

20:16:42,809 ERROR [SchemaUpdate] Unsuccessful: create table User (ID numeric(19,0) identity not null, NAME varchar(255) not null unique, primary key (ID))
20:16:42,809 ERROR [SchemaUpdate] Incorrect syntax near the keyword 'User'.


Datasource in JBoss contains the following since I have not found any mapping spec for 2005 edition.

      <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
      
         <type-mapping>MS SQLSERVER2000</type-mapping>
      





View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3978266#3978266

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3978266