Open Source RDBMS - Seamless, Scalable, Stable and Free

English | Login |Register

Using CUBRID in AquaDataStudio

This document describes how to connect Aqua Data Studio by using JDBC to help users use CUBRID more conveniently. Aqua Data Studio is a database query tool with user-friendly features.

Applicable System

This document is applicable to the following systems.

CUBRID 2008 or higher

JDK or JRE version 1.5 or higher

Installing Aqua Data Studio

How to Install

First, download "Aqua Data Studio v8.0" at http://www.aquafold.com/downloads.html. (For Windows users, it is recommended to install a file packaged with Windows Installer.)

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 the CUBRID JDBC Driver

To install the CUBRID JDBC driver, download and install CUBRID at www.CUBRID.org.

This document does not cover how to install CUBRID; see the CUBRID Installation Guide.

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

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] a [Program] a [Aqua Data Studio] and then run the Aqua Data Studio.

image007.gif

If you have a license, register your company name and license key. If not, click [Evaluation] to use it as a 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 a 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




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: