SQL
JVM since1.0.0 Native since1.0.0
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
Configuration property | Type | Default |
---|---|---|
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. |
|
Configuration property fixed at build time. All other configuration properties are overridable at runtime.