How can I connect to a relational database from AEM

[Aem-user1]

I want to know how to connect to MySQL from AEM. Whats the best way. 

[smacdonald2008 · Accepted solution]

You can use dependency injection and inject a DataSourcePool into an AEM Service. Once you successfully inject a DataSourcePool into an AEM service, you can use SQL commands to interact with MySQL. For information on how to work with DataSourcePools in AEM, see this community article: 

Injecting a DataSourcePool Service into an Adobe Experience Manager OSGi bundle