Access does not allow you to set the query timeout and the Statement.setQueryTimeout(int)
call throws an exception with SQL State SC100
.
Setting the following registry key to "y":
HKEY_LOCAL_MACHINE\SOFTWARE\Easysoft JDBC-ODBC Bridge\Configuration\System\settings\S1C00
will downgrade the SQLException
for SQLState S1C00
to an SQLWarning
, thus allowing the application to progress.