Database Drivers


Execute Query leverages the information available from the installed database JDBC drivers to generate much of its content. Installation and selection of database drivers is outlined below.

Installing a New Driver

Note: Please refer to individual database vendor documentation for information on downloading and using specific database JDBC drivers.

  1. Ensure the Drivers tab is selected (if the tab is not visible select the View > Drivers menu item).
  2. Select the New Driver button either from the JDBC Drivers list display in the central pane or the New JDBC Driver button from the Driver tab's toolbar.
  3. Complete the relevant fields as shown below:

    Driver Name The driver's name for identification
    Driver Description A brief description of this driver
    Database Select the database system this driver is for
    JDBC URL Enter the JDBC URL pattern for this driver or select an appropriate one from the list.
    URL pattern formats recognise the host, port and data source values for a particular connection.
    For example:
    jdbc:postgresql://[host]:[port]/[source]
    Path Enter the path to the JDBC driver jar file
    Class Name The JDBC driver class name. Select the find button if this is unknown and the system will scan the jar file entered in the path field for an appropriate driver class name

  4. The driver is now ready to use and will appear in the connection driver selection as the name entered above.
See Creating a New Connection to connect to a database.