Messages

1

General Board / creating oracle triggers

« on: June 08, 2006, 06:13:39 am »

Hi All,

I've been trying to generate triggers (pre insert and pre update) along with my tables when I generate ddl. The problem that I've been running into is that what is being generated is syntacially incorrect. EA seems to be generating the "on tablename" before any "before insert" statement. I've not found a way to tell EA this is a "before insert" trigger.

So I developed a work around...when I name the trigger I name it "triggername before insert" or "triggername before update". When I do this, EA generates ddl code that works.

So my question is...is this the way I should be doing this? Am I missing or misusing a property of the operation?

Thanks

Dana

2

General Board / Re: stand alone oracle sequence generators

« on: June 08, 2006, 09:55:18 am »

Thanks Jamie.

3

General Board / stand alone oracle sequence generators

« on: June 02, 2006, 12:08:52 pm »

Hi All,

I'm wondering if there is a way to model oracle sequence generators that will generate the ddl required to create the sequence generators, without creating the pre insert trigger to auto-populate the column.

For my application, one service is going to create the record in the DB and then pass the PK to another app for further processing. Therefore, I want my app to know the value without having to re-query the database, so I want to select the sequence value myself.

Any suggestions are appreciated.

Thanks

Dana

4

General Board / generating check constraints

« on: November 05, 2003, 05:18:47 am »

I'm using 3.51 to model and generate ddl for an Oracle 9i databse. In the help documentation, Check constraints are mentioned but it does not describe how to add them to the class such that the proper ddl generates. In addition, EA does not appear to reverse-engineer these constraint and therefore I cannot use an existing one as an example.

Has anybody figured out if this can be done or will this be a post-generation mode I have to do on my own.

Thanks

5

General Board / Collaborative Development?

« on: October 18, 2002, 09:59:18 am »

Hello,

I've spent the last couple of days evaluating EA and as an experienced Rose user that is my basis for comparison. EA out-shines Rose in many areas with one exception (as far as I can tell). Collaborative use.

I've looked at the Save Package as XML features and the replication but I'm yet to be convinced of a usable collaborative environment.

To explain my point of view, Rose allows packages to be "contained" within a .cat file. and you can have many .cat files for a single model (.mdl) which is more or less equivalent to a .eap file from EA. Now with Rose, once the contents are in that .cat, I can set (via a version control tool) the .cat file to be read-only for all users except for the one who has checked it out. This prevents the user from unknowingly altering a file and therefore a package within the model.

By comparison, it seems to me that in EA saving a package to an xml file only creates a copy of the data. The user may continue to inadvertantly affect the contents of that package and when the .xml is re-loaded from another user, those changes will be blown away.

I'm interested in any ideas I can get on how get a better collaborative environment.

Here's what's on my plate to check next...

1. The SQL Server/MySQL capabilities in the 3.50 beta are interesting...could multiple users connect to that repository and control be through the databases locking capabilties? I cannot test this because I am not licensed and therefore cannot acces the beta. When is the beta intended to go production.

2. I've heard that the .eap can be placed on a shared  drive and that multiple users can access the file...I'm going to try this next.