The SQL-JDBC plugin is database-independent. It can run SQL scripts in a specific order using JDBC drivers.
To use the plugin, open the process designer and navigate to Database > SQL JDBC in the Tools pane.
To use the plugin, open the process designer and navigate to Database > SQL JDBC Interactive in the Tools pane.
Execute SQL Scripts step
Use the Execute SQL Scripts step to run SQL scripts using a JDBC driver.
You need to set the following required properties for the step:
|Database JDBC Driver Name||The fully-qualified JDBC driver classname.|
|Driver Jar||The full path to the JDBC driver jar to use.|
The connection string to be used. used to connect to the database, for example:
|Username||The username used to connect to the database.|
|SQL Statement Delimiter||String that separates SQL statements.|
|Error Handling||Action to perform when a statement fails: continue, stop, or abort.|
|Column Name||SQL-JDBC-Interactive only: Column name to show values.|
You can set the following optional properties for the step:
|Password||The password of the username used to connect to the database.|
|Password Script||To use a script or property lookups for your password, leave the Password field blank and enter it here.|
|Files||A white-space or comma separated list of sqlfiles to run. These run in order, as opposed to files grabbed using Include Files. This also takes precedence meaning if this is set Include File box are ignored.|
|Include Files||Enter a new line separated set of file
filters for the sql scripts to execute.
|Exclude Files||Enter a new line separated set of file filters for the files to exclude from the execution.|
|Autocommit||Auto commit flag for database connection.|
|Print Result Sets||Print result sets from the statements.|