Warning We have announced the end of life of Jobserver and all related Jobserver integrations for September 30, 2024, with the exception of Public Sector customers using GovCloud or on-prem environments.
For information on registering a data source via Edge, go to Registering and synchronizing a data source via Edge.

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.