FlexDeploy - JDBC PluginGuide
The JDBC plugin provides the ability to deploy SQL scripts to supported databases using JDBC.
Supported Versions
Any JDBC driver which is supported by the database vendor for the version you have installed is likely to be compatible with the FlexDeploy JDBC plugin. Supported databases include following.
- 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+
Key Features
- Vendor neutral implementation using JDBCÂ
- Oracle specific extensions for PL/SQL
Plugin Operations
Partial Deployment - Supported Object Types
JDBC Plugin supports partial deployment, see below for details on supported object types.
The JDBC plugin partial deploy support allows for deploying File and Folder type objects. These links explain the three types and their attributes. This functionality became available in the 4.5.1 release.
Object Types
See Appendix for more details.
The following macros are not currently supported in the footer:
- style