JDBC Problem - Timed out waiting for a free available connection

[Former Member]

Hi all,

We are currently running 64GB HANA Developer Instance on Amazon. Our web application connect to HANA using JDBC, and occasionally, our web application crashes with this error:

java.sql.SQLException: Timed out waiting for a free available connection.

Any idea on what could be the problem?

Some extra information: Apart from the web application that connects to HANA, we have a number of Java applications (we call them "workers") that connects to HANA using JDBC as well, feeding HANA with information at regular interval (5 or 10 minutes). The amount of data that we feed is rather large, so these workers' up time are about 70%. There are 7 of them currently, so at any given time there is a good possibility that all 7 of them are connected to HANA and sending data at the same time.

Please let me know if you need extra information to resolve this issue.

Thank you! Looking forward to replies.

[Former Member]

Hi all,

The problem has been resolved. It turned out to be a JDBC configuration problem. We increased the number of connections in the pool, and the problem was alleviated.