Download MonetDB JDBC Driver

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

About the MonetDB JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to MonetDB. 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 MonetDB driver uses its own syntax — see the connection details below.

The MonetDB JDBC driver

MonetDB is an open-source columnar database management system from CWI (Netherlands) pioneering the column-store approach for analytical workloads. It is research-grade but production-ready, used for scientific data processing, BI, and applications requiring fast aggregate queries.

The MonetDB JDBC URL

• Required File(s): monetdb-jdbc-xxx.jar
• Java Driver Class: nl.cwi.monetdb.jdbc.MonetDriver
• JDBC URL: jdbc:monetdb://HOST:PORT/DB
• Website: MonetDB

Download MonetDB JDBC Driver

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

Connecting to MonetDB

MonetDB separates the daemon that manages databases from the databases themselves, which is why a running server can still refuse the database you name.

1. Release and start the database. monetdbd manages a dbfarm, and each database inside it can be stopped, started or held under maintenance independently. monetdb status shows which; a database that is not released refuses clients.
2. Let the daemon listen beyond localhost. monetdbd set listenaddr=0.0.0.0 <dbfarm> opens it to the network; the default keeps it on the loopback interface. The daemon has to be restarted for the change.
3. Note the port collides with Db2's default. DbSchema prefills 50000, which is also IBM Db2's default. On a machine running both, one of them was moved — check which before writing a firewall rule.
4. Open port 50000 in the server's firewall. The database listens on port 50000 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 and MonetDB

DbSchema connects to MonetDB using the MonetDB JDBC driver and renders the columnar schema structure in the visual diagram. Use the SQL Editor for MonetDB SQL including BAT algebra extensions and column-optimized aggregate queries.