Wednesday 29 January 2014

SET ARITHABORT

G'day:
Hey, we've got a problem with a stored procedure we're running. When running it in SQL Server Management Studio it runs like lightning. When running it over a JDBC connection, it takes over a minute.

Our DB Manager has tracked this back to being down to a settings difference between the JDBC driver and SSMS... the latter has SET ARITHABORT=ON, and JDBC by default has it OFF.

Does anyone know how to pass these settings on the JDBC URL to set it ON? Or any other way of doing it?

Cheers for any suggestions.

--
Adam