How do I connect single CQ5 with multiple database like cert, dev databases?

[DEBAL_DAS]

Hi,

Please explain the procedure to connect single CQ5 author instance with multiple databases.

Thanks & Regards,

Debal

[smacdonald2008]

Configure each one to reference a different database. Configure multiple entries.      

[smacdonald2008 · Accepted solution]

Configure Multiple DataSourcePool objects - each one pointing to a different database. You can use app logic to use each one:

if (A)

 USE DataSourcePoolA

else if (B)

 USE DataSourcePoolB

else if (C)

  USE DataSourcePoolC

To learn how to use a DataSourcePool and configure it with AEM -- see:

http://helpx.adobe.com/experience-manager/using/datasourcepool.html

[DEBAL_DAS]

While configuring the DataSourcePool connection , we are using JDBC Connections Pool service,and we are providing the datasource name in 'DataSourceName' field.

If we try make connection with multiple datasources, how can we manage it. 

Thanks & Regards,

Debal