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







Reply via email to