Book a Demo

Author Topic: EA Java Interface to General DDL for Oracle DB  (Read 7163 times)

chintan230

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
EA Java Interface to General DDL for Oracle DB
« on: June 04, 2007, 06:42:43 am »
Hello All,

I have created data model using EA. I am able to generate DDL using (Project -> Database Engineering -> Generate Package DDL).

Questions:
1) So far only documentation I found for Java-API to EA is:
http://www.sparxsystems.com.au/EAUserGuide/index.html?setup.htm, Is there any documentation available for all Class/methods?

2) I want to generate Package DDL from Java interface. Can anybody let me know what steps I should execute or point me out the documentation?


I really appreciate your help.

Thanks,
Chintan


Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: EA Java Interface to General DDL for Oracle DB
« Reply #1 on: June 04, 2007, 03:27:43 pm »
1) See the documentation for the rest of the automation interface.  (http://www.sparxsystems.com/EAUserGuide/reference.htm)

2) Not sure that there is a function.  I would have expected it to be on the Project Interface (http://www.sparxsystems.com/EAUserGuide/project_2.htm) but I can't find it there.

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: EA Java Interface to General DDL for Oracle DB
« Reply #2 on: June 04, 2007, 04:32:00 pm »
AFAIK the Java interface uses a third-party Java library that wraps COM. A usable analogy - not necessarily a perfect or even valid one I know - is to think of it as an emulator for the COM API described in the EA documentation.

That said, look in the documentation for the functions you want. I believe Simon is correct, but...

There doesn't seem to be anything!

This is true for both EA 6.5 and the 7.0 beta.

Simon (or any of the other Sparxians), this is one that really needs to be addressed. Any chance you can internally get this into the hopper for a later 7.0 beta?

David
No, you can't have it!

mikewhit

  • EA User
  • **
  • Posts: 608
  • Karma: +0/-0
  • Accessing ....
    • View Profile
Re: EA Java Interface to General DDL for Oracle DB
« Reply #3 on: June 04, 2007, 10:46:42 pm »
The Perl API works well - worth a look unless you are tied to Java. A few examples in this forum.

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: EA Java Interface to General DDL for Oracle DB
« Reply #4 on: June 05, 2007, 02:07:26 am »
Quite true Mike,

Still, regardless of the automation language, Chintan's second point remains to be addressed.

Like Simon, I keep thinking there was something that handles this in the Project interface. But it just doesn't seem to be there. Perhaps it is one of those things that you see in the main product, just seems like it should be in the API, and you don't realize is isn't until you need to make the call.

David
No, you can't have it!

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8626
  • Karma: +259/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: EA Java Interface to General DDL for Oracle DB
« Reply #5 on: June 05, 2007, 02:43:06 am »
Quote
Quite true Mike,

Still, regardless of the automation language, Chintan's second point remains to be addressed.

Like Simon, I keep thinking there was something that handles this in the Project interface. But it just doesn't seem to be there. Perhaps it is one of those things that you see in the main product, just seems like it should be in the API, and you don't realize is isn't until you need to make the call.

David
Shock, horror!  You mean the main product doesn't just call it's own APIs?  ;)

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

mikewhit

  • EA User
  • **
  • Posts: 608
  • Karma: +0/-0
  • Accessing ....
    • View Profile
Re: EA Java Interface to General DDL for Oracle DB
« Reply #6 on: June 05, 2007, 03:50:34 am »
Purists might say the main product should only call its own API.

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: EA Java Interface to General DDL for Oracle DB
« Reply #7 on: June 05, 2007, 04:33:23 am »
And it probably does.

The problem is that it does not seem inclined to allow us poor souls to do do so as well.
No, you can't have it!

Paolo F Cantoni

  • EA Guru
  • *****
  • Posts: 8626
  • Karma: +259/-129
  • Inconsistently correct systems DON'T EXIST!
    • View Profile
Re: EA Java Interface to General DDL for Oracle DB
« Reply #8 on: June 05, 2007, 05:11:18 am »
Quote
Purists might say the main product should only call its own API.
(To quote from "House of Cards")

"You might well think that... I couldn't possibly say that..." ;D

Paolo
Inconsistently correct systems DON'T EXIST!
... Therefore, aim for consistency; in the expectation of achieving correctness....
-Semantica-
Helsinki Principle Rules!

chintan230

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
  • I love YaBB 1G - SP1!
    • View Profile
Re: EA Java Interface to General DDL for Oracle DB
« Reply #9 on: June 05, 2007, 09:23:42 am »
hello All,
Thanks for all your help. Now I have lot of information for question 1, which is Java interface to EA.

I am still not clear for using Automation Generation of DDL from EA. I am pretty open to all other languages (perl, C#, etc.). All I want is to automate my project with ANT/Cruise Control for Quality Check.

Let me know if there existing anything so that I can automatically generate DDL from EA.

Regards,
Chintan