Eclipse Community Forums: DTP » Using DTP with PostgreSQL?

Help

Home

Home » Eclipse Projects » DTP » Using DTP with PostgreSQL?

Show: Today's Messages :: Show Polls :: Message Navigator

Using DTP with PostgreSQL? [message #18728]

Sun, 02 July 2006 06:48

Joost Kraaijeveld

Messages: 273
Registered: July 2009

Senior Member

Hi,

Is there any experience with DTP with PostgreSQL?

I tried to make connection using a generic JDBC driver which partially
succeeded. It showed some of the tablespaces , some of the tables but
never all of them. Clicking on things is resulted in CPU usage of 100%
and exceptions.

I really would like using a database development tool integrated in
Eclipse so any advise on how to get DTP working with PostgreSQL would be
appreciated.

TIA

Joost

Cheers,

Joost

Report message to a moderator

Re: Using DTP with PostgreSQL? [message #18778 is a reply to message #18728]

Mon, 03 July 2006 00:12

Noud deBrouwer

Messages: 18
Registered: July 2009

Junior Member

Joost Kraaijeveld wrote:
> Hi,
>
> Is there any experience with DTP with PostgreSQL?

yes..besides i'm able to use Derby, PostgreSQL does work correct as
well..for me..
ontop my http://pkgsrc-group.sourceforge.net NetBSD-Eclipse distro.

> I tried to make connection using a generic JDBC driver which partially
> succeeded. It showed some of the tablespaces , some of the tables but
> never all of them. Clicking on things is resulted in CPU usage of 100%
> and exceptions.
>
> I really would like using a database development tool integrated in
> Eclipse so any advise on how to get DTP working with PostgreSQL would be
> appreciated.

i've got a stable build environment, and can supply you w/ copy
to fullfill your needs..
> TIA
>
> Joost

--Noud

Report message to a moderator

Re: Using DTP with PostgreSQL? [message #19740 is a reply to message #18778]

Mon, 24 July 2006 23:17

Der Ping Chou

Messages: 36
Registered: July 2009

Member

This is a multipart message in MIME format.
--=_alternative 007FE6DA882571B5_=
Content-Type: text/plain; charset="US-ASCII"

The vendor doc for PostgreSQL might not have the complete data type
support on the version of PostgreSQL that you are connecting to. If this
is the case, you can contribute to
org.eclipse.datatools.connectivity.dbdefinition.genericJDBC_ 0.9.0.200605101\runtime\vendors\Generic
JDBC_1.0\Generic JDBC_1.0.xmi.

There is a widely discussed design issue, that "Generic JDBC database" is
used to connect to a database with minimum effort, however, in order to
support all data type for a specific database, this would call for a
specialized vendor, see following tutorial for details:

http://www.eclipse.org/datatools/project_modelbase/modelbase _doc/DTP%20Modelbase%20White%20paper.htm

Hope this help.

Der Ping

--=_alternative 007FE6DA882571B5_=
Content-Type: text/html; charset="US-ASCII"

 The vendor doc for PostgreSQL might
not have the complete data type support on the version of PostgreSQL that
you are connecting to. If this is the case, you can contribute to org.eclipse.datatools.connectivity.dbdefinition.genericJDBC_ 0.9.0.200605101\runtime\vendors\Generic
JDBC_1.0\Generic JDBC_1.0.xmi.
 
 There is a widely discussed design issue,
that "Generic JDBC database" is used to connect to a database
with minimum effort, however, in order to support all data type for a specific
database, this would call for a specialized vendor, see following tutorial
for details:
 
 http://www.eclipse.org/datatools/project_modelbase/modelbase _doc/DTP%20Modelbase%20White%20paper.htm
 
 Hope this help.
 
 Der Ping
 
--=_alternative 007FE6DA882571B5_=--

Report message to a moderator