Hi Everyone,
I am working to establish/integrate JDBC connection pool in AEM.
I can get the connection from the connection pool and the code is working fine.
My question is,
Can someone provide some Adobe recommened documentation for the same.
Solved! Go to Solution.
Views
Replies
Total Likes
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.
Hi @akhilraj
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.
@akhilraj Did you find the suggestions from users helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community.
Views
Replies
Total Likes
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.
Thank you for sharing this solution with the AEM community. Looking forward to seeing you more in this community.
Views
Replies
Total Likes