Datasource for Oracle Database

Forum|Forum|3 years ago
August 16, 2022
3 replies
1388 views

Hi,

I am trying to create a Form Data Model using a data source that is connect to my Oracle Database. I'm not sure if a configured a field wrong but I am getting the error "error fetching datasource" so I am assuming it is something dealing with the JDBC connection URI. Does anyone know what I am supposed to put for the JDBC connection URI? Below is a screenshot of the "error fetching datasource" message.

Thank You

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by Pulkit_Jain_

@justinbr17

You can try to fetch the data source again and tail the logs-

http://ServerName:Port/system/console/slinglog/tailer.txt?tail=10000&grep=*&name=%2Flogs%2Ferror.log

Pulkit_Jain_

Adobe Employee

@justinbr17

To configure data sources, you can review the steps shared here [0]. This is specific to the data source config. You can check the error msg in the logs to narrow down the issue.

You can also use the Oracle bundle jar provided here- https://drive.google.com/file/d/1dDQSntwrY2dJjH1STlIxOhwtyzxz_69e/view

[0] - https://helpx.adobe.com/customer-care-office-hours/aem/AEM-Forms-Data-Integration-using-FDM.html

J

JustinBr17Author

Level 3

Hi,

How exactly can I check the error msg in the logs?

Pulkit_Jain_

Accepted solution

Adobe Employee

@justinbr17

You can try to fetch the data source again and tail the logs-

http://ServerName:Port/system/console/slinglog/tailer.txt?tail=10000&grep=*&name=%2Flogs%2Ferror.log

Nikhil_Verma

Level 4

You are correct, the error indicates that AEM is unable to connect to the data source, that means we have to check the data source configuration.

Since you're using JDBC, you need to configure the Apache Sling Connection Pooled DataSource OSGi configuration: https://experienceleague.adobe.com/docs/experience-manager-learn/forms/storing-and-retrieving-form-data/part1.html?lang=en

Here's a video demonstrating the above: https://www.youtube.com/watch?v=XGVJLbgo8lU

Once the datasource has been configured correctly and AEM is able to connect to it, you should not see that error.

Note: In the above video you will notice that the person installed the JDBC jar by directly uploading it to OSGi. Thats not the best practice, however its quick to test it out this way. I suggest to do the steps on your local first.