Re: Connection pooling

[Prajeesh Kumar]

Hi Thomas,
I'm not making connection manually . The torque is doing that . I'm 
facing the problem in Torque. The only step what I'm doing is 
initializing the Torque.properties in a coustructor using Torque.init() 
method . Thanks for ur reply

regards
Prajeesh

Thomas Fischer wrote:

Hi,
you have to close the connection yourself. Try connection.close() in a
finally block:
java.sql.Connection connection = null;
try {
 ... whatever you do to get the connection
 ... whatever you do with the connection
}
finally {
 if (connection != null) {
   try {
     connection.close();
   }
   catch(Exception e) {}
 }
}
  Thomas
Prajeesh Kumar <[EMAIL PROTECTED]> schrieb am 28.12.2004
08:16:07:
 

Hello all ,
Currently i'm working on Torque 3.1 and I've configured a DHCP
connection to Postgresql database server running on linux. But the
connection opened by the TOmcat webserver , is not getting closed. What
shall i do? pleaze advice me .
How can I simply implement conection pooling in torque?
best regards
--
Prajeesh Kumar MS
V2Solutions
A New Vision to Solutions
India: +91-22-56733201 ext. 218
US : 1-408-705-2141  ext. 218
http://www.v2solutions.com
TZ:GMT+5.30

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
   


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

 


--
Prajeesh Kumar MS
V2Solutions
A New Vision to Solutions
India: +91-22-56733201 ext. 218
US : 1-408-705-2141  ext. 218
http://www.v2solutions.com 
TZ:GMT+5.30