Querying MySQL data using an Adobe Experience Manager 6.4 DataSourcePool

You can create an Adobe Experience Manager 6.4 application that queries data located in a relational database and displays the data within a web page. In this article, you use a com.day.commons.datasource.poolservice.DataSourcePool instance to setup a connection to a MySQL database. Then you can use Java JDBC API to perform database operations, such as executing a query. For information, see Java JDBC API.

The following illustration shows the Experience Manager component developed in this article that displays data queried from MySQL.

The following video shows data located in the employee table being displayed in an Experience Manager component.

To read this development article, click https://helpx.adobe.com/experience-manager/using/querying-mysql-64.html.

Join the Experience League

To become an Experience Business, you need more than just great tools and online help. You need a partner. Experience League is a new enablement program with guided learning to help you get the most out of Adobe Experience Cloud. With training materials, one-to-one expert support, and a thriving community of fellow professionals, Experience League is a comprehensive program designed to help you become your best.

Join the Adobe Experience League by clicking this banner.

I (Scott Macdonald) am a Senior Experience League Community Manager at Adobe Systems with 20 years in the high tech industry. I am also a programmer with knowledge in Java, JavaScript, C#,C++, HTML, XML and ActionScript. If  you would like to see more AEM or other end to end articles like this, then leave a comment and let me know what content you would like to see.

Linked In: http://www.linkedin.com/in/scottmacdonald2010

YouTube: Subscribe to the AEM Community Channel.

.