SQL

Since Camel Quarkus 1.0.0-M2, JVM and native

Perform SQL queries using Spring JDBC.

What’s inside

SQL component, URI syntax: sql:query
SQL Stored Procedure component, URI syntax: sql-stored:template

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

Maven coordinates

<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