[OCP 11 Complete Study Guide] [OCP 11 Programmer I Book] [OCP 11 Programmer II Book] [OCP 11 Practice Tests Book] [OCA 8 Book] [OCP 8 Book] [OCP 8 Practice Tests Book] [Blog]
Originally posted by gopal kishan:
Hi All,
If i not close the Statement, Resultset, Connection object then
what will happen??
[OCP 11 Complete Study Guide] [OCP 11 Programmer I Book] [OCP 11 Programmer II Book] [OCP 11 Practice Tests Book] [OCA 8 Book] [OCP 8 Book] [OCP 8 Practice Tests Book] [Blog]
Originally posted by Scott Selikoff:
Your database will crash? That seems a bit extreme, care to share an example?
Originally posted by Scott Selikoff:
Your database will crash? That seems a bit extreme, care to share an example?
Originally posted by gopal kishan:
Hi All,
If i not close the Statement, Resultset, Connection object then
what will happen??
Your database will crash? That seems a bit extreme, care to share an example?
Originally posted by Hemant Agarwal:
But if our object that is calling and holding the resultset destroyed, then the resultset would also destroyed.
Cheers!<br /><b>Annie</b>
[OCP 11 Complete Study Guide] [OCP 11 Programmer I Book] [OCP 11 Programmer II Book] [OCP 11 Practice Tests Book] [OCA 8 Book] [OCP 8 Book] [OCP 8 Practice Tests Book] [Blog]
<a href="http://www.auptyma.com" target="_blank" rel="nofollow">The Peak of Performance</a>
I'm still skeptical of those who claim the database will fail from not closing connections.
Granted the database may become overloaded via connections or have
100% utilization, but that could happen just as easily if too many people
are using the database at once, or if one person is doing too many
complicated joins.
Originally posted by Scott Selikoff:
I'm still skeptical of those who claim the database will fail from not closing connections.
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime. |