The standard solution is to add into .xml file in /database-schemas the
following:
<disallowed-field name="order" />
> -----Original Message-----
> From: Steffen Stundzig [SMTP:[EMAIL PROTECTED]]
> Sent: &yod;&vav;&fmem; &shin;&nun;&yod; 18 &yod;&vav;&nun;&yod; 2001 10:24
> To: Orion-Interest
> Subject: [EJB][1.5.1] ShowStopper on CMP deploying
>
> Hi,
>
> I've a bean called 'Order' and on deploying this bean orion said:
>
> ---->8-------------------
> Auto-creating table: create table Order (id BIGINT not null primary key,
> deliveryDate char(255), plannedInvoiceDate char(255), actualInvoiceDate
> char(255), ordersInvoiceId char(255), ordersSalesProcessId char(255),
> stateOrderStatusId char(255))
> Warning: Error creating table: Unexpected token: ORDER in statement
> [create
> table Order (id BIGINT not null primary key, deliveryDate char(255),
> plannedInvoiceDate char(255), actualInvoiceDate char(255), ordersInvoiceId
> char(255), ordersSalesProcessId char(255), stateOrderStatusId char(255))]
> done.
> ----8<-------------------
>
> This error occured because 'Order' is a reserved word in SQL. One feasible
> solution could be to rename the bean or to specify an alternative column
> name.
> But I think it would be better to put the table names and the column names
> in
> 'quotas'.
>
> Or I've overlooked something?
>
> I'm using Hypersonic 1.4.
>
> Regards
> Steffen...
>
> --
> ______________________________________________________________________
> Steffen Stundzig mailto:[EMAIL PROTECTED]
> SMB GmbH http://www.smb-tec.com
>
>
>