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

Reply via email to