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