pfx-sql:truncate

Truncates an entire database table.

Properties

Option

Type

Default

Description

Option

Type

Default

Description

dataSource

string

dataSource

Defines a Data Source name.

table

string

 

Defines a DB table.

Examples

Truncates a table defined in the URI parameter of the pfx-sql component.

<routes xmlns="http://camel.apache.org/schema/spring"> <route> <from uri="direct:sql-truncate"/> <to uri="pfx-sql:truncate?dataSource=dataSource&amp;table=QUOTE_WORKFLOW_HISTORY"/> </route> </routes>

 

IntegrationManager version 5.8.0