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
BedrockMission!

Learn More

View all

Sign in to view all badges

Connectivity of postgres DB with AEM

Avatar

Avatar
Validate 1
Level 1
sahilg75191328
Level 1

Likes

2 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
sahilg75191328
Level 1

Likes

2 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
sahilg75191328
Level 1

20-06-2019

Hi Team,

We are trying to create the connectivity between AEM and postgres sql.

I am following the below documentation and stuck with below error can someone help me out.

Error Logs:-

20.06.2019 17:29:14.382 *INFO* [CM Event Dispatcher (Fire ConfigurationEvent: pid=com.day.commons.datasource.jdbcpool.JdbcPoolService)] day.commons.datasource.jdbcpool deactivating data source with name=datasourcename

20.06.2019 17:29:14.385 *INFO* [CM Event Dispatcher (Fire ConfigurationEvent: pid=com.day.commons.datasource.jdbcpool.JdbcPoolService)] day.commons.datasource.jdbcpool Service [8173, [javax.sql.DataSource]] ServiceEvent UNREGISTERING

20.06.2019 17:29:14.388 *INFO* [CM Event Dispatcher (Fire ConfigurationEvent: pid=com.day.commons.datasource.jdbcpool.JdbcPoolService)] day.commons.datasource.jdbcpool Service [com.day.commons.datasource.jdbcpool.JdbcPoolService,8172, [com.day.commons.datasource.poolservice.DataSourcePoolProvider]] ServiceEvent UNREGISTERING

20.06.2019 17:29:14.390 *INFO* [CM Event Dispatcher (Fire ConfigurationEvent: pid=com.day.commons.datasource.jdbcpool.JdbcPoolService)] day.commons.datasource.jdbcpool Configuring and activating data source with name=datasourcename

20.06.2019 17:29:14.390 *INFO* [CM Event Dispatcher (Fire ConfigurationEvent: pid=com.day.commons.datasource.jdbcpool.JdbcPoolService)] day.commons.datasource.jdbcpool Datasource configured, name=datasourcename, connectionURI=xya_url, default readonly=false, default autocommit=true, validation query=null

20.06.2019 17:29:14.392 *INFO* [CM Event Dispatcher (Fire ConfigurationEvent: pid=com.day.commons.datasource.jdbcpool.JdbcPoolService)] day.commons.datasource.jdbcpool Service [8175, [javax.sql.DataSource]] ServiceEvent REGISTERED

20.06.2019 17:29:14.394 *INFO* [CM Event Dispatcher (Fire ConfigurationEvent: pid=com.day.commons.datasource.jdbcpool.JdbcPoolService)] day.commons.datasource.jdbcpool Service [com.day.commons.datasource.jdbcpool.JdbcPoolService,8174, [com.day.commons.datasource.poolservice.DataSourcePoolProvider]] ServiceEvent REGISTERED

20.06.2019 17:29:48.560 *INFO* [sling-threadpool-d9f18639-77ad-4d0a-855f-365d54c37495-(apache-sling-job-thread-pool)-160-com_day_cq_replication_job_publish(com/day/cq/replication/job/publish)] com.day.cq.replication.Agent.publish.queue Processing job for agent publish

20.06.2019 17:29:48.560 *INFO* [sling-threadpool-d9f18639-77ad-4d0a-855f-365d54c37495-(apache-sling-job-thread-pool)-160-com_day_cq_replication_job_publish(com/day/cq/replication/job/publish)] com.day.cq.replication.Agent.publish Create new HttpClient for Default Agent

20.06.2019 17:29:48.561 *INFO* [sling-threadpool-d9f18639-77ad-4d0a-855f-365d54c37495-(apache-sling-job-thread-pool)-160-com_day_cq_replication_job_publish(com/day/cq/replication/job/publish)] com.day.cq.replication.Agent.publish * Auth User: admin

20.06.2019 17:29:48.561 *INFO* [sling-threadpool-d9f18639-77ad-4d0a-855f-365d54c37495-(apache-sling-job-thread-pool)-160-com_day_cq_replication_job_publish(com/day/cq/replication/job/publish)] com.day.cq.replication.Agent.publish * HTTP Version: 1.1

20.06.2019 17:29:48.562 *INFO* [sling-threadpool-d9f18639-77ad-4d0a-855f-365d54c37495-(apache-sling-job-thread-pool)-160-com_day_cq_replication_job_publish(com/day/cq/replication/job/publish)] com.day.cq.replication.Agent.publish Sending POST request to http://localhost:4503/bin/receive?sling:authRequestLogin=1

20.06.2019 17:29:49.568 *ERROR* [sling-threadpool-d9f18639-77ad-4d0a-855f-365d54c37495-(apache-sling-job-thread-pool)-160-com_day_cq_replication_job_publish(com/day/cq/replication/job/publish)] com.day.cq.replication.Agent.publish Error while sending request: java.net.ConnectException: Connection refused: connect

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Give Back 5
Level 4
joeb21688728
Level 4

Likes

33 likes

Total Posts

60 posts

Correct Reply

8 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile

Avatar
Give Back 5
Level 4
joeb21688728
Level 4

Likes

33 likes

Total Posts

60 posts

Correct Reply

8 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile
joeb21688728
Level 4

21-06-2019

Querying data from a relational database to display in an AEM component can be done:

Adobe Experience Manager Help | Querying MySQL data using an Adobe Experience Manager 6.4 DataSource...

Answers (5)

Answers (5)

Avatar

Avatar
Coach
Employee
Jörg_Hoh
Employee

Likes

1,112 likes

Total Posts

3,145 posts

Correct Reply

1,072 solutions
Top badges earned
Coach
Give back 600
Ignite 5
Ignite 3
Ignite 1
View profile

Avatar
Coach
Employee
Jörg_Hoh
Employee

Likes

1,112 likes

Total Posts

3,145 posts

Correct Reply

1,072 solutions
Top badges earned
Coach
Give back 600
Ignite 5
Ignite 3
Ignite 1
View profile
Jörg_Hoh
Employee

20-06-2019

What do you want to do with postgresql? If you want to store your repository in there, please see Hamid's response.

The error you see is totally unrelated to JDBC or postgresql. It's just saying that your AEM instance tries to replicate data (caused by whatever reason) and the publish instance is not reachable.

Jörg

Avatar

Avatar
Validate 1
Level 1
anandkilli
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
anandkilli
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
anandkilli
Level 1

21-06-2019

Hi Sahil,

What version of AEM you are trying this on? The error that you posted doesn't seem to be related to the issue you are seeing. Let us know at a high level what you have tried (you already mentioned one, wrapping the PostegreSql jdbc jar as osgi bundle).

What are you expecting to see and what you are seeing.

I will try to reproduce from my end and share any suggestions I can think of. Good luck.

Avatar

Avatar
Give Back 5
Level 4
Bharath_valse
Level 4

Likes

34 likes

Total Posts

65 posts

Correct Reply

11 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile

Avatar
Give Back 5
Level 4
Bharath_valse
Level 4

Likes

34 likes

Total Posts

65 posts

Correct Reply

11 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 25
Give Back 10
Give Back
View profile
Bharath_valse
Level 4

20-06-2019

If I understand correctly, you are trying to fetch some information from postgresql for some transaction in AEM and not trying to replace  tarMK with RDBMS. Couple of options to look at

- Are you able to successfully install the driver specific to postgreSQL? Make sure you have wrapped the driver jar to osgi bundle. If the drivers are not installed correctly, program to connect to the DB should spit some errors in the logs

- Do you have these osgi configs as part of your code under /apps. This article might help AEM Concepts | AEM Tutorial | Know Adobe CQ better: November 2017

Avatar

Avatar
Validate 1
Level 1
sahilg75191328
Level 1

Likes

2 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
sahilg75191328
Level 1

Likes

2 likes

Total Posts

4 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
sahilg75191328
Level 1

20-06-2019

Hi Joerg,

I can understand this error is related to replication but whenever i am trying to connect with database it is trying to replicate something due to which connection is refusing.

Our Use Case:-

We need to read the data from the Postgres DB to process some transactions in AEM.

I am following the below article to achieve this connectivity.

https://helpx.adobe.com/experience-manager/6-3/sites/developing/using/jdbc.html

Avatar

Avatar
Contributor
Employee
hamidk92094312
Employee

Likes

102 likes

Total Posts

240 posts

Correct Reply

38 solutions
Top badges earned
Contributor
Shape 1
Ignite 1
Give Back 50
Give Back 5
View profile

Avatar
Contributor
Employee
hamidk92094312
Employee

Likes

102 likes

Total Posts

240 posts

Correct Reply

38 solutions
Top badges earned
Contributor
Shape 1
Ignite 1
Give Back 50
Give Back 5
View profile
hamidk92094312
Employee

20-06-2019

Please note that support for PostgreSQL is provided only for demo purposes. It will not be available for production environments. you may want to use one of the RDBMS that is officially supported:

RDBMS Support in AEM 6.4