The MSSQL JDBC driver has a quirk where certain exceptions (like RAISERROR) get queued and only surface when iterating through all result sets. Without proper handling, these errors can be silently swallowed.
Modern Mode ensures Lucee properly surfaces these deferred exceptions. Enable it via:
- System Property:
-Dlucee.datasource.mssql.modern=true - Environment Variable:
LUCEE_DATASOURCE_MSSQL_MODERN=true
See the MSSQL Modern Mode documentation for full details.