August 15, 2023

Scenario: Using PreparedStatement objects to query data – Docs for ESB 6.x

Scenario: Using PreparedStatement objects to query data

This scenario describes a four component job which allows you to link a table column
with a client file. The MySQL table contains a list of all the American States along
with the State ID, while the file contains the customer information including the ID of
the State in which they live. We want to retrieve the name of the State for each client,
using an SQL query. In order to process a large volume of data quickly, we use a
PreparedStatement object which means that the query is executed only once rather than
against each row in turn. Then each row is sent as a parameter. Note that
PreparedStatement object can also be used in avoiding SQL injection.

For this scenario, we use a file and a database for which we have already
stored the connection and properties in the Rerpository metadata. For
further information concerning the creation of metadata in delimited files, the creation
of database connection metadata and the usage of metadata, see
Talend Studio
User Guide.

Document get from Talend
Thank you for watching.
Notify of
Inline Feedbacks
View all comments
Would love your thoughts, please comment.x