EOModeler & OpenBase 9
EOModeler & OpenBase 9
- Subject: EOModeler & OpenBase 9
- From: Eric Stewart <email@hidden>
- Date: Mon, 18 Jul 2005 16:59:12 -0400
I'm developing an application with WO 5.2.4 & OpenBase 9.
When I use EOModeler to generate SQL to build the database from the
model, it's generating multiple and conflicting index insertion
statements. Here is an example:
START EXAMPLE:
/* The 'Create Database' option is unavailable. */;
DROP TABLE keyword CASCADE;
CREATE TABLE keyword (descriptor char(150) , oid long NOT NULL,
reserved long , usable long );
ALTER TABLE keyword ADD PRIMARY KEY (oid);
create unique index keyword oid;
create index keyword oid;
create index advertising_group_keyword oid_keyword;
delete from _SYS_RELATIONSHIP where relationshipName =
'advertisingGroupKeywords' and source_table = 'keyword' ;
insert into _SYS_RELATIONSHIP (relationshipName, source_table,
source_column, dest_table, dest_column, operator, one_to_many) values
('advertisingGroupKeywords','keyword','oid','advertising_group_keyword','oid_keyword','=',1);
create index keyword oid;
delete from _SYS_RELATIONSHIP where relationshipName = 'paidListings'
and source_table = 'keyword' ;
insert into _SYS_RELATIONSHIP (relationshipName, source_table,
source_column, dest_table, dest_column, operator, one_to_many) values
('paidListings','keyword','oid','paidListing','oid_keyword','=',1);
create index keyword oid;
create index search_engine_listing oid;
delete from _SYS_RELATIONSHIP where relationshipName =
'searchEngineListing' and source_table = 'keyword' ;
insert into _SYS_RELATIONSHIP (relationshipName, source_table,
source_column, dest_table, dest_column, operator, one_to_many) values
('searchEngineListing','keyword','oid','search_engine_listing','oid','=',0);
END EXAMPLE
As you can see, it first creates a unique index for keyword then
creates a normal index. The column in the table ends up having a
normal index rather than an unique one and OpenBase throws warnings
right and left when it runs because it's looking for a unique key.
I'm using OpenBase's PK plugin rather than letting WO handle the
unique key generation. (Just in case you were wonder).
Is anyone else having this problem?
Thanks,
Eric Stewart
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden