Executes a SQL script. This operation parses the SQL script and processes each statement in the database using JDBC. Property replacement is performed on the files before they are parsed.
...
| Property Name | Property Code | Required | Description |
|---|---|---|---|
| JDBC URL |
| Yes | The JDBC URL of the database. |
| JDBC User |
| No | The username that will be used to connect with. |
| JDBC Password |
| No | The password of the username. |
| JDBC Driver Path |
| Yes | Classpath for locating the JDBC Driver (e.g. for Weblogic - |
Project Properties
Property Name | Property Code | Required | Description |
|---|---|---|---|
Inputs
| Input Name | Input Code | Required | Description |
|---|---|---|---|
| User |
| No | The username that will be used to connect with. This input takes precedence over the environment instance scoped |
| Password |
| No | The password for |
| Script File |
| Yes | The path to the script to execute. If a relative path is given, the path will be assumed to be in the |
| Run Destructive |
| No | This option allows destructive statements to be run. See Special Considerations below. |
| Ignore Compilation Warnings | FDJDBC_INP_IGNORE_WARNING | No | If checked, sql compilation warnings will be ignored. Otherwise, they will cause the execution to be marked as failed. For Oracle database, plugin will print errors from USER_ERRORS or DBA_ERRORS for the object being deployed. (@since 5.1.0.1). This support was modified slightly in 5.1.0.3 to read errors from USER_ERRORS first and then read from DBA_ERRORS if nothing found, previously it read from one or the other depending on if schema is coded in SQL statement. |
| Show DBMS Output | FDJDBC_INP_SHOW_DBMS_OUT | No | Print DBMS Output in the log. Only supported for Oracle Database. |
Outputs
Output Name | Required | Description |
|---|---|---|
Artifacts
This operation consumes one or more SQL files, and an optional sequence file, from the artifacts repository.
...