users@glassfish.java.net

Re: All request processing threads are busy and connections count increasing

From: <glassfish_at_javadesktop.org>
Date: Mon, 23 Mar 2009 11:52:10 PDT

Hello Jeanfrancois and Jagadish;
Thank you very much for your interest.
I guess connection pool related lines was exceptional. It's appears in only one of dump files.

While i'm investigating i've found that it may be an Toplink related issue according to:
http://forums.java.net/jive/thread.jspa?messageID=328175&#328175
http://forums.oracle.com/forums/thread.jspa?threadID=851676&tstart=0
http://www.bastian-voigt.de/2008/08/21/dont-use-toplink-essentials

DataBaen.getItem method in stack traces running a query like this:
        Item item = (Item) em.createQuery(
                "SELECT distinct i from Item i left join fetch i.images left join fetch i.itemSpecs where i.itemId = :itemId").setParameter("itemId", itemId).getSingleResult();

Maybe it is about fetch join related. I've changed query as:
 SELECT i from Item i where i.itemId = :itemId

Now i'm observing if that will happen again.


Regards.
[Message sent by forum member 'osmanizbat' (osmanizbat)]

http://forums.java.net/jive/thread.jspa?messageID=338552