SQL-JDBC - Overview

The SQL-JDBC plug-in automates SQL script runs by using a JDBC driver in a deploy process.

This plug-in includes two steps:

• Execute SQL Scripts
• Execute SQL Scripts with PassTicket Authentication

Compatibility

This plug-in requires IBM UrbanCode Deploy version 6.0.1 or later. As of version 9,Prepared Statements and Stored Procedure Calls are not supported.

Installation

No special steps are required for installation. See Installing plug-ins in UrbanCode Deploy.

History

Version 13

Log4j and Jettison dependency updated.

Version 11.986478

Fixes APAR PI96061: Add step properties allowing the user to specify SQL script encoding.

Version 10.953267

Added ability to keep formatting.

Version 9.917358

Plug-in now supports callable statements.

Version 9.879670

Added two new properties to both plug-in steps:

• Show Warnings: Send warnings to the standard output logs.
• Treat Warnings as Errors: If selected, SQL Warnings will be treated as errors.

Version 8

Support property file encryption.

Version 7

This release includes a fix for a class resolution error.

Version 6

This release includes a new step to run SQL scripts using PassTicket authentication.

Back to …		Latest Version	SQL-JDBC
All Plugins	Deploy Plugins	13.1154072	Readme	Troubleshooting	Usage	Steps	Downloads