Messages

1

General Board / DDL Script does not consider FKs in DROP stmts

« on: August 02, 2003, 06:04:26 am »

I have a diagramm for my Oracle Schema, containing lots of foreign keys. When I tell enterprise architect to create DROP statements for my SQL script, the DROP statements try to drop tables that are still referenced by other tables, causing ORA-02449 errors. How can I set EA so that it creates correct DROP scripts?

2

General Board / DDL script for MySQL does not work

« on: July 25, 2003, 02:48:36 pm »

Hello!

The DDL script generated from the EA diagramm (current build) does not work with the mySQL 4.x server:

1. For foreign keys, Create Table needs to specify the InnoDB table type:

CREATE TABLE CUSTOMER (A INT, B CHAR (20), INDEX (A)) TYPE = InnoDB;

(TYPE = InnoDB is missing in the EA output)

2. The Syntax for defining foreign keys is wrong:

Wrong:
ALTER TABLE abonnements
     ADD CONSTRAINT PRIMARY
     PRIMARY KEY (ABONNEMENT_ID)
;

Right:
ALTER TABLE abonnements
     ADD
     PRIMARY KEY (ABONNEMENT_ID)
;

Is there any way to work around this?

3

General Board / Re: Newbie questions - Strings and Collections

« on: October 30, 2002, 03:05:22 am »

Thanks for the tip with the collections, that was exactly was I was looking for I have also tried the language datatypes menu you mentioned, but could not find any string type. I also do not understand how to create a correct mapping. Do you have some experience about that?

4

General Board / Newbie questions - Strings and Collections

« on: October 28, 2002, 10:45:14 am »

Hello!

I am not sure yet what the correct way of expressing Strings and Collection is regarding UML diagrams. I've started with a domain class diagramm, but the default data types for my attributes do not include Strings and Collections like the ones found in Java. What is the correct way to express these? I thought of these:

- Importing the Java main classes (java.*, javax.*) in my project from the JDK source (extremely blows up the EAP file)
- Specifying my own "String" type.

I want to generate Java code from my model at some point of the development process, so I think that I should starting using the right convention now...

Thanks for your ideas,
Andreas Buschka