Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

PGEvent Component (PostgresSQL Event)

This is a component for Apache Camel which allows for Producing/Consuming PostgreSQL events related to the LISTEN/NOTIFY commands added since PostgreSQL 8.3.

Maven users will need to add the following dependency to their pom.xml for this component:

Code Block
xml
xml
<dependency>
    <groupId>org.apache.camel</groupId>
    <artifactId>camel-pgevent</artifactId>
    <version>x.x.x</version>
    <!-- use the same version as your Camel core version -->
</dependency>

URI format

The pgevent component uses the following two styles of endpoint URI notation:

Code Block
pgevent:datasource[?parameters]
pgevent://host:port/database/channel[?parameters]

 

You can append query options to the URI in the following format, ?option=value&option=value&...

Options

Div
classconfluenceTableSmall

Option

Type

Default

Description

datasource

String

 

Name of datasource to lookup from the registry to use

hostname

StringlocalhostInstead of using datasource, then connect to the PostgresSQL database using this hostname and port
portint5432Instead of using datasource, then connect to the PostgresSQL database using this hostname and port
databaseString The database name
channelString The channel name
userStringpostgresUsername
passString Password

 

Include Page
Endpoint See Also
Endpoint See Also