Eclipse Data Tools

Access and query relational databases with SQL.

Download Eclipse Data Tools 1.0.0 for EasyEclipse 1.2.2:

(7.1MB)  (7.3MB)  (7.0MB)

Download Eclipse Data Tools 1.5.1 for EasyEclipse 1.3:

(8.0MB)  (8.1MB)  (7.9MB)

The Eclipse Data Tools lets you connect to, and execute SQL, on relational databases. Since Release 1.3.0, it replaces the Eclipse Database Tools; however, for previous releases, you may prefer to use the Eclipse Database Tools. The Quantum plugin is also available.

Note: the plugin org.eclipse.datatools.connectivity.oda.template.ui has been excluded from this release, as it has dependencies on more plugins than needed; This plugin is not needed for end-users, only for plugin developers, and should not be needed for most users.

Comments are currently disabled on this page.

Installing this plugin

This plugin is in the EasyEclipse Server Java, EasyEclipse Mobile Java, EasyEclipse for LAMP, EasyEclipse for PHP and EasyEclipse for Ruby and Rails distributions.

If you install this plugin on another EasyEclipse distribution, the dependent plugin Eclipse Java Development Tools must be present in the EasyEclipse distribution, or must be installed separately.

Getting started

Help is available for this plugin, in the Help > Help Contents menu in EasyEclipse.

You can define a database connection using the by selecting New > Other then Connection Profile > Connection Profile. You may need to provide the .jar file for the JDBC driver. Then, creating any file with the .sql extension will make it possible to run its content against the database connection. The SQL Results view will show the execution results.

Tests

(Notes that tests are only displayed if the page is served statically)

• Passing:

  - Test by connecting to a database. Best is hsqldb (from hsqdb.org). Run the server by using hte "runServer.sh" found in the "demo" folder. 
      - New -> Other, Connection Profile -> Connection Profile, next, select HSQLDB Connection Profile, next, enter name, next, push "..." button, push "Add" button, select Database -> Hypersonic -> 1.8 -> Hypersonic DB, OK, Edit, Edit Jar/Zip, locate "lib/hsqldb.jar" from your hsqldb installation, OK, OK, select driver in drop-down,
      - Leave \'Database\' with SAMPLE, put \'hsql://localhost\' as "Database Location",  username: sa, leave password empty, push Test connection, (should say: Ping) OK, OK
      - New -> Project, General -> Project, enter Project name, OK
      - New -> Other, SQL Development -> SQL File, Next, select parent folder, enter \'a.sql\' as name, select \'Connection profile name\' to name entered above, Finish
      - in file, paste "create table y (a varchar(255), b int)". Right-click in editor, select "Execute all"
      - in file, removed previous and put
  insert into x values (\'aaa\', 1);
  insert into x values (\'bbb\', 2); Right-click in editor, select "Execute all"
      - in file, removed previous and put "select * from x;" Right-click in editor, select "Execute all";
      - should show results.
  .

Useful links

• Eclipse Data Tools home

Changelog

Changes in EasyEclipse 1.3.1:

• Upgraded to Eclipse Data Tools 1.5.1.

Changes in EasyEclipse 1.3.0:

• Upgraded to Eclipse Data Tools 1.5.0.

Changes in EasyEclipse 1.2.2:

• Upgraded to Eclipse Data Tools 1.0.0.

Changes in EasyEclipse 1.2.1:

• Upgraded to Eclipse Data Tools 0.9.1.

Changes in EasyEclipse 1.2.0:

• Initial release (with Eclipse Data Tools 0.9.0): Upgraded to the official final version 0.9.0.

Credits and License

Credits: Eclipse.org

Copyright (c) Eclipse contributors and others. 2000-2007. All rights reserved.

This plugin is licensed under the Eclipse Public License 1.0 license.