Connection Pool in AEM

Question

Hi Everyone,

I am working to establish/integrate JDBC connection pool in AEM.

Installed JDBC driver
Configured the Day Commons JDBC Connections Pool configuration.
Created a simple OSGI service to initialize DataSource and reading connection from a util.

I can get the connection from the connection pool and the code is working fine.

My question is,

Is there any AEM recommended code base available for connection pool configuration/set up or DataSource OSGI service?
Currently we are creating connection and closing it in finally block, after changing into Connection Pool also, It is recommended to close the connection in the logic finally block after use right?
Few articles mentioned, if we close the connection from logic, it wil not actually close the connection, but connection pool will get notified and it will keep the connection for next use..Is it right

Can someone provide some Adobe recommened documentation for the same.

akhilraj · Accepted Answer

We proceeded with Day Commons JDBC Connections Pool.

We have created an interface and implemented OSGI services for the same and getting the connection.

In the implementation class, we have created method to get connection based on data source.

Same connection, we have used in other functions and it is working fine.

Raja_Reddy · Answer

I believe you are using the Day Commons JDBC Connections Pool. I would suggest to try the Apache Sling Connection Pooled datasource which is based on http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html

While I don't have the comparison between the 2 it looks like the apache Sling Connection Pooled datasource should handle your scenario of idle connections better. Here is a reference link on how to configure it - https://helpx.adobe.com/experience-manager/6-3/forms/using/data-integration.html

Hope this article will help you out to fix this issue.

Sign up