2007-08-02

QuantumDB Eclipse Plugin

Today I've tried the famous QuantumDB Eclipse Plugin, It's really a powerful database management tool and supports many different databases.

To install it, open Eclipse and select from the menu "help"->"Software updates"->"Find and Install..."->"Search for new features to install"->"new remote site", then type the update URL: http://quantum.sourceforge.net/update-site, then click next...

Note: Quantum needs the GEF plugin to work, so you have to install it before installing Quantum. That plugin can be installed via an already built-in remote site: "Callisto Discovery Site".

After successful installation, I was really frustrated to figure out that the Quantum comes with only TWO connector:

  1. JDBC to ODBC bridge
  2. MS Access

If we want to use MySQL, we must get the connector jar! Now it's called MySQL Connector / J. Go to that page and download the package.

Tip: you don't need to register or sign in when you click "select a mirror", just find the gray text "No thanks, just take me to the downloads!".

Extract all things in a folder, you can find a file called like mysql-connector-java-5.0.7-bin.jar. You need to do the following to add support of MySQL driver:

  1. Go to eclipse and switch to the view "Quantum DB" by clicking the top right icon near to "Java". Add a new bookmark by right click on the left "database bookmarks" panel.
  2. Now click "Add driver", find "mysql" in the dropdown list "type", then click "add external jar", point to the file mysql-connector-java-5.0.7-bin.jar.
  3. Click the "browse" button for the class name "com.mysql.jdbc.Driver", then go on clicking many "OK" buttons.

So now do the step again and select "mysql" as connector, a dialog will be shown to let you input some infos of the mysql database you want to connect. That is it!

No comments: