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.