When using the MSSQL driver exceptions are ignored
When using the MSSQL driver, exceptions raised in the query are ignored and the code will continue to return results (which could end up being a null value).
For example, if you run the following SQL using the JTDS driver you will get an exception:
However, run the same query using the MSSQL driver and the exception is ignored.
I've thrown together a unit test example (put in the Tickets folder)
which shows the issue.
I've checked this ticket with a fixed version 18.104.22.168-SNAPSHOT and the issue was solved on that. So I marked this as deployed
The primary reason we need to use the SQL Server driver is for encryption. However, we are seeing a few issues with the JTDS driver as well, that work better with SQL Server driver, but until the SQL Server driver issues are fixed we can’t use it.
curious, why don't you want to use the JTDS driver? I am trying to migrate from ACF10 too, and it looks like the JTDS driver is almost the same as ACF.