BroadSQL Download
Documentation / Connect to your database: another JDBC database

Connect to another JDBC database

BroadSQL connects to any database with a JDBC driver: the same steps apply, with the driver and the URL format of that database.

DriverBundled for HSQLDB; for any other database, Apache Derby included, its vendor's JDBC driver JAR in drivers.
URL formatthe URL format of the vendor's JDBC driver
Examplesee the vendor's driver documentation
Verified with BroadSQLDepends on the database: see the vendor's documentation.

Steps

  1. The driver: HSQLDB is included in BroadSQL (the CINEMA sample is an HSQLDB database: see Sample databases). For another database (Apache Derby included, since BroadSQL 5.5.5), download its vendor's JDBC driver and copy the JAR directly into the drivers folder, then restart BroadSQL.
  2. Check it: SHOW DRIVERS; lists the drivers, with their names, versions and source: Bundled or drivers folder. A JAR copied while BroadSQL was running is listed with Restart BroadSQL to load it.
  3. The connection: ADD CONNECTION <id>; (or CONFIG; on Windows). Choose your database in the list of types, then give the URL in the format documented by the driver's vendor.
  4. Test and open it: PING <id>;, then CONNECT <id>;.

If your database does not appear in the list of types, tell us which database and which driver you use.

What works on every database

Ordinary statements, the commands that browse tables and columns (DESCR, SHOW TABLES...) and DUMP work the same way on every database type reachable through a registered connection. A few behaviors depend on the type: see Behavior that differs by database type.

Found something wrong or unclear on this page? , with the page address.