Skip to content

SQuirrel SQL Client Quick Guide for Altibase#

Overview#

This document describes how to install the SQuirrel SQL Client and integrate it with Altibase through Altibase JDBC.

The test environment for this document is as follows.

  • Altibase: Altibase 7.3
  • OS: CentOS Linux release 7.5.1804
  • SQuirrel: 5.1.0 standard

Info

For errors and improvements related to this document, please contact the technical support portal or technical support center.

Info

This document is provided for informational purposes only and is subject to change without prior notice. It may contain errors, and Altibase makes no express or implied warranties of any kind, including but not limited to warranties of merchantability or fitness for a particular purpose.

The development, release, and timing of any features or functionality described for Altibase products in this document are at the sole discretion of Altibase.

Altibase may hold patents, trademarks, copyrights, or other intellectual property rights related to the contents of this document.

SQuirrel SQL Client Installation#

This chapter describes how to install the SQuirrel SQL Client. This document was prepared in a Windows environment by downloading "Install jar of SQuirreL 5.1.0 for Windows/Linux/others".

Installation Procedure#

  1. Download the SQuirrel SQL Client suitable for you from the link below.
    http://squirrel-sql.sourceforge.net/#installation
  2. Double-click the downloaded "squirrel-sql-5.1.0-standard.jar" to start the installation.

Altibase JDBC Driver Registration#

You must register Altibase JDBC to use the SQuirrel SQL Client.

Registration Method#

  1. Double-click "squirrel-sql.jar" in the directory where the SQuirrel SQL Client is installed to launch the program.

  2. Click Drivers -> Create a New Driver to register the Altibase JDBC driver.
    If the Drivers menu is disabled, click Windows -> View Drivers to enable it.

  3. Enter the following in the Driver field of the Add Driver window.

    Name: Altibase
    Example URL:jdbc:Altibase://:/
    

  4. Click the "Add" button on the JDBC Driver Class Path tab at the bottom, and select the Altibase JDBC driver file to use for the connection.

  5. After selecting the file, click the "List Drivers" button and verify that "Altibase.jdbc.driver.AltibaseDriver" has been added to the Class Name combo box at the bottom.

  6. Click the "OK" button to complete the Altibase JDBC driver registration.

Integration with Altibase#

The procedure for integrating Altibase with the SQuirrel SQL Client is as follows.

Database Connection Information Registration#

  1. Click Aliases -> New Alias in the main menu to register the database connection information. If the Aliases menu is disabled, click Windows -> View Aliases to enable it.
  2. Enter the following information

    Name: Database connection name
    Driver: Select the previously registered Altibase.
    URL: Enter the host, port, and database name to connect to.
    User Name: Database user name used for connection
    Password: Password of the database user used for connection
    
  3. After entering the information, click the "Test" button at the bottom to verify that the entered connection information is correct.

  4. Click the "OK" button to complete the Alias registration.

Using the Database#

  1. Click Aliases -> Connect in the main menu to open the connection window.
  2. Click the "Connect" button to connect to the registered database.

Object#

After a successful connection, a window with two tabs opens as shown below. The Object window is selected by default, and you can view the objects and detailed information in the connected database.

SQL#

Select SQL from the two tabs at the top to enter and execute queries.