JDBCExceptionReporter - SQL Error: 0, SQLState: 08001

Question

I did a Java appliction using spring , hibernate and Jaxb.

JDBCExceptionReporter - SQL Error: 0, SQLState: 08001
JDBCExceptionReporter - Could not create connection to database server. Attempted reconnect 3 times. Giving up.
JDBCExceptionReporter - SQL Error: 0, SQLState: 08001
JDBCExceptionReporter - Could not create connection to database server. Attempted reconnect 3 times. Giving up.

I have got the above error when i attempt to connect the database multiple times through loop. It is for working fine up to 50 Requests but getting error's when the looping is more then 50.

Am using java 1.7 and Tomcat 7.0

use connection pooling concept – suresh manda Apr 04 '13 at 14:07 — suresh manda, Apr 04 '13 at 14:07
try to close your connections – Ishikawa Yoshi Apr 04 '13 at 14:08 — Ishikawa Yoshi, Apr 04 '13 at 14:08
Please show code contains connection. – tostao Apr 04 '13 at 14:12 — tostao, Apr 04 '13 at 14:12

Shreyos Adikari · Answer 1 · 2016-08-22T16:05:54.180

JDBCExceptionReporter - SQL Error: 0, SQLState: 08001

This might came for various reasons:

In many cases, the main problem is the limitation of connections.
If you have a interaction and don't use connection pool, probably in the database the limit of connection was reached.
Other situation is, in JDBC palette if the number of connections (default 100) is more than number of BW jobs (default 0 for infinite).

Important: "Generally one needs to close the statement or Resultset before reusing them".

JDBCExceptionReporter - SQL Error: 0, SQLState: 08001

1 Answers1

Linked