Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

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

Using CUBRID in AquaDataStudio

Preface: This blog is a repost of "Using CUBRID in AquaDataStudio" tutorial form CUBRID Community site. Aqua Data Studio is a database query tool with user-friendly features. This blog will describe how to use Aqua Data Studio to connect to CUBRID through JDBC Driver. The intention of this tutorial is to let users use their preferable and convenient means of connecting to CUBRID.

Table of Contents

System Requirements

The following applications are required to be installed:

  • CUBRID 2008 or higher
  • JDK or JRE version 1.5 or higher

Installing Aqua Data Studio

How to Install

First, download the latest version of Aqua Data Studio application from Aqua Data Studio Downloads page. In this tutorial we will be illustrating the use of Aqua Data Studio version 8.0.

Run the downloaded installation file.


When the Wizard screen appears, click [Next].


When the License Agreement screen appears, select [I accept the terms in the license agreement] and click [Next].


If you want to use a different directory for installation, change the path by selecting the [Change] button and click [Next] to continue to the next step.


When the installation settings screen appears, check whether the settings are correct and click the [Install] button.


Wait until the installation is complete. When the installation is complete, the [Next] button is activated. Click this button to continue to the next step.

On Windows Vista, the UAC elevation dialog may appear for the installation in administrator mode.


When the installation is complete, click the [Finish] button to exit the setup program.

Installing CUBRID JDBC Driver

Installing CUBRID DBMS will automatically install CUBRID JDBC Driver. So, download CUBRID from CUBRID Downloads page and install it. This document will not cover CUBRID installation process. If you need some help, refer to CUBRID Installation Guide which is available for your particular system.

If CUBRID is installed with the default settings, you can see the JDBC driver called cubrid_jdbc.jar installed in C:CUBRIDjdbc.

In order to use CUBRID in Aqua Data Studio, make sure that you know the CUBRID JDBC path.

Configuring Aqua Data Studio and Interworking with CUBRID


Go to [Start] à [Program] à [Aqua Data Studio] and then run the Aqua Data Studio.


If you have an Aqua Data Studio license, register your copy entering your company name and license key. If not, click [Evaluation] to use it for free during the 14-day trial.

If you are an open source developer, see the following link to get a free license key.

Interworking with CUBRID


If you start Aqua Data Studio for the first time, the above dialog box appears. Click [Yes]. Then you should see the following server registration screen.

Even when you click [No] by accident, click Server à Server Registration, then you should see the server registration screen.


  • To interwork with CUBRID, select Generic – JDBC in the left menu.
  • And then, type information in the right side.
  • Name: Type an appropriate name. (e.g. CUBRID-demodb)
  • Type: Type a value you want.
  • Tab Color: Type a value you want.
  • Tab Title Format: Use the default value. {0}@{1}
  • Login Name: An account to be connected to the database
  • Password: The password of an account to be connected to the database
  • URL: The format is the same as JDBC connection. (e.g. jdbc:CUBRID:Connection Server IP:Broker Port:database_name:::)
  • For example, jdbc:CUBRID:
  • Driver: cubrid.jdbc.driver.CUBRIDDriver
  • Driver Location: Type the installation path of a driver. C:CUBRIDjdbccubrid_jdbc.jar
  • The screen where all the fields are filled is shown below:


If you type all the information, click [OK] to save the environment.

Connecting to a Database

In the popup window which appears when you right-click the registered server, click [Connect].


Using the Query Analyzer

You can execute a query by using the Query Analyzer.

Running the Query Analyzer

In the popup window which appears when you right-click the registered server, click [Query Analyzer].


When the Query Analyzer is executed, the following screen appears.


Executing Queries

Note that the auto commit mode is enabled by default when executing queries.

The auto commit mode can be toggled with Ctrl+shift+A.

Enter Select * from db_class; query, and click the image014.jpg button to execute it.


Creating a Query Analyzer Window

In the popup window which appears when you right-click the registered server, click [Query Analyzer].


If you click the [Query Analyzer Window] button, the following new window appears.


comments powered by Disqus