Hi Prajeesh
You have to make a Torque.shutdown in your init class when the context is
destroyed (see method contextDestroyed)
public class InitTorque implements ServletContextListener {
public void contextDestroyed(ServletContextEvent e) {//Add this method
!!!
Torque.shutdown();
}
public void contextInitialized(ServletContextEvent e) {
if (!Torque.isInit()) {
try{
Torque.init(e.getServletContext().getRealPath(
"/WEB-INF/Torque.properties"));
} catch (TorqueException e1) {
...
}
}
}
}
Hope this will help,
Bernard NO�L
Prajeesh Kumar
<[EMAIL PROTECTED] Pour : Apache Torque Users List
<[email protected]>
tions.com> cc :
Objet : Re: Connection
pooling
28/12/2004 09:54
Veuillez r�pondre �
"Apache Torque Users
List"
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
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
