CUBRID Through QuantumDB Eclipse Plugin
Table of Contents
If you are familiar with Eclipse and prefer using it as an interface for various projects, there is an Eclipse Plugin called QuantumDB that you can use to connect to and administer the CUBRID Database Server. Below you will find very detailed and step by step tutorial, which will lead you trough the installation process.
Since QuantumDB connects to the database through CUBRID JDBC Driver, you can have any version of CUBRID Database Server installed on your machine. In this tutorial we will be using the latest, at the point of writing, version of CUBRID 2.2 64-bit. If there is a newer version available, you are highly recommended to install it.
All applications including CUBRID, QuantumDB, and Eclipse are available for both Linux and Windows, this tutorial will serve the universal needs. In this case our system is Windows 7 64-bit.
First, let's make sure we have the necessary installation files. There are five items we have to install. Some items might have already been installed.
- Since CUBRID is the reason of this topic, make sure you have downloaded the latest version. There is an Easy Installation Guide for it.
- We will also need Eclipse. You can download the latest version from Eclipse Download page. There are many different version of Eclipse optimized for different purposes. Choose the one you think applies to you best. If you are not sure which one suits you better, you may download Eclipse Classic. In this version we will be using Eclipse Classic 3.5.2.
- GEF (Graphical Editor Framework) is another tool we have to download. GEF allows developers to take an existing application model and quickly create a rich graphical editor. QuantumDB Eclipse plugin needs it. Here we have GEF 3.5.2 All-In-One SDK installed.
- Finally, we need QuantumDB plugin itself. Download the latest version. Currently we used QuantumDB 3.3.9.
- Make sure you correctly installed CUBRID Database Server. If you need help with CUBRID installation, refer to CUBRID Installation Guide.
- In order to meet CUBRID requirements, we have to make sure the JAVA bin directory is in our Environment PATH and CUBRID JDBC directory is in CLASSPATH. You may do so by:
- Right click on My Computer and select
Properties. You will see the following picture.
- On the left panel choose
Advanced system settings. You will see the picture below.
- In the
System Properties press Environment Variables button. You will see:
- Double click on Path and add your JAVA bin directory path (in my case it is c:Program FilesJavajre6bin), double click on CLASSPATH and add a path to CUBRID JDBC directory (in my case it is c:CUBRIDjdbc). You are done! All paths are set.
- Open the Command line (Windows+R shortcut, enter cmd and press enter).
- Type cubrid service start to start the CUBRID Service. You should see the following output. If not, it
means CUBRID is installed incorrectly. Try to reinstall it.
- Start demodb sample database. Type cubrid server start demodb. If demodb database has
been successfully started, you will see the following
picture. If not, make sure you have installed demodb
sample database when you were installing CUBRID DBMS.
There is nothing easier than installing Eclipse. Just unpack the downloaded zip file somewhere like C:/Program Files/Eclipse or C:/Eclipse. For your convenience you may also place a shortcut to your desktop. If you need help with Eclipse installation, refer to Eclipse Installation Guide.
After you download GEF (Graphical Editor Framework) zipped file, extract it some temporary place, you will delete it when you finish this tutorial. When you unzip, you will have one directory named as eclipse, which has two files and two folders. You have to copy these two folders (features and plugins) to your Eclipse directory where you unzipped Eclipse. In fact Eclipse folder will already be containing these two folders. Just you have to override them. DO NOT REPLACE these folder, just copy over them. If you have any problems, post them to GEF Forum.
This step is identical to that of GEF Installation above. Just unpack it, copy its two same folders to Eclipse folder. If you have some problems you can always refer to QuantumDB General Forum. The community will help you quickly. You might want to read particularly this forum topic: Does QuantumDB officially support CUBRID?
Now lunch Eclipse. When you lunch it, you will see a window in Java default perspective. If you want to know what Perspective is in Eclipse, read Eclipse Plugin Perspectives. In our case we have to set the Perspective to QuantumDB Perspective. Follow the steps below.
- In Eclipse select Window->Open Perspective->Other as shown in the
- Once you click Other you will see a small window shown
below. You have to choose QuantumDB from the provided
list of perspectives like in the picture below, and hit
- Your Eclipse Interface should immediately change to
different look like in the picture below.
- On the left side you will see a side panel called
Database Bookmarks. You have to click on
New Bookmark button on the panel header as
- A new small window will pop up. See the image below.
You have to click on
Add driver button.
- In the new window, click on
Add External Jar button.
- In the new Explorer Window locate CUBRID JDBC Driver
(in my case it is
- Now in the last opened window (
New JDBC Driver window) you see CUBRID Driver jar.
Select it and click
Browse button. Select
cubrid.jdbc.driver.CUBRIDDriver and press OK
button. You will see the following.
Finish button. It will return to the first
New Bookmark window. Among the listed driver
cubrid.jdbc.driver.CUBRIDDriver. and press
Next button. You will be prompted to enter
JDBC URL. Leave first two fields empty and enter
jdbc:cubrid:localhost:33000:demodb::: in the
JDBC URL field. Look at the picture below.
- Click Next. Give this new bookmark a name like CUBRID or something related to CUBRID. Then press Finish button. You are DONE! Double click the CUBRID Bookmark. Select the necessary Table. Click around and you will see lots of features pertaining to database and table manipulation.