|
I have modified our server.xml of Tomcat 6.0 and added attributes in <resource> tag: removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true" These attributes would prevent us to have connection pool leak. part of my server.xml: <resource name="SupportToolDataSourceGlobal" auth="Container" type="javax.sql.DataSource" maxactive="100" maxidle="30" maxwait="10000" username="viewsupuser" password="viewsupuser" driverclassname="com.mysql.jdbc.Driver" url="jdbc:mysql://10.2.3.16:3306/viewsup?zeroDateTimeBehavior=convertToNull&jdbcCompliantTruncation=false&autoReconnect=true" factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" removeabandoned="true" removeabandonedtimeout="60" logabandoned="true"/>If logAbandoned="true", where can I actually find the logs where I can see abandoned connections? Thanks! |
