I am trying to create MySQL connection from my servlet using Day Commons JDBC connections pool.
1. I created config manually from system/console/configMgr and tested my code. It worked fine. I added a new config from crx/de and both configs worked fine.
2. On another machine, i created the config first through crx/de and got below exception. com.day.commons.datasource.poolservice.DataSourceNotFoundException: No data source found with name 'retail' (after asking 0 providers)
I also tried creating config manually from system/console/configMgr but still the same exception.
What i have observed here is, if on any machine first config is created through system/console/configMgr, everything works fine, but when first config is created through crx/de i got exception.
Tested the same on 4 different machine, connection was successful on 2 as config was created using system/console/configMgr. on the other 2 machine, it keeps on failing as first connection created from crx/de.
Please suggest on the above issue.