In BES 5.1/5.2 Is there a way to set JDBC pool policy to make the connections permanent?

Problem:

• Product Name: BES/ APPSERVER
• Product Version: 5.2.1
• Product Component: JDBC
• Platform/OS Version: ALL

In BES 5.1/5.2 Is there a way to set JDBC pool policy to make the connections permanent?

Resolution:

Currently, there is nothing in place nor any property to have a JDBC Connection permanently associated with a stateless session bean.

The JDBC 2 pool property affecting removal of JDBC connections here is a time interval called "idleTimeout". After expiration of its specified value, default is 600 seconds, an idle connection is removed from the pool.

This property exists in order to release database connections that are not being used, freeing up database resources to benefit optimal performance from the database. Increasing "idleTimeout" extends the life of all idle JDBCconnections in the pool associated with a datasource but will have an impact on the backend database. If only certain EJBs (SLSB or otherwise) need to have this characteristic for JDBC connections, a specific datasource definition could be defined for that purpose (ensure the driver-datasource name is unique in order to create a separate connection pool with connections configured for the specified "idleTimeout" value).