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 Actions → Refresh.
  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 the JDBC driver version number. For example: Google BigQuery 8257 or MySQL 8257. If you want to use the same driver version with other properties, add an extra number. For example: Google BigQuery 8257 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 Actions → Refresh, and select the new driver.