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. <a href="http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3826821#3826821">View the original post</a> <a href="http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3826821>Reply to the post</a> ------------------------------------------------------- This SF.Net email is sponsored by: IBM Linux Tutorials Free Linux tutorial presented by Daniel Robbins, President and CEO of GenToo technologies. Learn everything from fundamentals to system administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user