camel-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Lindstorff (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CAMEL-9088) camel-pgevent - Use prepared statement and close resources
Date Fri, 28 Aug 2015 05:45:45 GMT

     [ 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)

Mime
View raw message