You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@camel.apache.org by "James Lindstorff (JIRA)" <ji...@apache.org> on 2015/08/28 07:45:45 UTC

[jira] [Updated] (CAMEL-9088) camel-pgevent - Use prepared statement and close resources

     [ https://issues.apache.org/jira/browse/CAMEL-9088?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

James Lindstorff updated CAMEL-9088:
------------------------------------
    Attachment: patch9088

Attached a patch that uses prepared statements in a try-with-resource, when performing listen, unlisten and notify.

In the consumer a unlisten is called in relation to the connection shutdown.

If using postgres 9.x there is an function pg_notify which could be better than using notify but I am not sure if requiring postgres 9 is a good trade off.

> camel-pgevent - Use prepared statement and close resources
> ----------------------------------------------------------
>
>                 Key: CAMEL-9088
>                 URL: https://issues.apache.org/jira/browse/CAMEL-9088
>             Project: Camel
>          Issue Type: Improvement
>            Reporter: Claus Ibsen
>            Priority: Minor
>             Fix For: Future
>
>         Attachments: patch9088
>
>
> The camel-pgevent component uses plain statement. We should use PreparedStatement and also close the resources after usage.
> Contributions is welcome.



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