Skip to content

Drivers management

Team Edition includes a selection of built-in drivers, but not all are preloaded with .jar files. This keeps the installation lightweight while allowing you to manage drivers as needed.

You can:

Important

Only an administrator can perform these actions.

Driver Manager

To begin adding a new driver, navigate to Administration -> Driver Management.

Create a custom driver

  1. Click Add to start adding a new driver.
  2. In the form, select a driver from the Driver Type dropdown menu.
  3. Fill in the necessary fields. For more details, see Driver parameters.
  4. Click Create to save the driver.

Upload binary files

After creating the driver, upload binary files:

  1. Find your driver in the Driver Management list and select it.
  2. Open the Libraries tab.
  3. Click Add File to upload the required .jar files.
  4. Confirm that the files appear in the table.
  5. Click Save.

Info

Once the binary files are uploaded, you can create a connection.

Generic driver

The Generic driver allows you to connect to databases that do not have a predefined JDBC driver. It works with any database that supports JDBC, giving you control to manually load the required JDBC library.

This driver is useful for connecting to custom or uncommon databases. It ensures flexibility in setting connection parameters, but you must ensure that the JDBC driver you provide is fully compatible with the database to avoid issues with connections or queries.

URL template

JDBC drivers use URLs to connect to databases, similar to web URLs. These URLs typically follow the format jdbc:vendor:host:port/database.

Example

PostgreSQL database might use jdbc:postgresql:localhost:5432/postgres.

Download binary files

If the required driver exists in the Driver Management list but its libraries haven’t been installed, you can download them.

  1. Go to Settings -> Administration -> Server Configuration.
  2. Enable Allow drivers downloading.
  3. Open the Libraries tab of the required driver in Administration -> Driver Management.
  4. Click Download to fetch .jar files from an official Maven or Git repository.
  5. Confirm that the files appear in the table.
  6. Click Save.
  7. Create a connection.

Edit an existing driver

  1. Open the required driver in Administration -> Driver Management.

  2. Update the necessary fields. For more details, see Driver parameters.

    Warning

    Changing the driver class will delete the existing driver.

  3. Go to the Libraries tab to manage driver files:

    • Remove old files.
    • Upload new ones.

  4. Click Save.

Restore default driver settings

To reset a driver to its original settings:

  1. Open the required driver in Administration -> Driver Management.
  2. Click Reset to default.

Note

This option is only available for built-in drivers. Custom drivers cannot be restored to default.

Delete an existing driver

Note

This action removes only the driver reference from the configuration file. To delete the driver file itself, go to your workspace and remove it manually.

  1. Open the Driver Management tab.
  2. Locate the driver you want to delete in the list.
  3. Check the checkbox next to the driver's name.
  4. Click the Delete button to remove the driver.

Tip

Instead of deleting a driver, you can disable it in the Server Configuration tab. For more details, see Server configuration administration.

Filtering drivers

You can filter drivers using three options:

  • Search
  • Custom/Default drivers
  • Driver State (Enabled/Disabled/All)

To access filter options, click the filter button:

Driver parameters

Parameter Description
Driver Name The name you assign to the driver. This can be any descriptive name that helps you identify the driver among others.
Driver Type Specifies the type of the driver used for connecting to the database. Users typically select the appropriate driver type based on the database being connected to. For unsupported databases, the Generic type is often used. For more information see section below.
Class Name The fully qualified name of the Java class for the JDBC driver. This is the main class that Java uses to interact with the database. It can often be found in the driver's documentation or by inspecting the .jar file.
URL Template A template for the database connection URL. If left empty, you must specify the JDBC URL manually for each connection. It's recommended to provide a template to simplify connection setup. For more information see section below.
Default Port The port number typically used by the database. This is optional and can be left blank if the port is non-standard or varies between installations.
Default Database The default database name to use for connections. This can simplify the setup process by pre-filling the database field when creating connections. Leave blank if no default database is applicable.
Description A brief explanation or notes about the driver. This is useful for adding contextual information, such as the database type, special requirements, or any custom configurations.