> ## Documentation Index
> Fetch the complete documentation index at: https://docs.flexagon.com/llms.txt
> Use this file to discover all available pages before exploring further.

# packageBuild (JDBC)

> Collects a group of sql and other files to be run by the operation. Files can be populated from the SCM of your choice. See for information about the

Collects a group of sql and other files to be run by the [packageJdbcDeploy](https://docs.flexagon.com/flexdeploy-11-0-documentation/flexdeploy-plugin-guides/flexdeploy-jdbc-plugin-guide/packagedeploy-jdbc.md) operation. Files can be populated from the SCM of your choice. See [the appendix](https://docs.flexagon.com/flexdeploy-11-0-documentation/flexdeploy-plugin-guides/flexdeploy-jdbc-plugin-guide/appendix-jdbc/jdbc-package-object-types.md) for information about the project file attributes.

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`).

# Project Properties

<table><colgroup><col /><col /><col /><col /></colgroup><tbody><tr><th>**Property Name**</th><th>**Property Code**</th><th>**Required**</th><th>**Description**</th></tr><tr><td>Ignore Failure Default</td><td>`FDJDBC_IGNORE_FAILURE_DEFAULT`</td><td>No</td><td>When populating or evaluating files, set the Ignore SQL Compilation Errors attribute to true for files with these extensions.</td></tr><tr><td>Ignore Compile Error Extensions</td><td>`FDJDBC_IGNORE_COM_ERR_EXT_DEF`</td><td>No</td><td>When populating or evaluating files, set Ignore Failure to true for files with these extensions.</td></tr><tr><td>Property Replacement Default</td><td>`FDJDBC_PROPERTY_REPLACEMENT_DEFAULT`</td><td>No</td><td>When populating or evaluating files, default Property Replacement to this.</td></tr><tr><td>Retry Count Default</td><td>`FDJDBC_RETRY_COUNT_DEFAULT`</td><td>No</td><td>When populating or evaluating files, default the Retry Count to this. (0-5)</td></tr><tr><td>SQL Extension Order</td><td>`FDJDBC_SQL_EXTENSIONS`</td><td>No</td><td>The order of sql extensions that you want to use when populating and sorting files. Files should be sorted as needed 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"</td></tr><tr><td>Project File Includes</td><td>`FD_PARTIAL_FILE_INCLUDES`</td><td>No</td><td>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)</td></tr><tr><td>Project File Excludes</td><td>`FD_PARTIAL_FILE_EXCLUDES`</td><td>No</td><td>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)</td></tr></tbody></table>

# Artifacts

This operation produces package deploy file packages for use by the [packageJdbcDeploy](https://docs.flexagon.com/flexdeploy-11-0-documentation/flexdeploy-plugin-guides/flexdeploy-jdbc-plugin-guide/packagedeploy-jdbc.md) operation.

# Endpoint Selection

This operation will select all available endpoints associated to the target.

# Endpoint Execution

This operation will randomly execute on one of the endpoints identified during selection.

# Special Considerations

See below for information about the project file attributes.

# Supported Object Types

The JDBC plugin Package-Based deploy support allows for deploying File and Folder type objects. These links explain the three types and their attributes.

## Object Types

1. [DB Objects](https://flexagon.atlassian.net/wiki/spaces/FD11/pages/12395016473/JDBC+Object+Types+-+DB+Objects)

2. [Data Fixes](https://flexagon.atlassian.net/wiki/spaces/FD11/pages/12395016495/JDBC+Object+Types+-+Data+Fixes)

3. [Other Objects](https://flexagon.atlassian.net/wiki/spaces/FD11/pages/12395016517/JDBC+Object+Types+-+Other+Objects)
Property Name	Property Code	Required	Description
Ignore Failure Default	`FDJDBC_IGNORE_FAILURE_DEFAULT`	No	When populating or evaluating files, set the Ignore SQL Compilation Errors attribute to true for files with these extensions.
Ignore Compile Error Extensions	`FDJDBC_IGNORE_COM_ERR_EXT_DEF`	No	When populating or evaluating files, set Ignore Failure to true for files with these extensions.
Property Replacement Default	`FDJDBC_PROPERTY_REPLACEMENT_DEFAULT`	No	When populating or evaluating files, default Property Replacement to this.
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 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)