Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » DTP » Reverse Engineering for PostgreSQL
Reverse Engineering for PostgreSQL [message #39005] Fri, 23 November 2007 16:00 Go to next message
Eclipse User
Originally posted by: mcervera.integranova.com

Hello.

I am working on reverse engineering with a PostgreSQL Database and I've
run into a couple of problems that have prevented me from achieving the
expected result.

I've connected to the database successfully and managed to get an object
of the metaclass "database" so all I have to do is add it to a resource
and save it to get the XML code that allows me to visualize the
resulting tree model. Here are my problems:

- I get Index elements instead of Unique elements when I define a unique
constraint in my postgres database.

- The property "Referenced Members" of the Foreign Keys is not set.

- I am not getting the CheckConstraint elements when I add a constraint
in my postgres database.

Are these problems bugs? What can I do to solve them? Any help would be
really appreciated.

Thanks :).

Mario
Re: Reverse Engineering for PostgreSQL [message #39432 is a reply to message #39005] Thu, 29 November 2007 19:13 Go to previous message
Larry Dunnell is currently offline Larry Dunnell
Messages: 19
Registered: July 2009
Junior Member
Mario,

These problems are most likely caused by a lack of PostgreSQL-specific
support.
Currently, the reverse engineering is relying on the generic support
which relies on the JDBC metadata. Some of the other databases such as
Derby provide custom support to provide richer reverse engineering. DTP
relies on community contributions for PostgreSQL support.

If you are interested contributing in this area, the first area to look at
is the generic support in the org.eclipse.datatools.connectivity.sqm.core
plug-in to see if the problem cannot be solved there. Otherwise, the
Derby plug-ins provide a good example of providing database specific
support.

Larry
Re: Reverse Engineering for PostgreSQL [message #588826 is a reply to message #39005] Thu, 29 November 2007 19:13 Go to previous message
Larry Dunnell is currently offline Larry Dunnell
Messages: 19
Registered: July 2009
Junior Member
Mario,

These problems are most likely caused by a lack of PostgreSQL-specific
support.
Currently, the reverse engineering is relying on the generic support
which relies on the JDBC metadata. Some of the other databases such as
Derby provide custom support to provide richer reverse engineering. DTP
relies on community contributions for PostgreSQL support.

If you are interested contributing in this area, the first area to look at
is the generic support in the org.eclipse.datatools.connectivity.sqm.core
plug-in to see if the problem cannot be solved there. Otherwise, the
Derby plug-ins provide a good example of providing database specific
support.

Larry
Previous Topic:Eclipse Data Tools
Next Topic:"Unsupported" folder/profiles, NullPointerException connecting ...
Goto Forum:
  


Current Time: Fri Oct 31 23:13:05 GMT 2014

Powered by FUDForum. Page generated in 0.01640 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software