cSQL
Reads from and writes to any database using a SQL connection based on a query.
cSQL Standard properties
These properties are used to configure cSQL running in the Standard Route framework.
The Standard cSQL component belongs to the Connectivity family.
Basic settings
| Properties | Description |
|---|---|
|
Datasource |
Select the component that opens the database connection to be reused by this component. |
| Use SQL statement from message body |
Select this check box if your query statement is specified in the message body. |
| Query | Specify a database query statement, paying particularly attention to the properly sequence of the fields which must correspond to the schema definition. |
Advanced settings
| Properties | Description |
|---|---|
|
URI Options |
Set the optional arguments in the corresponding table. Click [+] as many times as required to add arguments to the table. Then click the corresponding Value field and enter a value. See the site https://camel.apache.org/components/3.11.x/sql-component.html for available URI options. |
Usage
| Usage guidance | Description |
|---|---|
|
Usage rule |
cSQL can be a start, middle or end component in a Route. It has to be used with the cSQLConnection component, which creates a connection to the database. For more information about cSQLConnection, see cSQLConnection. |
|
Limitation |
n/a |