SQL

JVM since1.0.0 Native since1.0.0

Perform SQL queries using Spring JDBC.

What’s inside

Please refer to the above links for usage and configuration details.

Maven coordinates

Or add the coordinates to your existing project:

<dependency>
    <groupId>org.apache.camel.quarkus</groupId>
    <artifactId>camel-quarkus-sql</artifactId>
</dependency>

Check the User guide for more information about writing Camel Quarkus applications.

Additional Camel Quarkus configuration

When configuring sql or sql-stored endpoints to reference script files from the classpath, set the following configuration property to ensure that they are available in native mode. Note that URI schemes such as file or http do not need to be listed.

quarkus.camel.sql.script-files = queries.sql, classpath:sql/insert.sql
Configuration property Type Default

quarkus.camel.sql.script-files

A comma separated list of paths to script files referenced by SQL endpoints. Script files that only need to be accessible from the classpath should be specified on this property. Paths can either be schemeless (E.g sql/my-script.sql) or be prefixed with the classpath: URI scheme (E.g classpath:sql/my-script.sql). Other URI schemes are not supported.

string

Configuration property fixed at build time. All other configuration properties are overridable at runtime.