Execute SQL Scripts Step

This step executes SQL scripts using a JDBC driver.

Required properties:

Property Name Description
Database JDBC Driver Name The fully-qualified JDBC driver classname.
Driver Jar The full path to the JDBC driver jar to use.
Connection String The connection string to be used. used to connect to the database. For example: jdbc:mysql://dbhost:3306/mydb.
Username The user name 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 Column name to show values. (SQL-JDBC-Interactive Only)

Optional properties:

Property Name Description
Password The password of the user name 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 will run in order as opposed to files grabbed using Include Files. This also takes precedence meaning if this is set Include File box will be ignored.
Include Files Enter a new line separated set of file filters for the sql scripts to execute. Default-value="**/*.sql"
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.