Bookmark Topic Watch Topic
  • New Topic

JDBC connection in Oracle db

 
Mira Mehta
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi,

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 ]
 
Carol Enderlin
drifter
Ranch Hand
Posts: 1364
  • Mark post as helpful
  • send pies
  • Report post to moderator
Please don't crosspost.

CarefullyChooseOneForum
 
    Bookmark Topic Watch Topic
  • New Topic