Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Current Events
Join our developers event to win one of the valuable prizes!
posted 4 years ago
viewed 5436 times
Share this article

CUBRID Through QuantumDB Eclipse Plugin

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 CUBRID Database Server. Below you will find very detailed and step by step tutorial, which will lead you trough the installation process.

Preface

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 2008 R2.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.

Prerequisites

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.

  1. Since CUBRID is the reason of this topic, make sure you have downloaded the latest version.
  2. 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.
  3. 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 needs it. Here we have GEF 3.5.2 All-In-One SDK installed.
  4. Finally, we need QuantumDB plugin itself. Download the latest version. Currently we used QuantumDB 3.3.9.
Installation

CUBRID Installation

  1. Make sure you correctly installed CUBRID Database Server. If you need help with CUBRID installation, refer to CUBRID Installation Guide.
  2. In order to meet CUBRID requirements, we have to update the OS (Windows) Environment Variables. We have to add to the existing PATH a path to JAVA bin directory. Also we need to add to the existing CLASSPATH a path to CUBRID JDBC directory. You may do so by:

    • Right click on My Computer and select Properties. You will see the following picture.

      my computer properties.PNG

    • On the left panel choose Advanced system settings. You will see the picture below.

      system properties.png

    • In the System Properties press Environment Variables button. You will see the

      environment variables.png

    • 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.
  3. Start CUBRID Service and demodb sample database.

    • Open the Commend line (Windows+R shortcut, enter cmd and press enter).
    • Type cubrid service start. This is necessary to make sure CUBRID Service is started. You should see the following image. If not, it means installed CUBRID incorrectly. Try to reinstall.

      command line.PNG

    • 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.

      command line demodb.PNG

Eclipse Installation

  1. 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.
GEF Installation

  1. After you download GEF 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.
QuantumDB Installation

  1. 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 toQuantumDB General Forum. The community will help you quickly. You might want to read particularly this forum topic: Does QuantumDB officially support CUBRID?
QuantumDB Configuration

Now lunch Eclipse. When you lunch it, you will see a window in Java default perspective. If you want to know what isPerspective in Eclipse, read Eclipse Plugin Perspectives. In our case we have to set the Perspective to QuantumDB Perspective. Follow the steps below.

  1. In Eclipse select Window->Open Perspective->Other as shown in the picture below.

    eclipse perspective.PNG

  2. 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 Enter.

    quantumdb perspective.png

  3. Your Eclipse Interface should immediately change to different look like in the picture below.

    eclipse quantumdb perspective.PNG

  4. 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 shown below.

    quantumdb new bookmark.PNG

  5. A new small window will pop up. See the image below. You have to click on Add driver button.

    QuantumDB add driver.png

  6. In the new window, click on Add External Jar button.

    QuantumDB add external jar.png

  7. In the new Explorer Window locate CUBRID JDBC Driver (in my case it is in c:CUBRIDjdbccubrid_jdbc.jar).

    cubrid external jar.PNG

  8. Now in the last opened window (New JDBC Driver window) you see CUBRID Driver jar. Select it and clickBrowse button. Select cubrid.jdbc.driver.CUBRIDDriver and press OK button. You will see the following.

    QuantumDB add external jar finish.png

  9. Press Finish button. It will return to the first New Bookmark window. Among the listed driver choosecubrid.jdbc.driver.CUBRIDDriver. and press Next button. You will be prompted to enter UseridPassword, andJDBC URL. Leave first two fields empty and enter jdbc:cubrid:localhost:33000:demodb::: in the JDBC URL field. Look at the picture below.

    cubrid bookmark.png

  10. Click Next. Give this new bookmark a name like CUBRID or something related to CUBRID. Then pressFinish 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.
This blog has been ported from CUBRID Through QuantumDB Eclipse Plugin article located at CUBRID Community web site.



comments powered by Disqus