Driver.getConnection hangs using SQLServer driver and Java 1.6.0_29

by

I encountered exactly the same behaviour:

I use both Oracle XE and MS SQL Server Express on my Windows 7 64bit PC – I upgraded to java 1.6.0_29 from 1.6.0_27 (the x64 version) and was surprised to see that the same programs where able to connect to Oracle XE but not to MS SQL Server…

I traced down the problem to javax.sql.DataSource.getConnection() where it was hanging forever – because this is just an interface, the jdbc drivers raised my suspicion…

I’m using the MS SQL Server JDBC Driver 3.0.1301.202 and I even updated to SQL Server CTP (the “community technical preview”) 4.0.1722.1 because my suspicion was that it has to do something with the jdbc driver – but no success: still hanging!

My workaround was to downgrade to 1.6.0_27 and — bang: everything was fine again!

best regards
Erich

More Related Contents:

  1. How do I connect to a SQL Server 2008 database using JDBC?
  2. How to pass Table-Valued parameters from java to sql server stored procedure?
  3. JDBC connection failed, error: TCP/IP connection to host failed
  4. What does Statement.setFetchSize(nSize) method really do in SQL Server JDBC driver?
  5. Can I connect to SQL Server using Windows Authentication from Java EE webapp?
  6. java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver
  7. SQL Server JDBC Error on Java 8: The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption
  8. JPA SQL Server No Dialect mapping for JDBC type: -9
  9. Native Library sqljdbc_auth.dll already loaded in another classloader
  10. com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 1433 has failed [duplicate]
  11. JDBC SQLServerException: “This driver is not configured for integrated authentication.”
  12. Date columns in SQL-Server (MSSQL-JDBC 3.0) running under Java 1.7.0 retrieved as 2 days in the past
  13. How to get *everything* back from a stored procedure using JDBC
  14. Getting the Return Value from JDBC MSSQL
  15. no sqljdbc_auth in java.library.path
  16. Connect To SQL Server With Windows Authentication From A Linux Machine Through JDBC
  17. The TCP/IP connection to the host localhost, port 1433 has failed
  18. Getting Hibernate and SQL Server to play nice with VARCHAR and NVARCHAR
  19. How to get the insert ID in JDBC?
  20. MySQLSyntaxErrorException near “?” when trying to execute PreparedStatement
  21. How can I get the SQL of a PreparedStatement?
  22. Is java.sql.Connection thread safe?
  23. How does Java’s PreparedStatement work?
  24. Create a jTDS connection string
  25. How to get all table names from a database?
  26. Should I use java.util.Date or switch to java.time.LocalDate
  27. Lightweight JDBC helper library alternative to Apache Commons DbUtils [closed]
  28. Java JDBC – How to connect to Oracle using tnsnames.ora
  29. MyBatis executing multiple sql statements in one go, is that possible?
  30. A persistent connection with JDBC to MySQL

Leave a Comment