[jira] [Commented] (CAMEL-7781) Create new PostgreSQL async notifications component

["Willem Jiang (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CAMEL-7781?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14193648#comment-14193648 ] 

Willem Jiang commented on CAMEL-7781:
-------------------------------------

Hi Deven,

First I'd like to say thank you for the new PostgreSQL component.

I check the driver license, it's BSD style license, so I think we can host this component in the Apache Camel repository.

After checked out the pgevent component you worked, I think you just missed up the function of consumer and producer. 

In your component you just want to listen to the notification from PostgreSQL, so you just need to implement the consumer which consume the message from PostgreSQL. You don't need to implement a producer to subscribe the listener to the PostgreSQL server, we treat the subscription as the message that camel sends to PostgreSQL. In this way we don't need to add the route to("pgevent:xxx") to start the subscription of form("pgevent:xxx").

Please put the connection code into the consumer doStart method, and consumer can start to listen to event once it route is started.

BTW, you can sent a PR to Apache Camel in the github, and we can keep polishing the component there :)

Regards,

Willem

> Create new PostgreSQL async notifications component
> ---------------------------------------------------
>
>                 Key: CAMEL-7781
>                 URL: https://issues.apache.org/jira/browse/CAMEL-7781
>             Project: Camel
>          Issue Type: New Feature
>            Reporter: Deven Phillips
>            Priority: Minor
>              Labels: features
>   Original Estimate: 80h
>  Remaining Estimate: 80h
>
> Create a new component which allows for sending and receiving PostgreSQL's async notifications using the pgjdbc-ng driver. 



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)