Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

MySQL connection with AEM - No data source found with name '------'

saukaush
Level 2
Level 2

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.

3 Replies
shaileshb584084
Level 3
Level 3

Hi,

 

I tried creating the configuration directly through crx/de and it worked fine. I am using AEM 6.5.5.

 

Please check while you are creating the configuration, if the node is properly created or not. I tried under the path "/apps/system/config" and under the project specific run mode as well.

 

shaileshb584084_0-1607615926362.png

 

Thanks

 

saukaush
Level 2
Level 2

Hi Shailesh, 

I see you have created the config as a nt:file. I have created sling:osgiConfig under /apps/myproject/config.

 

saukaush_0-1607661961249.png

 

Is it like import com.day.commons.datasource.poolservice.DataSourcePool Reference scans and stores only configs stored as nt:file?

 

and the strange thing is if i created the config manually from configMgr for a very first time on a machine, DataSourcePool scans and stores every config ( be it manual from configMgr or as osgiConfig in crxde). But if the very first config on a machine is created through crxde, DataSourcePool doesn't show up anything.

Arun_Patidar
Community Advisor
Community Advisor

try to restart services after creating repository based config.