camel-jooq-kafka-connector sink configuration

Connector Description: Store and retrieve Java objects from an SQL database using JOOQ.

When using camel-jooq-kafka-connector as sink make sure to use the following Maven dependency to have support for the connector:

<dependency>
  <groupId>org.apache.camel.kafkaconnector</groupId>
  <artifactId>camel-jooq-kafka-connector</artifactId>
  <version>x.x.x</version>
  <!-- use the same version as your Camel Kafka connector version -->
</dependency>

To use this Sink connector in Kafka connect you’ll need to set the following connector.class

connector.class=org.apache.camel.kafkaconnector.jooq.CamelJooqSinkConnector

The camel-jooq sink connector supports 11 options, which are listed below.

Name Description Default Required Priority

camel.sink.path.entityType

JOOQ entity class

null

false

MEDIUM

camel.sink.endpoint.databaseConfiguration

To use a specific database configuration

null

false

MEDIUM

camel.sink.endpoint.lazyStartProducer

Whether the producer should be started lazy (on the first message). By starting lazy you can use this to allow CamelContext and routes to startup in situations where a producer may otherwise fail during starting and cause the route to fail being started. By deferring this startup to be lazy then the startup failure can be handled during routing messages via Camel’s routing error handlers. Beware that when the first message is processed then creating and starting the producer may take a little time and prolong the total processing time of the processing.

false

false

MEDIUM

camel.sink.endpoint.operation

Type of operation to execute on query One of: [EXECUTE] [FETCH] [NONE]

"NONE"

false

MEDIUM

camel.sink.endpoint.query

To execute plain SQL query

null

false

MEDIUM

camel.component.jooq.configuration

Component configuration (database connection, database entity type, etc.)

null

false

MEDIUM

camel.component.jooq.databaseConfiguration

To use a specific database configuration

null

false

MEDIUM

camel.component.jooq.lazyStartProducer

Whether the producer should be started lazy (on the first message). By starting lazy you can use this to allow CamelContext and routes to startup in situations where a producer may otherwise fail during starting and cause the route to fail being started. By deferring this startup to be lazy then the startup failure can be handled during routing messages via Camel’s routing error handlers. Beware that when the first message is processed then creating and starting the producer may take a little time and prolong the total processing time of the processing.

false

false

MEDIUM

camel.component.jooq.operation

Type of operation to execute on query One of: [EXECUTE] [FETCH] [NONE]

"NONE"

false

MEDIUM

camel.component.jooq.query

To execute plain SQL query

null

false

MEDIUM

camel.component.jooq.autowiredEnabled

Whether autowiring is enabled. This is used for automatic autowiring options (the option must be marked as autowired) by looking up in the registry to find if there is a single instance of matching type, which then gets configured on the component. This can be used for automatic configuring JDBC data sources, JMS connection factories, AWS Clients, etc.

true

false

MEDIUM

The camel-jooq sink connector has no converters out of the box.

The camel-jooq sink connector has no transforms out of the box.

The camel-jooq sink connector has no aggregation strategies out of the box.

Back to top