QuantumDB

Access, manage and query SQL relational database and servers access using standard JDBC drivers.

Download QuantumDB 3.0.6 for EasyEclipse 1.2.2:

(7.6MB)  (7.9MB)  (7.6MB)

Download QuantumDB 3.0.7 for EasyEclipse 1.3:

(7.6MB)  (7.8MB)  (7.6MB)

QuantumDB is a simple but powerful database access plugin for Eclipse. QuantumDB allows you to:

• Connect to databases using standard JDBC drivers,
• Review schemas, tables, views and sequences,
• Look up column, index and foreign key information,
• Issue ad-hoc queries or other SQL statements against the database,
• Manage, edit, and work with SQL files (*.sql),
• Issue updates, deletes, and inserts using simple, easy-to-use wizards.

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.

QuantumDB 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 with QuantumDB, you should open a few views used for data manipulation (using Window > Show view > Others...):

• The Database Bookmarks view let you define connections and connect to databases, using the New Bookmark... button on the upper right. Defining a new bookmark is straighforward, and connecting is done by right-clicking on the bookmark and selecting Connect.
• The Quantum SQL Queries View is a SQL scratchpad: write your SQL statements in this view, and execute them by pushing the "Execute" button
• Results of SELECT statements appear in the Quantum Table View.
• QuantumDB alson includes a BeanShell view, a scratchpad to write and execute BeanShell scripts

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. 
  - Windows > show view > others , select "QuantumDB > Database Bookmarks", "QuantumDB > Quantum SQL Queries View" and "QuantumDB > Quantum Table View", OK 
  - right-click in view "Database Bookmarks", select "New Bookmark", click "Add Driver", "add External Jar", locate the "hsqldb/lib/hsqldb.jar" file from the HSQLDb installation, OK
  - push "Browse" for "Class Name", there should be only one: "org.hsqldb.jdbc.jdbcDriver", Ok, Finish
  - push "Next", enter the values:
          Userid: sa
          Password empty
          JDBC URL: jdbc:hsqldb:hsql://localhost
  - push Next, enter name "MyHsqlDB", Finish
  - in "Database Bookmarks", right-click on "MyHsqlDB", select "Connect"
          
          

• Passing:

  Then:
          - created table by pasting SQL into the "Quantum SQL Queries View", ONE BY ONE, and executing it (still HSQLDB, profile "Generic DB"):
          create table x (a varchar(255), b int)
          insert into x values (\'aaa\', 1)
          insert into x values (\'bbb\', 2)
          - then paste this SQL in the "Quantum SQL Queries View":
  select * from x
  - view the results in the "Quantum Table View": two lines.
          

Useful links

• QuantumDB home
• Screenshots
• Project site

Changelog

Changes in EasyEclipse 1.3.1:

• Upgraded to QuantumDB 3.0.7.

Changes in EasyEclipse 1.2.2:

• Upgraded to QuantumDB 3.0.5.
• Upgraded to QuantumDB 3.0.6.

Changes in EasyEclipse 1.2.1:

• Upgraded to QuantumDB 3.0.2.
• Upgraded to QuantumDB 3.0.3.

Changes in EasyEclipse 1.2.0:

• Changed composition: Added missing dependency on Eclipse tools.

Changes in EasyEclipse 1.0.0:

• Initial release (with QuantumDB 3.0.1).

Credits and License

Credits: Julen Parra

Copyright (c) 2000-2006 Quantum DB developers. All rights reserved.

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

        The files dbunit-2.1.jar and dbunit-2.1-src.zip are under the LGPL (Lesser General Public License). The text of that license is to be found in the file LGPL.txt, in this distribution. The source of the dbunit library is in the file dbunit-2.1-src.zip . More info about the dbunit library is in http://sourceforge.net/projects/dbunit