SQL Error: 17002, SQLState: 08006 IO Error: A connection attempt failed because the connected party did not properly respond after a period of time

We Are Going To Discuss About SQL Error: 17002, SQLState: 08006 IO Error: A connection attempt failed because the connected party did not properly respond after a period of time. So lets Start this Java Article.

SQL Error: 17002, SQLState: 08006 IO Error: A connection attempt failed because the connected party did not properly respond after a period of time

  1. SQL Error: 17002, SQLState: 08006 IO Error: A connection attempt failed because the connected party did not properly respond after a period of time

    There was a network connection blip between your app server & database server. But what caused it, we can't explain without any more details.

  2. A connection attempt failed because the connected party did not properly respond after a period of time

    There was a network connection blip between your app server & database server. But what caused it, we can't explain without any more details.

Solution 1

Hibernate tries to close a statement but the connection (session) has been closed/terminated for some reason:

Error during closing a statement for:
java:jboss/datasources/: java.sql.SQLRecoverableException:
Closed Connection

SQL Error: 17002, SQLState: 08006 IO Error: A connection attempt
failed because the connected party did not properly respond after a
period of time, or established connection failed because connected
host has failed to respond

There could be multiple reason why this happen. Maybe it was a network problem that caused a timeout.

You should check with your DBA if he can see any errors on the database server.

Do you have configured database connection validation for your JDBC datasource?
http://www.mastertheboss.com/jboss-server/jboss-datasource/how-to-automatically-reconnect-to-the-database-in-wildfly

Original Author Of This Content

Solution 2

There was a network connection blip between your app server & database server. But what caused it, we can’t explain without any more details. If it started working automatically, then it looks like a temporary network issue between the two servers. Or it would have caused if you have used invalid ip/dns name in db server url. But that would require a change from your side to fix the issue.

Original Author Of This Content

Conclusion

So This is all About This Tutorial. Hope This Tutorial Helped You. Thank You.

Also Read,

Siddharth

I am an Information Technology Engineer. I have Completed my MCA And I have 4 Year Plus Experience, I am a web developer with knowledge of multiple back-end platforms Like PHP, Node.js, Python and frontend JavaScript frameworks Like Angular, React, and Vue.

Leave a Comment