Error when managing connection properties of a driver for Jobserver

Issue

When you want to change the properties of a connection used to register data sources via Jobserver, you receive the following error message:
CollibraIllegalStateException: jdbcDriverCannotBeUpdatedWhenLinked when trying to delete or edit a JDBC driver.
or
You cannot update the driver because it is linked to a Schema Asset

Reason

Once you have successfully used a connection to register a data source via Jobserver, you cannot update the connection properties anymore.

Solution

If you want to change the properties for a driver, you need to create a new driver:

  1. Open a schema registered via the driver you want to update.
  2. Go to ActionsRefresh.
  3. In JDBC driver version, select Manage drivers....
  4. Create a new driver for the data source.
    As a best practice for the name of the drivers, use a naming convention which includes the data source and a version number. For example: Google BigQuery 1.5 or MySQL 5.9. If you want to use the same driver version with other properties, add an extra number. For example: Google BigQuery 1.5 v2.
    For details on the properties, see Manage Collibra-provided JDBC drivers.
  5. Save the new driver.
    The new driver is automatically applied to the schema.
  6. For each schema that uses the old driver, go to ActionsRefresh, and select the new driver.