<div>
thats fine if you are not using a connection pool, closing the connection will close all the statements.<br />
if you are using a connection pool however it is a problem as the close does not necessarily close the connection, it just returns it to the pool.<br />
<br />

</div>


thats fine if you are not using a connection pool, closing the connection will close all the statements.
if you are using a connection pool however it is a problem as the close does not necessarily close the connection, it just returns it to the pool.



<div>
I use connection pool, are there any potential risks if I close or not close statement. Can you explain more clearly?<br />
<br />

</div>


I use connection pool, are there any potential risks if I close or not close statement. Can you explain more clearly?



<div>
First, I use the statement like a local variable in my function. Follow me, when my function end, the local variable will destroyed. Can you explain me more?<br />
<br />
Second, can I use the following code:<br />
<br />
//ResultSet rs<br />
rs.getStatement().close();<wbr /><br />
<br />
Does the statement close immediately?<br />

</div>


First, I use the statement like a local variable in my function. Follow me, when my function end, the local variable will destroyed. Can you explain me more?

Second, can I use the following code:

//ResultSet rs
rs.getStatement().close();

Does the statement close immediately?


<div>
when the var goes out of scope that only makes it available to be cleaned up, it does not guarantee that the resources are freed.<br />
<br />
&gt;&nbsp;rs.getStatement().close();<wbr /><br />
&gt;&nbsp;Does the statement close immediately?<br />
<br />
yes<br />
<br />

</div>


when the var goes out of scope that only makes it available to be cleaned up, it does not guarantee that the resources are freed.

> rs.getStatement().close();
> Does the statement close immediately?

yes



<div>
didn't I answer your questions?
</div>


<div>
I feel I have answered and question (and also subsuquent queries)
</div>


I feel I have answered and question (and also subsuquent queries)

<div>
<div class="content wysiwyg-content">
In Java, &nbsp;If I close a connection but not close a statement. What will happen? What are the potential risks?
</div>
</div>


In Java,  If I close a connection but not close a statement. What will happen? What are the potential risks?

What happen if I don't close statement in Java

A Web service is a method of communication between two electronic devices over a network. It is a software function provided at a network address over the Web with the service always on as in the concept of utility computing. A web service has an interface described in Web Services Description Language (WSDL). Other systems interact with the Web service in a manner prescribed by its description using SOAP (Simple Object Access Protocol) messages. There are two major classes of Web services: REST-compliant web services, and Arbitrary web services.

Web Services

Web applications are systems that run in browsers that perform functions normally associated with other client-based programs. One of the most commonly used web applications is email; instead of downloading individual emails to a local machine, the data is shown through a website. Other examples of web applications are collaborative systems like a wiki or an online game.