Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Can I set ResultSets, Statements and Connections to null instead of closing them?

April 26, 2017closing null resultsets statements

0

10 Posted

Can I set ResultSets, Statements and Connections to null instead of closing them?

1 Answer

0

10 Posted

No. Setting references to null does not have the same result as calling close on the objects. Code that does this will be leaking resources on the database server with possibly dire consequences. Further code like this will often have major problems in using connection pools. Q.