Bugs item #1073564, was opened at 2004-11-26 06:39 Message generated for change (Settings changed) made by ejort You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=1073564&group_id=22866
Category: JBossServer Group: v3.2 >Status: Closed >Resolution: Invalid Priority: 5 Submitted By: Purush Rudrakshala (prudrakshala) Assigned to: Adrian Brock (ejort) Summary: CachedConnectionManager - inUseConnections not correct Initial Comment: Environment: Windows XP SP2, JDK 1.4.2_05, JBoss 3.2.6 For CachedConnectionManager service debug option is enabled to monitor connections. <!-- Enable connection close debug monitoring --> <attribute name="Debug">true</attribute> Using jmx-console, if we look at the "inUseCount" property. The number displayed is not consitent with the underlying connection pool. "listInUseConnections" shows stack traces for connections that have been closed long back. It take a long time for the "inUseCount" to drop down, but never drops to 0 even after the connection pools correctly show inUseCount as 0. ---------------------------------------------------------------------- >Comment By: Adrian Brock (ejort) Date: 2004-11-30 14:29 Message: Logged In: YES user_id=9459 Try configuring the CCM valve configured for Tomcat. It is commented out by default. The setting <attribute name="Debug">true</attribute> is useless for web applications without it. See deploy/jbossweb-tomcat50.sar/server.xml (at the bottom). If you try it with JBoss4, the valve also includes checks for unfinished user transactions. I'm closing to close this, since it looks a misconfiguration of the debug settings. Please reopen if you still have a problem after adding the valve. ---------------------------------------------------------------------- Comment By: Purush Rudrakshala (prudrakshala) Date: 2004-11-30 02:06 Message: Logged In: YES user_id=1150762 I will try to re-produce this with a test case using sample database. There are no unclosed connection warnings or any errors. Based on the CCMs stack trace for listInUseConnections, I checked the code to make sure the connections are closed properly in finally block. These are not happing in EJB layers. POJO calls to JDBC directly from HTTP requests. ---------------------------------------------------------------------- Comment By: Adrian Brock (ejort) Date: 2004-11-29 17:25 Message: Logged In: YES user_id=9459 Please provide an example that reproduces the problem, or the logging as described here: http://www.jboss.org/index.html?module=bb&op=viewtopic&t=46931 The stacktraces of the unclosed connection might also be useful, don't you think? The two counts are actually different. The pool shows ManagedConnections, e.g. org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnetion the CCM (CachedConnectionManager) shows connection handles org.jboss.resource.adapter.jdbc.WrappedConnection as seen by the applications. Were the connections shown in the CCM linked to ManagedConnections that were closed due to an error rather than a user request to close them? Did you receive an unclosed connection warning for these connections or are these not requested from the ejb layer? The stacktrace should show this. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=1073564&group_id=22866 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development