I have read other threads but my problem is not solved yet.
I want to understand whether this issue is because of TCP/IP settings or can also occur if too many DB calls are made? If it is because of settings then my application should not run at all. But I see this error only when data volume being processed is high and that too it happens only within particular time range and for particular load only, kinda strange. DBA says there is no problem with server and I'm not able to figure out the cause.
I'm using Hibernate, Spring based application.
ERROR [JDBCExceptionReporter.java:logExceptions:78] - The TCP/IP connection to the host has failed. Error: "Address already in use: connect. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com