Download NuoDB JDBC Driver

Download the NuoDB JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

About the NuoDB JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to NuoDB. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each NuoDB driver uses its own syntax — see the connection details below.

The NuoDB JDBC driver

NuoDB is a distributed SQL database designed for cloud-native applications, providing elastic scalability, active-active geo-distribution, and ACID transactions across nodes without shared storage. It speaks standard SQL and is compatible with MySQL and PostgreSQL tooling.

The NuoDB JDBC URL

• Required File(s): nuodb-jdbc-xx.jar
• Java Driver Class: com.nuodb.jdbc.Driver
• JDBC URL: jdbc:com.nuodb://HOST[:PORT]/DB
• Website: NuoDB

Download NuoDB JDBC Driver

The driver archive is a zip file. Extract it and load the .jar files using DbSchema's Driver Manager.

Connecting to NuoDB

NuoDB splits its work between transaction engines that serve SQL and storage managers that hold the data. A client connects through the admin layer, which picks an engine for it.

1. Connect to the admin process, not to an engine. The URL names the host running the NuoDB admin service; it hands the connection to a transaction engine. That indirection is what lets the cluster balance and survive an engine restarting.
2. Make the engines reachable too. Because you are redirected, opening only the admin port is not enough on a firewalled cluster — the transaction engines' ports have to be reachable from your machine as well.
3. Start at least one transaction engine. A database with storage managers but no running transaction engine accepts nothing, and the failure looks like a rejected connection rather than a stopped service.
4. Open port 48004 in the server's firewall. The database listens on port 48004 unless it was installed with a different one. A host firewall on the server blocks incoming connections on that port until a rule allows them. The firewall guide has the commands for Windows, ufw, firewalld and iptables.
5. Connect from DbSchema. In the Connection Dialog choose Remote computer or custom port, fill in the server host and the port, then press Test Connection to check that the server answers before you connect.

DbSchema prefills 48004; confirm it against your deployment, since NuoDB installations commonly assign their own ports.

DbSchema and NuoDB

DbSchema connects to NuoDB using the NuoDB JDBC driver and renders schemas, tables, and indexes in the ER diagram. Use Schema Synchronization to compare NuoDB schemas across environments and generate migration DDL.