When using the MSSQL driver exceptions are ignored

Description

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.

Environment

None

Activity

Show:
Pothys - MitrahSoft
yesterday

Pothys - MitrahSoft
April 15, 2021, 10:02 AM

I've checked this ticket with a fixed version 5.3.8.169-SNAPSHOT and the issue was solved on that. So I marked this as deployed

Dan Switzer, II
January 28, 2021, 4:05 PM

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.

Guardian
January 28, 2021, 3:23 PM
Edited

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.

Fixed
Your pinned fields
Click on the next to a field label to start pinning.

Assignee

Pothys - MitrahSoft

Reporter

Dan Switzer, II

Priority

Critical

Fix versions