I have a simple application; I am not using connection pool & creating connection object on every request & closing the connection after completion of request. Ideally, number of connection at a time should be number of request at a time to the application; but it's not working like that; even if there are 5 users; it shows 60 connections sometimes (status - INACTIVE) from JDBC in Oracle database.
I am thinking to make connection_object = null; after closing it (connection_object.close(); ).
But not sure whether it would be helpful or not because close() method releases the db connection immediately. Is it possible to destroy the connection immediately by connection_object = null; or some other way?
Please let me know if you have any suggestions.
Thanks & Regards... [ October 27, 2006: Message edited by: Mira Mehta ]