Author Topic: Help with Oracle View modeling  (Read 1164 times)

jtittler

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
  • It's broken, Honey! You let the magic smoke out.
    • View Profile
Help with Oracle View modeling
« on: September 18, 2007, 11:51:19 pm »
I have tried to follow the directions in the online help for modeling database views. Creating a view stereotype etc. In those directions, it seems I should be able to choose my database type in the view properties box when actually dropping an instance of a view on a diagram. There is no database listbox. Instead there's a code listbox which lists things like C++, VB, etc. I must have something misconfigured. The directions then go onto say to click OK on the properties box after setting the stereotype of the class to <view>. Then I should reopen the properties box to select the database type. When I reopen it, all I get is a dialog with a View Definition textbox. This doesn't match the help at all. Any ideas?

Also, the docs mention something about your default database, but I can't seem to find where I can set my default database to Oracle.

This situaltion is time critical for me. Any help would be appreciated.

Thank you in advance for your help.
Julie
EA Corporate version 7.0.814

jtittler

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
  • It's broken, Honey! You let the magic smoke out.
    • View Profile
Re: Help with Oracle View modeling...more weirdnes
« Reply #1 on: September 19, 2007, 12:13:06 am »
I figured, OK... I'm stuck on this view thing. Let's model the stored procedure package, instead. According to the online help, I'm supposed to be able to pick <package> as a stereotype for class. Looking in the UML Types in EA, there doesn't seem to be a Package stereotype. My installation must be screwed up or something. Any ideas?

Thanks again,
Julie

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: Help with Oracle View modeling
« Reply #2 on: September 19, 2007, 03:04:35 am »
Julie,

You're almost there.

Just add such a stereotype into the list in the Settings | UML | Stereotypes dialog. You'll find a similar case if you look up Data Modeling | Stored Procedures in the help index.

[You could also just type the stereotype into the element dialog without adding it to the list, but I don't recommend this, even if it works.]

When you add the stereotype to the list, it becomes part of the reference data for that project. If you want several such stereotypes in another model, you can export this category of reference data from one model and import it into the new one. You could also import this data into the EABase model - you will find this in your EA install directory - and it will be the default for newly created projects.

David
No, you can't have it!

RoyC

  • EA Administrator
  • EA Practitioner
  • *****
  • Posts: 1200
  • Karma: +10/-3
  • Read The Help!
    • View Profile
Re: Help with Oracle View modeling
« Reply #3 on: September 19, 2007, 03:22:20 pm »
Julie

You seem to have hit a known bug with the display of the database field. This bug was fixed in release 816, with a new dialog and Database field when you first create the Database view, and the Database field displaying on the element Properties dialog for subsequent edits and instances of the View.

To set the Default Database, use the Code Generation Toolbar (View | Toolbars | Code Generation). The second dop-down field enables you to set the default database.

If you have further problems, please send in a bug report. It would be great if you could also identify where the Help is not helping, so that we can fix that too. Thanks!

HTH

Roy
Best Regards, Roy

jtittler

  • EA Novice
  • *
  • Posts: 4
  • Karma: +0/-0
  • It's broken, Honey! You let the magic smoke out.
    • View Profile
Re: Help with Oracle View modeling
« Reply #4 on: September 19, 2007, 11:52:59 pm »
Thank you both so much for the information. It was quite helpful. When I have time, I will gladly point out where I find the Help Topics in this area a little confusing.

Kindest Regards,
Julie Tittler

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: Help with Oracle View modeling
« Reply #5 on: September 20, 2007, 06:58:47 am »
Julie,

Good to know you're moving forward.

And thanks for your offer to search for documentation glitches. Roy is doing legion duty in repairing these, but we need to bring them to his attention.

David
No, you can't have it!