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.