AEM form data model 'Error in fetching Datasource' error?

Avatar

Avatar
Boost 10
Level 2
jezwn
Level 2

Likes

11 likes

Total Posts

76 posts

Correct reply

2 solutions
Top badges earned
Boost 10
Give Back 5
Contributor
Shape 1
Springboard
View profile

Avatar
Boost 10
Level 2
jezwn
Level 2

Likes

11 likes

Total Posts

76 posts

Correct reply

2 solutions
Top badges earned
Boost 10
Give Back 5
Contributor
Shape 1
Springboard
View profile
jezwn
Level 2

26-12-2019

Working with AEM forms I'm getting 'Error in fetching Datasource' error. 

These are my configurations.

JDBC driver classcom.mysql.jdbc.Driver
JDBC connection URIjdbc:mysql://localhost:3306/task569

Replies

Avatar

Avatar
Give Back 5
Level 2
zonroc
Level 2

Likes

7 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 5
Boost 3
View profile

Avatar
Give Back 5
Level 2
zonroc
Level 2

Likes

7 likes

Total Posts

13 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 5
Boost 3
View profile
zonroc
Level 2

29-12-2019

Have you placed the MySQL driver file into an OSGi bundle and deploy it? 

Avatar

Avatar
Validate 10
Level 5
tarekahf
Level 5

Likes

32 likes

Total Posts

409 posts

Correct reply

10 solutions
Top badges earned
Validate 10
Validate 1
Give Back 50
Give Back 5
Give Back 3
View profile

Avatar
Validate 10
Level 5
tarekahf
Level 5

Likes

32 likes

Total Posts

409 posts

Correct reply

10 solutions
Top badges earned
Validate 10
Validate 1
Give Back 50
Give Back 5
Give Back 3
View profile
tarekahf
Level 5

28-05-2020

Just download the JAR Connector/J file from the MySQL Download page, unzip the file and use the filename which has "-bin" in it.

 

Also, make sure the AEM machine can connect to the MySQL Machine using "telnet" command. Or try to run a query from the AEM Machine to MySQL using any Query Tool installed on AEM Machine. Make sure to verify all configuration related to the driver and data source in the AEM web console.

 

I used the latest 5.1.x version from here:

https://dev.mysql.com/downloads/connector/j/5.1.html

 

Unzip mysql-connector-java-5.1.49.zip, and select the JAR file with "-bin" in it. I understand that this file is already wrapped in an OSGi bundle. I spent several weeks troubleshooting this issue with Adobe Support. I hope this helps.

 

Tarek