Using SQuirreL Universal SQL

To use the SQuirreL Universal SQL client with NuoDB, you’ll need to install the NuoDB JDBC driver. If not already installed, download the NuoDB JDBC driver by following the instructions provided on page, NuoDB Drivers Available at Other Public Sites. In the example below, we’ll assume it’s nuodb-jdbc.jar and installed in the NUODB_HOME/jar directory.

  1. Download and configure SQuirreL:

    1. Download SQuirreL from one of the recommended links provided on the SQuirreL website.

    2. Install SQuirreL by running the following command: java -jar downloaded_install_file

    3. Choose the Base, Standard and Optional Plugin – Data Import packs.

  2. Run SQuirreL using the script that the installer created (typically as a menu or desktop shortcut).

  3. Click the Drivers tab, add a new driver, and configure with the following settings:

Name

NuoDB

Example URL

jdbc:com.nuodb://host/dbname

Website URL

http://www.nuodb.com

Extra Class Path

NUODB_HOME/jar/nuodb-jdbc.jar

Class Name

com.nuodb.jdbc.Driver

  1. Create an alias for NuoDB by clicking the Aliases tab and then clicking Create New Alias.

  2. Fill out the Add New Alias dialog. Select Auto logon and Connect at Startup
    The following settings are specific to NuoDB:

Name

NuoDB

Driver

NuoDB

URL

jdbc.com.nuodb://host:port/dbname