Lesson Learned #503: Lessons Learned Using JDBC Logging with Microsoft JDBC Driver for SQL Server
A few days ago, our customer encountered connectivity issues while using HikariCP in their Java application. To troubleshoot the problem, we enabled detailed logging for the Microsoft JDBC Driver for SQL Server. This logging gave me a lot of information and details, following I would like to share my lessons learned here.Intermittent JDBC Connectivity issue - The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: SQL Server returned an incomplete response. The connection has been closed
First published on MSDN on Nov 30, 2016 Symptoms:When connections are repeatedly made to SQL Server, one can observe about ~ 1% of connections having inability to connect.Java two tier applications will show connection leak symptoms with Microsoft SQL JDBC driver when running outside of a Web Server or Web Container
First published on MSDN on Feb 26, 2010 Java two tier applications running outside a java web server or java web container using SQL Server as the database may show symptoms of connection leak .
