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 |
|
Classname |
|
Sample URL |
|
In the "Default group" window, change "New Profile" to "NuoDB", for example, and configure as follows:
Driver |
NuoDB (com.nuodb.jar.Driver) |
URL |
|
Username |
|
Password |
|
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.
Or select Tools, Show Database Explorer, and select the Objects tab. Or select Tools, Show DbTree to see the database structure. |