Messages

1

General Board / Re: Designing stored procedures

« on: March 06, 2002, 07:43:04 am »

A lot of the modeling I do right now involves stored procedures. The <<table>> stereotype is one of the reasons I picked Enterprise Architect because it's very useful for modeling result sets.

Here are some techniques I've been using (and that I like, so far). Criticism and comments are welcome!

Stored Procs can be modeled as classes with a single "execute" method. You can type in the correct database data types for parameters even though they won't appear in the dropdown list.

If you have separate packages for Stored Procs and Result Sets, the result set can have the same name as the stored proc. Result sets can be modeled as quite well as classes using the <<table>> stereotype. If the stored proc returns multiple result sets, you can create an additional aggregation class in the model to represent this, and model the execute method of the stored proc as "returning" this aggregation class. Setting Multiplicity comes in handy here if the stored proc returns a variable number of "the same" result set (i.e. the same column layout).

If the stored proc calls other stored procs, those can be represented as members of the stored procedure's class.


Hope this gives you some ideas.

Tim Heckman

2

General Board / Re: dragging classes to logical diagram

« on: February 25, 2002, 01:38:33 pm »

Oops. Sorry, nevermind -- I figured it out.

Found the "AutoInstance" check box...  

Tim

3

General Board / dragging classes to logical diagram

« on: February 25, 2002, 10:38:56 am »

I'm running into behavior I don't remember seeing when I was evaluating EA. Maybe I'm missing something?

My situation is this: I have defined some classes in the Views tree (right-click a package, select "New Element"). Now I would like to add those classes to a Logical Diagram. So, I double-click on a diagram in the tree to open the diagram. Then I drag the class I want from the tree to the diagram in the main window.

What I am expecting is for the class to be represented on the diagram. What is happening instead is that EA is generating an object instance of the class and putting that on the diagram.

What do I have to do to get an already-defined class to appear, as a class, on a Logical-View diagram?

Can anyone offer any help?
Thanks!

Tim

4

General Board / Re: VB Interfaces

« on: January 13, 2002, 03:31:22 pm »

We are releasing a minor upgrade (Build 443) in the next day or so ... I believe you will find the problem you describe resolved in that build.

Thanks for the feedback - check out the release date in the updates section of the forum for news on the the new release.

That's great -- I will keep my eyes open for it!

Thanks for the reply.
Tim Heckman
http://www.bn.com

5

General Board / VB Interfaces

« on: January 11, 2002, 10:03:18 am »

Hi, I'm trying out the evaulation edition.

I have version 3.1.0 build 440.

Trying to forward engineer VB code where a class or classes implement an interface, using a "realization" link. The code is not generated correctly. I'm not sure if I'm doing something wrong or if the tool just does not support this correctly.

* The interface class will have a private member variable for the class that is implementing the interface.
* The implementing classes get a private member variable for the Interface.
* The private functions needed to implement the interface are not included. If I include them in the class diagram, the name of the function in the interface class is changed.
* The implementing classes do not have the Implements <interface name> statement.

I really like this product otherwise, but if I can't get this working I'll have to go to something else because I want to be able to forward-engineer code.

thanks.