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
