Michele di Nuzzo

Data Science and Machine Learning

The jdbc connection with SQL Server 2008 R2 crashes without any response

After a database upgrade from SQL Server 2005 to SQL Server 2008 R2 a webapp jsp crashed in an attempt to connect to the DB.

Apparently there was no reason, there was no error message. It only block indefinitely the page. Also the connection and log were successful ….

After verifying that the DB was accessible, that port 1433 was ok, that the DBMS was properly configured and the JDBC driver sqljdbc4.jar was updated to the latest version, I found a similar case in which he pointed out that Java 6 Update 29 has a bug that produces just the previous situation.

A simple update to the Update 30 (or a downgrade to 28) solves the problem completely. It also seems that the same problem occurs with SQL Server 2012.

Leave a Reply