Executing multiple SQL statements with one tMysqlRow component

Overview

Explains how to execute multiple SQL statements using a single tMysqlRow component.

 

Environment

This procedure was written with:

  • Talend Open Studio for DI 5.0-r72978
  • JDK version: Sun JDK build 1.6.0_26-b03
  • Operating system: Windows XP SP3
  • Mysql 5.0.67-community-nt

Talend verified this procedure to be compatible with:

  • Data Integration releases: 4.2.3, 4.2.4, 5.0.0, 5.0.1, 5.0.2, 5.1.1, 5.1.2, 5.2.0

 

Procedure

By default, the MySQL JDBC driver does not allow multiple SQL statements in a single statement. Execution stops after the first semi-colon. However, a configuration parameter allows you to modify the default behavior. Update Additional JDBC Parameters to include "allowMultiQueries=true".

The following example Job demonstrates how to execute multiple SQL statements in a tMysqlRow component. The detailed job settings and explanation are as follows:

 1_025.png

 

 2_023.png

Version history
Revision #:
2 of 2
Last update:
‎06-22-2017 10:03 PM
Updated by:
 
Labels (1)
Tags (1)