RE: ThrottledPool handing

[Adam Gugliciello]

good point, it may be excepting and losing sessions, I'll close the sessions in a finally block. From: Niels Beekman [mailto:[EMAIL PROTECTED] Sent: Mon 8/15/05 2:29 PM To: user-java@ibatis.apache.org Subject: RE: ThrottledPool handing Adam,   Can you simulate what happens when   > t.execute(this.sqlMapClient)   throws an exception, so before you explicitly close the session?   Niels   From: Clinton Begin [mailto:[EMAIL PROTECTED] Sent: maandag 15 augustus 2005 19:19 To: user-java@ibatis.apache.org Subject: Re: FW:   Why does it take a minute to get a connection?  With a connection pool, it should literally be milliseconds.... Clinton On 8/15/05, Adam Gugliciello <[EMAIL PROTECTED]> wrote: Under a heavy sustained load, the sqlmaps ThrottledPool seems to start to bind, the the vast majority of them binding up and blocking waiting to build a new session, and stay blocked long after the fact, even days after the request has been abandoned. Any help would be appreciated, and I am attaching a thread dump.   My code looks like:    private void executeSqlMapTemplate(SqlMapTemplate t) throws SQLException     {         final Connection c =                 this._dbPool.borrowConnection("QuestionnaireCustomerApi",                         1 * 60 * 1000l); // Waits a minute for a connection         if (c == null)         {             throw new IllegalStateException("Unable to retrieve JDBC Connection from db pool.");         }         try         {             SqlMapSession sess=this.sqlMapClient.openSession(c);             t.execute(this.sqlMapClient);             sess.close();           }         finally         {               this._dbPool.returnConnection(c);         }     }