Executes a group of sql files and copies "Other" files to specified destinations from a package created by the partialJdbcBuild operation.
Please note that the statements in the SQL files must be delimited properly.
The SQL Databases supported by the parser are:
- Oracle 10g+
- Using statement delimiter of ;
- PL/SQL blocks starting with DECLARE or BEGIN and finishing with END; /
- MySql 5.1+
- PostgreSql 9.0+
- Derby 10.8.2.2+
- SAP HANA
- SQL Server 2008+
- MariaDB 10.0+
- Vertica 6.5+
- H2 1.2.137+
- solidDB 6.5+
- SQL Azure
- DB2 9.7+
- AWS Redshift
- Hsql 1.8+
- Sybase ASE12.5+
- SQLite 3.7.2+
- DB2 z/OS 9.1+
- EnterpriseDB 9.4+
- Phoenix 4.2.2+
- Greenplum 4.3+
No JDBC drivers are included in the plugin, so the path to one is required (FDJDBC_DRIVER_PATH).
Environment/Instance Properties
| 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 |
|---|---|---|---|
| Ignore Failure Default | FDJDBC_IGNORE_FAILURE_DEFAULT | No | When populating or evaluating files, default Ignore Failure to this. |
| Property Replacement Default | FDJDBC_PROPERTY_REPLACEMENT_DEFAULT | No | When populating or evaluating files, default Property Replacement to this. |
| SQL Root Target Folder | FDJDBC_SQL_ROOT_TARGET_FOLDER | No | The path to store the delivered Sql files. Sql files will be run from here. Leave blank to run them from the FD_TEMP_DIR. |
| Other Root Target Folder | FDJDBC_OTHER_ROOT_TARGET_FOLDER | No | The path to store the delivered Other files. Leave blank to store them in the FD_TEMP_DIR. |
| Retry Count Default | FDJDBC_RETRY_COUNT_DEFAULT | No | When populating or evaluating files, default the Retry Count to this. (0-5) |
SQL Extension Order | FDJDBC_SQL_EXTENSIONS | No | The order of sql extensions that you want to use when populating and sorting files. Files should be sorted as needed before at or before build time. Defaults to "seq,tbl,idx,typ,tps,tpb,sql,pkh,plb,pks,pkb,pls,pck,fnc,trg,spc,bdy,prc" |
| Project File Includes | FD_PARTIAL_FILE_INCLUDES | No | Controls files included in Project Files. Enter expressions separated by ##. Leave empty to select all files. Begin or end the expression with * for simple wildcards. Otherwise, regex is used. (e.g. /java/*##*.java##*person*##/java/.*[tT]est.*\.java) |
| Project File Excludes | FD_PARTIAL_FILE_EXCLUDES | No | Controls files excluded from Project Files. Enter expressions separated by ##. Leave empty to select all files. Begin or end the expression with * for simple wildcards. Otherwise, regex is used. (e.g. /java/*##*.java##*person*##/java/.*[tT]est.*\.java) |
Inputs
| Input Name | Input Code | Required | Description |
|---|---|---|---|
| Run Destructive |
| No | This option allows destructive statements to be run. See Special Considerations below. |
Outputs
Output Name | Required | Description |
|---|---|---|
Artifacts
This operation consumes packages of files created by the partialJdbcBuild operation.
Endpoint Selection
This operation will select all available endpoints associated to the environment/instance.
Endpoint Execution
This operation will randomly execute on one of the endpoint identified during selection.