Skip to main content

Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.

Jump to: navigation, search

How to create a connection to Derby using DTP

Revision as of 10:34, 15 May 2007 by Naci.dai.eteration.com (Talk | contribs) (New page: == Creating a Database Connection to Apache Derby using WTP 2.0 == WTP 2.0 uses [http://www.eclipse.org/dtp Eclipse Data Tools Platform] for database and SQL language support. In order t...)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Creating a Database Connection to Apache Derby using WTP 2.0

WTP 2.0 uses Eclipse Data Tools Platform for database and SQL language support. In order to use DTP for database development, you will need to create a connection to a database using its tools. This simple tutorial outlines how you can do that for Apache Derby, a 100% Java database. We will assume that Apache Derby is installed and that it will be started in the server (networked) mode.

  • Step 1 - Switch to Database Development Perspective. Go to Window>Open Perspective and choose Database Development.

File:DatabaseDevelopmentPerspective.png

  • Step 2 - In the Data Source Explorer select Databases, choose New from the menu to create a New Connection Profile and choose 'SQL Model-JDBC Connection' from the list. Click Next to enter a name for the connection profile, name it 'HelloWorld Derby Connection'.

NewConnectionProfile.png

Back to the top