Eclipse DB Toolbox

Created by: Lester Caine, Last modification: 04 Jun 2011 (00:40 BST)

Mark Rotteveel's page forms a useful starting point for adding DTP to an Eclipse installation, but is a little short on detail.

The Eclipse Data Tool Project is the integral part of SQL management, and DTP releases can be found on their update site (http://download.eclipse.org/datatools/updates). Adding this to the list of available software sites in the Eclipse software management package allows the key plug-ins to be managed. The only problem I am having with datatools is that ALL versions are being displayed rather than just the latest version, so it is a matter of finding the latest 'pair' which is currently 1.8.2

  1. Help-> Install New Software
  2. Add http://download.eclipse.org/datatools/updates to the 'Available Software Sites' it may already be listed but with a blank name field so it's worth deleting and reinstalling with a name
  3. Select
    Eclipse Data Tools Platform Enablement SDK 1.8.2
    Eclipse Data Tools Platform SDK 1.8.2
  4. Download firebird_DTP_1.0.2.201106021154.zip from Mark's site
  5. Unzip the plugins folder and copy to {}/eclipse/plugins
  6. Jaybird .jar needs to be available, and can be downloaded from the Firebird Site JDBC Page
  7. Windows->Preferences opens he setup screen
  8. Add firebird jaybird-full-2.1.6.jar to the java runtime
    Java->Installed JRE's
    Select 1.6.0->Edit->Add External JAR's and enter location of the JAR
  9. Set up Data Managment
    Data Management->Connectivity->Driver Definitions->Add
    Select Firebird JDBC Driver
    Edit JAR entry to point at the jaydird jar
    Add default connection details to Properties page.
  10. Close setup window and select Database Development perspective
  11. Set up a new link to a firebird database.

Other useful docs
Jaybird_2_1_JDBC_driver_manual.pdf
Notes on using Eclipse need to be added as well
Starting Guide for DPT
( Must read this sometime soon ... )