Chapter 262. PostgresSQL Event Component Available as of Camel version 2.15 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: <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: 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&... 262.1. Options The PostgresSQL Event component has no options. The PostgresSQL Event endpoint is configured using URI syntax: with the following path and query parameters: 262.1.1. Path Parameters (4 parameters): Name Description Default Type host To connect using hostname and port to the database. localhost String port To connect using hostname and port to the database. 5432 Integer database Required The database name String channel Required The channel name String 262.1.2. Query Parameters (7 parameters): Name Description Default Type datasource (common) To connect using the given javax.sql.DataSource instead of using hostname and port. DataSource bridgeErrorHandler (consumer) Allows for bridging the consumer to the Camel routing Error Handler, which mean any exceptions occurred while the consumer is trying to pickup incoming messages, or the likes, will now be processed as a message and handled by the routing Error Handler. By default the consumer will use the org.apache.camel.spi.ExceptionHandler to deal with exceptions, that will be logged at WARN or ERROR level and ignored. false boolean exceptionHandler (consumer) To let the consumer use a custom ExceptionHandler. Notice if the option bridgeErrorHandler is enabled then this option is not in use. By default the consumer will deal with exceptions, that will be logged at WARN or ERROR level and ignored. ExceptionHandler exchangePattern (consumer) Sets the exchange pattern when the consumer creates an exchange. ExchangePattern synchronous (advanced) Sets whether synchronous processing should be strictly used, or Camel is allowed to use asynchronous processing (if supported). false boolean pass (security) Password for login String user (security) Username for login postgres String 262.2. Spring Boot Auto-Configuration The component supports 2 options, which are listed below. Name Description Default Type camel.component.pgevent.enabled Enable pgevent component true Boolean camel.component.pgevent.resolve-property-placeholders Whether the component should resolve property placeholders on itself when starting. Only properties which are of String type can use property placeholders. true Boolean 262.3. See Also Configuring Camel Component Endpoint Getting Started

Commands:
<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>
pgevent:datasource[?parameters] pgevent://host:port/database/channel[?parameters]
pgevent:host:port/database/channel