Problem:

What is Pooled Connection and how to resolve pooled connectino related exceptions?

Resolution:

Product Name: StarTeam
Product Version: 2005 / 2005 R2
Product Component: Server
Platform/OS Version: Windows

Description:

Connection pooling is a technique of creatingand managing a pool of connections that are ready for use by any thread thatneeds them.

Connecting to a database is the single slowest operation in an application.That is why managing connections through connection pooling is important toapplication performance. Connection pooling allows you to reuse connectionsrather than create a new one every time the data provider needs to establish aconnection to the underlying
database.

In practice, when a thread needs to do work against a MSSQL or other database,it requests a connection from the pool. When the thread finished using theconnection, it returns it to the pool, so that it may be used by any otherthreads that want to use it.


Exception Error related to Pooled connection:


Exception thrown from Unknown: Class = StDatabaseException, Code=33(0x00000021)
Msg = Failed to acquire a database connection. Please contact an administratorto increase number of database connections


If this error occur, please goto Server Administration-> configure Server-> Database tab -> Pooled Connections and increase the number of connections.

Author: Sally Goh