UCanAccess datasource stuck after error – requires Gateway restart

Ignition
1

Hi there,

I’m using UCanAccess 5.0.1 in Ignition 7.8 to read a MS access .mdb file.

The connection works normally, but if there is a transient issue (e.g. file temporarily unavailable or damaged MDB file), I get errors like net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::5.0.1 null or org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (UCAExc:::5.0.1 null).

After that, the datasource seems to get stuck, all queries fail continuously, It does not recover even when the file is valid again, restarting the Ignition Gateway fixes it immediately, renaming the MDB file also restores the connection.

So it looks like the datasource or connection pool enters a permanent faulted state after a single failure.

Is there any way to reset/reinitialize the datasource without restarting the Gateway? I tried disable and enable the database connection, that doesn’t work.

2

This is as much as you can do within the context of Ignition. This sounds like an issue with the JDBC driver/Windows.