tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edoardo Panfili <edoa...@aspix.it>
Subject How to close open connections after application stop?
Date Sun, 22 Feb 2009 10:25:42 GMT
Hy,

I have one webapp in Tomcat 6.0.18 with this context:

<Context path="/myApp" docBase="myApp" debug="100" reloadable="true">
   <Resource name="jdbc/myApp" auth="Container"
       type="javax.sql.DataSource"
       maxActive="8" maxIdle="5" maxWait="300"
       username="myApp" password="passwd"
       driverClassName="org.postgresql.Driver"
       url="jdbc:postgresql://127.0.0.1:5432/myApp"
       removeAbandoned="true"
       removeAbandonedTimeout="30"
       logAbandoned="true"
   />
</Context>

After application stop (using tomcat manager) I'd like to (drastic 
example) rename the db, but I can't do it because there are open 
connections.

There are no other application using myApp db, but with "ps ax" I can see:

189   ??  Ss     0:02.67 postgres: myApp myApp 127.0.0.1(49162) idle

Is there a way to close the connection without closing Toncat?

thank you
Edoardo


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message