ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Adam Gugliciello" <Ad...@emeta.com>
Subject FW:
Date Mon, 15 Aug 2005 15:57:54 GMT
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);
        }
    }
 

Mime
View raw message