posted 23 years ago
If you are using connection pool, close statements properly as it than automatically closes resultsets.
If you are not using any connection pool, close connection properly as it than closes all associated statements and resultsets.
and do the closing work in finally{} block to make sure that statement/connection gets closed irrespective your code faces any exception.
Also You may need to set no of processes at Oracle End if you have set it too less for your Application.
------------------
Amit Agrawal,
New Delhi, India.
Amit Agrawal,<BR>New Delhi, India.