Database Management Plugins → SQL-JDBC Plugin → 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. |
Copyright © 2013–2018 Serena Software, Inc., a Micro Focus company. All rights reserved.