[CAMEL-19119] [Docs] Missing examples in Camel JDBC

• Type: Task
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.20.2
• Fix Version/s: 3.20.3, 3.21.0, 4.0-M3, 4.0.0
• Component/s: camel-jdbc, documentation
• Estimated Complexity: Unknown
• Assignee: Unassigned
• Reporter: Lucia Drozdová
• Created: 06/Mar/23 10:07
• Updated: 06/Mar/23 12:52
• Resolved: 06/Mar/23 12:52

Description

There are several examples missing in jdbc component documentation:

https://camel.apache.org/components/3.20.x/jdbc-component.html#_samples

1. First we register our datasource in the Camel registry as testdb:
2. Then we configure a route that routes to the JDBC component, so the SQL will be executed. Note how we refer to the testdb datasource that was bound in the previous step:
3. Or you can create a DataSource in Spring like this:
4. We create an endpoint, add the SQL query to the body of the IN message, and then send the exchange. The result of the query is returned in the OUT body: