Generate Sequences without Triggers

[Rapthor]

Hello,

I am using EA 7.0 to generate a DDL Schema for Oracle 10 database tables. I want to provide every table with a sequence. On first attempt I clicked the table: Properties -> Table Detail -> Columns/Attributes -> Selected the primary key -> Column properties -> Checked "Auto number" with start 1 and increment 1.

The generated DDL schema sql-file contains TRIGGER creation together with SEQUENCE creation. The trigger counts one up on every insert. I want to turn that off. I want to have only SEQUENCEs! Unchecking the checkbox "Generate Triggers" and checking "Generate Sequences" does not help. Checking "Generate Triggers" generates SEQUENCES and TRIGGERS. Checking only "Generate Sequences" generates neither of both.

How to achieve that only SEQUENCEs are generated? Please help.

[«Midnight»]

Try searching the forum for Oracle and sequence. I think there was something about this in the last few months or so, that allowed explicit creation of sequences - outside of the context of a specific table - rather than implicitly through a primary key.

David

[mark.myers]

I think this may be a problem introduced in EA7. I have previously been generating DDL for SQL Server tables that include an IDENTITY column. In version 7 that suddenly changed to the triggers as you described. I have reported it to Sparx and I think the next build will address it.

[«Midnight»]

Hi Mark,

When was this reported? Or more importantly, for which build? Please keep us up to date on whatever you get back from Sparx.

David

[BTW, which version of Oracle were you using?]

[mark.myers]

I reported it on 3 July 2007. During subsequent correspondence with Sparx I received the following comments...

10 July: "There will be a fix for these issues in build 814."
10 July: "813 has only just been released, so it could be 2 to 4 weeks away."

I am currently using Build 812.
I am targeting SQL Server 2005 and not Oracle (I have not tried generating DDL for Oracle as I have no need to).

Regards,
Mark.

[«Midnight»]

Please let us know what happens when you update to the production release of 7.0.

David

[mark.myers]

I upgraded to Build 814 today. The problem remains however I received an email from Sparx to say that it would be fixed in Build 815.

[«Midnight»]

Thanks Mark,

I for one am awaiting 815 for a few reasons, so I'll add this to my list of anticipated tweaks.

David

[Oliver F.]

Thanks Mark,

I for one am awaiting 815 for a few reasons, so I'll add this to my list of anticipated tweaks.

David

This is a rather old topic but it seems it has not been addressed yet. I am suffering from the same issue in build 850.
So how can the TRIGGER statements be turned off? Any clues?

Oliver