Normally I'd agree, but we haven't quite made a final database 
decision.  We're also finding that it's very convenient to do initial unit 
test on the developer's PC with hypersonic, then move to our development 
server with a heavier-duty dbms.

Autogeneration means I can put off generating table definitions (which we 
do in xsl) and hopefully avoid generating different sql for different 
databases...

This seems like a pretty basic capability, and there's already provision in 
the individual database schema  (null=, not-null=) files, so I'm hoping 
it's there somewhere.

Kirk Yarina


At 07:46 PM 9/19/00 -0400, you wrote:
>The best way not to use tables autogeneration at all
>Make optimal schema, write table api beans for your schema, write
>application beans
>
>
>----- Original Message -----
>From: "KirkYarina" <[EMAIL PROTECTED]>
>To: "Orion-Interest" <[EMAIL PROTECTED]>
>Sent: Tuesday, September 19, 2000 12:33 PM
>Subject: NULL/NOT NULL with autocreated tables
>
>
> > I'm using orion-ejb-jar.xml to define many of the characteristics of our
> > applications database table fields, and am unable to determine how I can
> > specify NULL/NOT NULL constraints for these fields.  I rtfm (such as it
> > is....) and looked at the orion-ejb-jar dtd, and couldn't find an answer.
> >
> > We're switching between several DBMS's during development, using different
> > databases for different programmers and tasks, and still tweaking the
> > schema a bit.  It's convenient to let Orion automatically create tables
> > while all this is going on but I need to be able to control whether null
> > fields are allowed, and have been unable to figure out how to do so.  Can
> > anyone help?
> >
> > Thanks!


Kirk Yarina
[EMAIL PROTECTED]


Reply via email to