Eclipse

 
 
The Eclipse Workbench is an open source platform, designed by IBM and released to the open source community. It is an open, portable, universal tooling platform that provides frameworks, services and tools for building tools.

In essence the workbench provides the tool infrastructure. With this infrastructure in place, the tool builders are able to focus on the actual building of their tools. The workbench has been designed for maximum flexibility to support the development of tools for new technologies that may merge in the future.

Industry leaders Borland, IBM, Merchant, QNX Software Systems, Rational Software, RedHat, SuSE, TogetherSoft, and WebGain formed the initial eclipse.org board of directors and began work on the Eclipse open source project.

More information about The Eclipse Workbench can be found at:
http://www.eclipse.org

Eclipse FAQ can be found at:
http://wiki.eclipse.org/index.php/Eclipse_FAQs

The latest Eclipse version can be downloaded from: http://www.eclipse.org/downloads/

There are hundreds of plugins which you can add to Eclipse, for example plugins for testing, code management, uml, xml, etc. The Eclipse plugins can be found at: http://www.eclipseplugincentral.com/







Installing QuantumDB 3.3.0.2 on Eclipse 3.4 (Ganymede)



Information
QuantumDB is a simple but powerful database access plug-in for the Eclipse Development Platform.
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
More information about QuantumDB can be found at:
http://quantum.sourceforge.net/

Operating system used
Windows Vista Home Premium SP 1

Software prerequisites
Eclipse 3.4 (Ganymede)
MySQL Connector/J 5.1
MySQL 5.0

Procedure
  1. Start Eclipse.

  2. Select Help > Software Updates > Select tab "Available Software" > Click button "Add Site"

    Enter URL: http://quantum.sourceforge.net/update-site and press OK button.

    Install QuantumDB step 1

  3. Select all QuantumDB software and click Install button.

    Install QuantumDB step 2

  4. Review and confirm that the checked items will be installed and click Next button.

    Install QuantumDB step 3

  5. Review licenses and click Finish button.

    Install QuantumDB step 4

  6. Restart Eclipse.

  7. Select menu: Window | Open Perspective | Other...
    Select QuantumDB and press OK button.

    Open Perspective



  8. Right click in the "Database Bookmarks" window and select "New Bookmark..."

    Select New Bookmark

  9. Press the Add driver button.

    Select New Bookmark

  10. Provide the driver information:

    • Press "Add External Jar..." and locate your JDBC driver.
      In this example the MySQL Connector/J 5.1.7 driver is used.
      See also quick guide How to use JDBC.

    • Press button "Browse..." and select Class name "com.mysql.jdbc.Driver".

    • Select type: MySQL and press Finish button.

    JDBC Driver

  11. Select the MySQL driver type and press Next button.

    Select MySQL driver type

  12. Enter your connection details and press Next button.

    Enter connection details

  13. Enter a bookmark name and press Next button.

    Enter a bookmark name

  14. Select the schema to be displayed and press Finish button.

    Select schema

  15. Right click your database bookmark and select Connect.

    Connect

  16. The database content is displayed.

    Show database