hi, what are the jdbc objects we must close after finishing a process? db - mysql web server - apache + tomcat in a servlet i use a connection broker from javaexchange and in the service method get a connection and towards the end free the connection. I close the statement and the prepared statements. Should i also close the result set. My application is repeatedly throwing a servlet exception and therefore stops. Can u please help. Regards, dj
Joined: Apr 11, 2001
ya u shuld also close the resultsets if any.
Joined: Jun 25, 2001
Actually, if you close the Statement only, it will automatically call ResultSet.close() on any resultsets using the statement closed. So you don't "HAVE" to close the resultset explicitly, but it may just be good habit.