Might want to designate other columns not null. That may be beyond the
scope of
JAWS though. I am assuming JAWS is in fact not meant to be a schema
generation
tool.
Isnt there a primary key constraint in sql?
create table bob ( dave not null number, joe number, mary not null number,
constraint bob_pk primary key ( dave, mary ) ) ;
or is that oracle specific?
Aaron Mulder wrote:
> On Tue, 6 Mar 2001, David Jencks wrote:
> > Some databases, such as firebird/interbase, require that columns used in
> > primary keys be defined not null. In order to make JAWS automatic table
> > creation useful for such databases, I suggest we add a nullable element
to
> > JAWS.xml, inside the cmp-field element.
>
> Why don't we instead *always* make the PK fields not null? JAWS
> always runs an insert statement with the PK fields present, right? So
> this would only cause problems if you failed to populate some of primary
> key fields in your ejbCreate, which is a bug anyway IMHO. But if this is
> really critical for some reason, you can always create the tables
> yourself.
>
> Aaron
---------------------------------------------------------------------
This message (including any attachments) contains confidential, proprietary
or privileged information intended for a specific purpose and individual(s),
and is protected by law. If you receive this message in error, please
immediately delete it and all copies of it from your system, destroy any
hard copies of it and notify the sender. Any unauthorized disclosure,
copying or distribution of any part of this message, or the taking of any
unauthorized action based on it, is strictly prohibited.
