Hi all,
I use tomcat-6.0.14 and postgresql-8.1 with JNDI connection pool, after a
while, my web application (written in Java/JSP), creates many database
connections and postgres processes.
But all of these connections are signed as "Idle", I want to close this idle
connections to avoid getting to get many postrgres processes.
So, is there a way to tells tomcat to close an Idle connection after some
time of inactivity?
At the state of the art, I close the connections, statements and resultsets
in the finally {} blocks, I use JNDI context resource to get the connection
and this is my context.xml:
<?xml version="1.0" encoding="UTF-8"?>
<Context path="/ManodoriSite">
<Resource name="jdbc/mydb" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="20" maxWait="10000"
removeAbandoned="true"
removeAbandonedTimeout="60"
logAbandoned="true"
username="myUser" password="myPassword"
driverClassName="org.postgresql.Driver"
url="jdbc:postgresql://databaseHost/database"/>
</Context>
I've already read tons of documentation, from the official site, google and
searched through the mailing list archive but I haven't found answer.
Many thanks!
Enrico
---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
