I want to notice another limitation: if you have a CMP bean with ejb-name
say bank/Account, then orion throws an exception when generating tables,
etc. Orion should use table name bank_Account for example but it doesn't
expect a / in ejb-name and fails.
Ara.
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Markus
> Holmberg
> Sent: Monday, June 18, 2001 1:02 PM
> To: Orion-Interest
> Cc: Orion-Interest
> Subject: Re: [EJB][1.5.1] ShowStopper on CMP deploying
>
>
> 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/
>
>
