setQueryTimeOut
with a JDBC-ODBC Bridge connection to Access. What can I do?Microsoft Access doesn't allow you to set a query timeout. A Statement.setQueryTimeout(int)
call throws a SQL State SC100
exception.
Setting the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Easysoft JDBC-ODBC Bridge\Configuration\System\settings\S1C00
to y changes the SQLException
to a SQLWarning
. This allows the application to progress.