My client's connection times out when trying to retrieve a huge number of records (1000+) from an EJB server that uses CMP to a database. How can I resolve this?

Shaun Childers

You need to make some adjustments to your EJB bean through the deployment descriptor. Modify the 'maxBeansInFreePool', 'maxBeansInCache' and 'idleTimeoutSeconds' fields until you get the results desired. The more you increase the value of 'maxBeansInFreePool' and 'maxBeansInCache', the less you should have to adjust the 'idleTimeoutSeconds' field.