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

image001.gif

When the Wizard screen appears, click [Next].

image002.gif

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

image003.gif

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.

image004.jpg

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

image005.jpg

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.

image006.jpg

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

Running

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

image007.gif

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.

http://www.aquafold.com/opensourcedeveloper-qual.html

Interworking with CUBRID

image008.gif

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.

image009.gif

  • 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:127.0.0.1:33000:demodb:::
  • 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:

image010.gif

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

image011.gif

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

image012.gif

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

image013.gif

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.

image015.gif

Creating a Query Analyzer Window

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

image016.gif

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

image017.gif



comments powered by Disqus