Mssql-jdbc General Issues Resolved

Ignition
1

Wanted to post my resolution to an intermittent issue we've been having for the past year to an onsite SQL Server instance, which would disconnect and time out at random times, with the only logs stating:

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "Connection refused: connect. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.

It was infuriating, because nothing about the environment had changed to cause, or resolve, the issues.

The solution was to switch away from Microsoft's JDBC to a 3rd party option, https://jtds.sourceforge.net/

This has solved all my connection problems so far. Maybe it will help you too!

2

What version of Ignition and MSSQL JDBC driver version were you using? Had you tried upgrading it before ditching for the 3rd party option?

3

Also, what version of SQL Server? I had to add jtds for some older legacy stuff.

4

9.4.0 began having intermittent issues about 11 months ago. It was the bundled driver when ignition was initially installed. We attempted to upgrade to 11.2.1, but found similar errors, and did not have time to dig in and debug further. the 3rd party driver worked immediately upon install.

2 Likes
5

SELECT @@VERSION returns

Microsoft SQL Server 2019 (RTM-GDR) (KB5014356) - 15.0.2095.3 (X64) 
	Apr 29 2022 18:00:13 
	Copyright (C) 2019 Microsoft Corporation
	Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: )
2 Likes