Database Management Plugins → SQL-JDBC Plugin → Execute SQL Scripts Step
This step executes SQL scripts using a JDBC driver.
|Database JDBC Driver Name
|The fully-qualified JDBC driver classname.
|The full path to the JDBC driver jar to use.
|The connection string to be used. used to connect to the database. For example: jdbc:mysql://dbhost:3306/mydb.
|The user name used to connect to the database.
|SQL Statement Delimiter
|String that separates SQL statements.
|Action to perform when a statement fails: continue, stop, or abort.
|Column name to show values. (SQL-JDBC-Interactive Only)
|The password of the user name used to connect to the database.
|To use a script or property lookups for your password, leave the Password field blank and enter it here.
|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.
|Enter a new line separated set of file filters for the sql scripts to execute. Default-value="**/*.sql"
|Enter a new line separated set of file filters for the files to exclude from the execution.
|Auto commit flag for database connection
|Print Result Sets
|Print result sets from the statements.
Copyright © 2013–2017 Serena Software, Inc., a Micro Focus company. All rights reserved.