// Do not edit directly!
// This file was generated by camel-quarkus-maven-plugin:update-extension-doc-page
= SQL
:page-aliases: extensions/sql.adoc
:cq-artifact-id: camel-quarkus-sql
:cq-native-supported: true
:cq-status: Stable
:cq-description: Perform SQL queries using Spring JDBC.
:cq-deprecated: false
:cq-jvm-since: 1.0.0
:cq-native-since: 1.0.0

[.badges]
[.badge-key]##JVM since##[.badge-supported]##1.0.0## [.badge-key]##Native since##[.badge-supported]##1.0.0##

Perform SQL queries using Spring JDBC.

== What's inside

* xref:{cq-camel-components}::sql-component.adoc[SQL component], URI syntax: `sql:query`
* xref:{cq-camel-components}::sql-stored-component.adoc[SQL Stored Procedure component], URI syntax: `sql-stored:template`

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

== Maven coordinates

[source,xml]
----
<dependency>
    <groupId>org.apache.camel.quarkus</groupId>
    <artifactId>camel-quarkus-sql</artifactId>
</dependency>
----

Check the xref:user-guide/index.adoc[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.

[source,properties]
----
quarkus.camel.sql.script-files = queries.sql, classpath:sql/insert.sql
----


[width="100%",cols="80,5,15",options="header"]
|===
| Configuration property | Type | Default


|icon:lock[title=Fixed at build time] [[quarkus.camel.sql.script-files]]`link:#quarkus.camel.sql.script-files[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-legend]
icon:lock[title=Fixed at build time] Configuration property fixed at build time. All other configuration properties are overridable at runtime.

