In Java, what is a connection leak? How can you fix this?

1.	In Java, what is a connection leak? How can you fix this?
Answer» If a connection is opened and forgotten about, this is known as a "leak" SINCE each time it occurs, a connection is no longer available for REUSE. Connection leaks occur when some database requests or transactions are not closed properly or are not committed, causing the connections to be abandoned and closed permanently. Java developers commonly experience Connection Leaks when using Connection Pools. In the case where there is a section of code that fails to close a connection properly, a connection will leak from the pool each time the section of code is executed. Eventually, if this SITUATION CONTINUES, the pool will run out of connections, which is known as Pool Exhaustion. The application will hang once all available connections have been leaked. We can fix this by closing the connection and paying particular attention to any error handling code.

Answer»

If a connection is opened and forgotten about, this is known as a "leak" SINCE each time it occurs, a connection is no longer available for REUSE. Connection leaks occur when some database requests or transactions are not closed properly or are not committed, causing the connections to be abandoned and closed permanently.

Java developers commonly experience Connection Leaks when using Connection Pools. In the case where there is a section of code that fails to close a connection properly, a connection will leak from the pool each time the section of code is executed. Eventually, if this SITUATION CONTINUES, the pool will run out of connections, which is known as Pool Exhaustion. The application will hang once all available connections have been leaked. We can fix this by closing the connection and paying particular attention to any error handling code.

Discussion

No Comment Found

Related InterviewSolutions

In the past, what was the best implementation or debugging you did?
Tell me about a project that you worked on and the technologies you used. Why did you choose them?
What is event bubbling and capturing in JavaScript?
Why should arrow functions not be used in ES6?
What do you mean by Temporal Dead Zone in ES6?
What makes MVC (Model View Controller) different from MVP (Model View Presenter)?
Do you know how to prevent a bot from scraping your publicly accessible API?
What do you mean by MEAN Stack?
Explain the Restful API and write its usage.
State the difference between GET and POST.