Driver Editor

This dialog allows you to change the driver settings.

Basic settings

Driver name Name of driver, shown in the driver manager. May be used by DBeaver to name scripts, show tips, etc
Category Optional field. Some databases have many different drivers, it is convenient to group these drivers. Category is just a name for this group. Most drivers do not have category.
Class name Required field. It is a name of Java class which implements the driver. You may find the class name in the driver's documentation or click on the "Find Class" button in the "Driver Libraries" tab and choose the class name from the list.
Sample URL Optional field. If this value is left blank, you will need to specify the full database URL. It is much more convenient when the sample URL is specified - in this case the connection wizard will require only valuable connection properties (host name, database name, etc).

A sample URL is a JDBC database URL but instead of real database properties it consists of "patterns" which will be replaced by the connection wizard with real values.

List of supported URL patterns:

  • {host}- database host name
  • {port}- database port number
  • {database}- database/schema name
  • {server}- database server name. Rarely used, usually by complex legacy databases (e.g. Informix)
  • {folder}- database folder. Usually used by embedded database engines to specify folder with database files
  • {file}- the same as {folder}but specifies single file

Optional patterns may be enclosed in square brackets

Typical sample URL: jdbc:db2://{host}[:{port}]/{database}

Driver Libraries

List of external driver libraries. Usually the library is a jar or zip archive file which contains an implementation of a JDBC driver. You may specify an entire directory as source of driver classes instead of the archive file.

The "Find class" button below the library list searches for all JDBC driver implementations in the specified libraries. You may choose a particular class name (if there are multiple classes found) and it will be placed in "Class Name" field.

Connection properties

Default additional properties for the driver. These properties will be used for all connections based on this driver. However, these properties could be redefined in a particular connection.

Additional properties are used to configure drivers for a specific environment or for a specific requirement. The list of available properties is specific for each driver. You may find them in the driver's documentation or in the connection wizard ("Advanced properties" tab)

Advanced parameters

Advanced parameters are used by some drivers to configure driver specific behavior.

List of parameters supported by Generic driver provider:

Shutdown parameter Some embedded database engines require additional shutdown parameters in the URL when you disconnect from a database. Otherwise the driver will lock the database file until you finish the DBeaver process. If specified, the shutdown parameter will be appended to the database URL on disconnect. Usually the shutdown parameter looks like ;shutdown=true
Get active database query SQL query that returns name of current database/schema. Used by DBeaver to show active database/schema in UI.
Set active database query SQL query that changes current database/schema.

License

Driver license. If present then user should read and accept this license before use of this driver.