This looks like an issue with the 3rd party driver UcanAccess. I have tried another driver (Trial Versions of caigen driver) and it’s working fine.
Snaplogic is using updated the Hikari connection pool management library version. This newer version requires databases to be able to support a validation query of “SELECT 1;” or have the driver itself implement a custom validation method. If you run select 1 using caigen driver it’s working fine but ucanaccess driver is rejecting that query. If the driver is JDBC 4.0 compatible they should support isValid method.
– Please see the below doc.
– Caigen links