4 Replies Latest reply on Mar 22, 2004 9:01 AM by Sebastiaan Kortleven

    Reserved Words list not used for columnnames?

    Sebastiaan Kortleven Newbie

      Hi there,

      I've build an entity bean called ViewEJB and would like to put the data in a table called View. Since view is a reserved word, JBoss (3.2.3) will create a table called xView instead (no problem here, although backticks would be a nicer way). But if I add a cmp field called view, my sql server gives an error on the word 'view'.
      This is the sql query I found in my log files:

      CREATE TABLE XView (row_id BIGINT IDENTITY, view VARCHAR(256), CONSTRAINT pk_View PRIMARY KEY ())

      Since view is a reserved word, the sql server will not complete this sql query, and jboss won't load my EJB.
      Ofcourse I could rename my fields, but I would like to know if there is a sollution to my problem and if this is an known issue with jboss.