Ce contenu n'est pas disponible dans la langue sélectionnée.
Chapter 38. JDBC
Access databases through SQL and JDBC.
38.1. What’s inside Copier lienLien copié sur presse-papiers!
-
JDBC component, URI syntax:
jdbc:dataSourceName
Please refer to the above link for usage and configuration details.
38.2. Maven coordinates Copier lienLien copié sur presse-papiers!
Create a new project with this extension on code.quarkus.redhat.com
Or add the coordinates to your existing project:
<dependency> <groupId>org.apache.camel.quarkus</groupId> <artifactId>camel-quarkus-jdbc</artifactId> </dependency>
<dependency>
<groupId>org.apache.camel.quarkus</groupId>
<artifactId>camel-quarkus-jdbc</artifactId>
</dependency>
38.3. Additional Camel Quarkus configuration Copier lienLien copié sur presse-papiers!
38.3.1. Configuring a DataSource Copier lienLien copié sur presse-papiers!
This extension leverages Quarkus Agroal for DataSource
support. Setting up a DataSource
can be achieved via configuration properties. It is recommended that you explicitly name the datasource so that it can be referenced in the JDBC endpoint URI. E.g like to("jdbc:camel")
.
quarkus.datasource.camel.db-kind=postgresql quarkus.datasource.camel.username=your-username quarkus.datasource.camel.password=your-password quarkus.datasource.camel.jdbc.url=jdbc:postgresql://localhost:5432/your-database quarkus.datasource.camel.jdbc.max-size=16
quarkus.datasource.camel.db-kind=postgresql
quarkus.datasource.camel.username=your-username
quarkus.datasource.camel.password=your-password
quarkus.datasource.camel.jdbc.url=jdbc:postgresql://localhost:5432/your-database
quarkus.datasource.camel.jdbc.max-size=16
If you choose to not name the datasource, you can resolve the default DataSource
by defining your endpoint like to("jdbc:default")
.
38.3.1.1. Zero configuration with Quarkus Dev Services Copier lienLien copié sur presse-papiers!
In dev and test mode you can take advantage of Configuration Free Databases. All you need to do is reference the default database in your routes. E.g to("jdbc:default")
.