Using SQL Workbench/J

This example configuration assumes you have NuoDB installed and have imported the sample "hockey" database from the Linux Bare Metal / VM.

If you have your own NuoDB database set-up, you can substitute the host/database in the URL field below and specify the corresponding username and password credentials.

To use SQL Workbench/J 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.

Download and unzip SQL Workbench/J from: http://www.sql-workbench.net

Refer to the Manual on the website on how to initially start SQL Workbench/J:

java -jar sqlworkbench.jar

and how to restart it:

chmod 755 sqlworkbench.sh; ./sqlworkbench.sh

When initially started, a "Default group", "New profile" window opens. Click Manage Drivers in the bottom left corner, select NuoDB from the list, and configure the NuoDB driver as follows, then click OK.

Name

NuoDB

Library

NUODB_HOME/jar/nuodb-jdbc.jar

Classname

com.nuodb.jdbc.Driver

Sample URL

jdbc:com.nuodb://localhost/hockey

In the "Default group" window, change "New Profile" to "NuoDB", for example, and configure as follows:

Driver

NuoDB (com.nuodb.jar.Driver)

URL

jdbc:com.nuodb://localhost/hockey

Username

dba

Password

goalie

The username and password above are for the sample "hockey" database supplied with NuoDB. If you have your own database set-up, use your own host/database in the URL, and your corresponding username and password credentials.

Click OK to start working with the database. You can browse tables, insert rows, and edit values.

For example, in the Statement tab, type the following SQL statement and click SQL, Execute All.

select * from HOCKEY.TEAMS where TEAMS.YEAR=2011;

Or select Tools, Show Database Explorer, and select the Objects tab. Or select Tools, Show DbTree to see the database structure.