My application hangs when calling 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.