Re: Cayenne Connection Pool Monitoring - to solve "out of connections" error

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu May 13 2010 - 06:19:42 UTC

  • Next message: Sudheer: "Creating Cayenne objects from DTO annotations"

    Currently Cayenne has no built in monitoring API. We'll likely be
    building one at some point, based on JMX. But you can use JMX Java
    tools right away. E.g. to take a peek at thread dump remotely:

    http://java.sun.com/developer/technicalArticles/J2SE/jconsole.html

    If that also doesn't work for you, I suggest overriding
    DriverDataSourceFactory and adding logging.

    Andrus

    On May 12, 2010, at 6:46 PM, Joe Baldwin wrote:

    > Andrus,
    >
    > I thought you were referring to
    > Thread.dumpStack()
    >
    > I don't believe I can execute the steps outlined in your reference
    > (1. the problem is not reproducible on my development machine and 2.
    > the webhost prevents command line access like this on the Linux
    > server.)
    >
    > Any other ideas? :)
    >
    > Joe
    >
    >
    >
    > On May 12, 2010, at 11:33 AM, Andrus Adamchik wrote:
    >
    >> I think we are talking about different things. I am referring to
    >> this (sorry the URL with lots of ads, just something i googled
    >> quickly) :
    >>
    >> http://www.crazysquirrel.com/computing/java/basics/java-thread-dump.jspx
    >>
    >> Andrus
    >>
    >> On May 12, 2010, at 6:28 PM, Joe Baldwin wrote:
    >>
    >>> OK, I will implement this. Do I need to make the query from the
    >>> same thread/session or will I get the same results from any session?
    >>>
    >>>
    >>> On May 12, 2010, at 11:19 AM, Andrus Adamchik wrote:
    >>>
    >>>>
    >>>> On May 12, 2010, at 6:17 PM, Joe Baldwin wrote:
    >>>>
    >>>>> 1. Will this thread dump report anything that the MySQL
    >>>>> exception does not?
    >>>>
    >>>> Yes, it will report who is holding to all those connections.
    >>>>
    >>>> Andrus
    >>>>
    >>>
    >>>
    >>
    >
    >



    This archive was generated by hypermail 2.0.0 : Thu May 13 2010 - 06:20:16 UTC