Register Database Connections

First time you start DbConsole will create a file init.sql in the user home directory .DbConsole folder. The exact location will show in DbConsole console. Edit this file to create database connections using this two commands:

  • register driver <rdbms> <driverClass> <URL> <"default_parameters">
  • connection <name> <rdbms> <"parameters">

Example:

register driver PostgreSql org.postgresql.Driver jdbc:postgresql://<host>:<port>/<db> "port=5432"

connection pos1 PostgreSql "user=postgres password=secret host=localhost db=sakila"

For each used Rdbms (MySql,Postgres,Oracle...) the register driver command defines the Java driver class and the JDBC URL with parameters as <...> tags. In the example above the default port value is passed in the end. This way of defining connections give more flexibility in managing large number of connections. In the advanced section you will see the benefits.

The connection command defines the connection by setting the real values for each URL parameter. The rdbms from the register driver command should match the rdbms from the connection command.

DbConsole already include JDBC drivers for MySql, MariaDb, PostgreSQL, Oracle, SqlServer, Sqlite, Sybase, Teradata, Vertica, Derby, Exasol, Firebird, H2, HSql and Ingres. For the other databases you can download the driver using the command (rdbms is case sensitive):

download driver <rdbms>

The complete list of known drivers is the same as for DbSchema. Alternative download the JDBC driver .jar files by yourself and place them in the /home/users/.dbconsole/drivers/<rdbms>

Navigation