An option is to add "order" to the list of reserved keywords in your
orion/config/database-schemas/dbtype.xml file. Then Orion will make the
table name "Order_".
Markus
On Mon, Jun 18, 2001 at 10:24:04AM +0200, Steffen Stundzig wrote:
> 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
>
>
>
--
Markus Holmberg | Give me Unix or give me a typewriter.
[EMAIL PROTECTED] | http://www.freebsd.org/
