EasyEclipse | Plugins | Eclipse Database tools

Eclipse Database tools

Access, manage and query SQL relational databases and servers - Removed since release 1.3.0.

Download Eclipse Database tools 1.5.4 for EasyEclipse 1.2.2:

This plugin is not released anymore in EasyEclipse 1.3. It is replaced by the Eclipse Data Tools plugin.

This subset of the Eclipse web tools provides advanced support for managing connections to database and database servers, edit and execute SQL queries, browse database tables. It is more powerfull than QuantumDB, but not as mature.

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 plugins Eclipse Web tools editors and 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.

The Eclipse Database tools must be used in conjunction with a RDBMS such as MySQL, Oracle, Sybase, HSQLDB. You need to be have network access to the RDBMS, and have the needed JDBC driver (Java JAR file).

To start using the Eclipse Database tools, you must then:

Open the "Database Explorer" view by selecting the menu "Window > Views > Others..." and choosing "Data > Database Explorer".
You can then create new connection and connect by right-clicking on the "Connections" tree item, and select the "New Connection..." menu.
Once connected, you can right-click on the connection and select "Open SQL Scrapbook". This will let you create a new file (in an existing project) where you can write and run SQL statements
You can also explore the different right-clicks on the tree items of your connection, that let you execute different operations on your database

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. 
        The JDBC library is in the lib folder.
        
        - follow the "getting started". For connection information, put
        
        org.hsqldb.jdbcDriver
        jdbc:hsqldb:hsql://localhost
        user: sa
        password empty.

Failing:

Then:
        - create an empty project
        - right-click on the database connection and select "open SQL scrapbook". Give it a name and click Finish.
        - In the created scrapbook, paste:
        create table x (a varchar(255), b int);
        insert into x values (\'aaa\', 1);
        insert into x values (\'bbb\', 2);
        - Right-click on the view and select "Run SQL". It opens the "Data Output" view and show the results.
        - In the scrapbook, paste:
        select * from x;
        - Right-click on the view and select "Run SQL". It opens the "Data Output" view and show the data inserted
        
        - unable to SELECT data from the table created