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);
}
}
