Chapter 38. JDBC
Access databases through SQL and JDBC.
38.1. What’s inside 复制链接链接已复制到粘贴板!
-
JDBC component, URI syntax:
jdbc:dataSourceName
Please refer to the above link for usage and configuration details.
38.2. Maven coordinates 复制链接链接已复制到粘贴板!
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 复制链接链接已复制到粘贴板!
38.3.1. Configuring a DataSource 复制链接链接已复制到粘贴板!
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 复制链接链接已复制到粘贴板!
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")
.