Re: Closing Connections.

2002-03-12 Thread August Detlefsen 

Yes you have to close the connections! Nothing will drop your server
faster than running out of DB connections. 

If you open your connection with this: 

Connection conn = DriverManager.getConnection(url, user, password);

Then you close it like this: 

conn.close();



--- Hari Yellina [EMAIL PROTECTED] wrote:
 Hi All,
 
  Is it neccesary for us to close the connetions for the database. Is
 the
 java garbage collector gonna do the job for us.
 
 If that is not the case please tell me how to close the connections.
 We have
 a application containing 800 pages . Every page has a connection open
 . Do
 we require to close all the applications.
 
 Regards, Hari Yellina.
 
 
 --
 To unsubscribe:   mailto:[EMAIL PROTECTED]
 For additional commands: mailto:[EMAIL PROTECTED]
 Troubles with the list: mailto:[EMAIL PROTECTED]
 


__
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/

--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]

RE: Closing Connections.

2002-03-12 Thread Sergei Batiuk 

Hello,

It is a good practice to close all open connections with a JSP. Event though
connections will be eventually closed by Java garbage collector, while open
they consume valuable resources, such as memory and network traffic. To me
it not an option if I should close db connections - I always do that.

Sincerely,
Sergei Batiuk.

IT department
Damen Shipyards Okean
+380 512 293146
+380 512 293329


-Original Message-
From: Hari Yellina [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, March 12, 2002 8:10 AM
To: Tomcat Users List
Subject: Closing Connections.


Hi All,

 Is it neccesary for us to close the connetions for the database. Is the
java garbage collector gonna do the job for us.

If that is not the case please tell me how to close the connections. We have
a application containing 800 pages . Every page has a connection open . Do
we require to close all the applications.

Regards, Hari Yellina.


--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]



--
To unsubscribe:   mailto:[EMAIL PROTECTED]
For additional commands: mailto:[EMAIL PROTECTED]
Troubles with the list: mailto:[EMAIL PROTECTED]